Snowflake Data Engineer (W2 Only) Job at InvestM Technology LLC, San Mateo, CA

ZjFVVHh5S3ZTRDI0UmsrQXU0MExtRTl2K3c9PQ==
  • InvestM Technology LLC
  • San Mateo, CA

Job Description

We are seeking a Senior Snowflake Developer. The ideal candidate will be responsible for designing, developing, testing, deploying, and maintaining enterprise-level applications using the Snowflake platform.

Location: Hybrid

  • Sacramento, CA (3 days in office)

Visa Status:

  • USC/GC/GC-EAD/H4-EAD accepted
  • W2 only (No visa sponsorship available)
  • No 3rd party or C2C candidates

Responsibilities:

  • Design and implement features for identity and access management.
  • Implement novel query optimization, major security competencies with encryption.
  • Solve performance issues and scalability issues in the system.
  • Create, test, and implement enterprise-level apps with Snowflake.
  • Data warehousing concepts, data modeling, metadata management

Mandatory Qualifications:

  • 10 years of experience in database development
  • 5 years of experience in Snowflake development and administration
  • Bachelors degree or 7 yrs hands-on experience

Preferred Qualifications:

  • Knowledge of SQL language and cloud-based technologies
  • Profound knowledge and hands-on experience in Snowflake Platform Architecture.
  • Proficient in SQL for data validation and querying, with experience in Snow SQL scripts.
  • Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake.
  • Extensive experience in T-SQL stored procedures and complex query development.
  • Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans.
  • Experience with productionized data ingestion and processing pipelines using Snow SQL
  • Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns.
  • Strong ability in documenting design solutions effectively.
  • Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway.
  • Experience in integrating snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus.
  • Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is a plus.

Job Tags

Similar Jobs

Belcan

Project Manager Job at Belcan

Job Description Job Title: IT Project Manager Location: Normal Illinois - This role is hybrid (3 days onsite and 2 days remotely) Duration: 5 Months Qualifications * Bachelor's degree in Computer Science, Electrical Engineering, Systems Engineering, or ...

Metal Arts

Sr. Steel Detailing Checker & Outsource Manager $70,000-$110,000 Job at Metal Arts

Metal Arts, LLC in Wichita, Kansas, is seeking a Detailing Checker and Outsource Detailing Manager with extensive experience in Steel Detailing, Checking, and Outsource Management. This position reports to the director of Detailing. Our detailers maintain a high level... 

Reviver Global

Vietnamese Consecutive Interpreter Job at Reviver Global

 ...Job Title: Vietnamese Remote Consecutive Interpreter - On-Demand Location: Remote Job Type: Independent Contractor Experience Level: Experienced A 360 Smart Lingo consecutive, over-the-phone interpreter and video Remote Interpreter plays a crucial role in... 

Thorlabs

U.S. Controller Job at Thorlabs

 ...boundaries of photonics and laser innovation, and we know that our people are at the core of our success. We are seeking a dynamic Controller for the U.S. to assist in the oversight of the corporate accounting department for the accurate and timely dissemination of... 

The Bridger Group

Structural Engineer Job at The Bridger Group

 ...strong promote-from-within culture. They have grown quickly and are looking to add additional engineers for their team. Responsibilities: Develop safe and economical structures that fulfill project requirements. Use software for frame, secondary, bracing, crane,...