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

Coney Island Prep

High School Vice Principal of Academic Inclusion Job at Coney Island Prep

 ...compliance, and instructional quality for special populations, including students with...  ...minded leader with deep knowledge of special education and inclusive practices. You coach...  ...diverse learners. Collaborate with our Director of Academic Inclusion and other Vice Principals... 

VMSC Emergency Medical Services

Grants and Philanthropy Manager Job at VMSC Emergency Medical Services

 ...impact of our mission. Thats where you come in. About the Role VMSC is seeking a highly experienced, self-directed Grants and Philanthropy Manager to launch and lead a comprehensive development function. This is not a support roleits a builders role. Youll... 

FetchMe

Catering Delivery Driver Job at FetchMe

 ...reliable, deliver great customer service and be able to use your own vehicle to make deliveries. It is that simple. Most deliveries take about 30 minutes between the hours of 9 and 2 and drivers average $30-$45 earned per delivery and take place between 9-2pm.This a great... 

Thind Management

Hotel Assistant General Manager Job at Thind Management

 ...Introduction Welcome to Thind Management, a family-owned management company where we strive to provide exceptional service and unforgettable...  ...Assistant General Manager in a full-service or limited-service hotel who plays a vital role in supporting the overall management and... 

Allied Personnel Services

Trade Compliance Associate Job at Allied Personnel Services

Allied Personnel Services is seeking candidates for a Trade Compliance opening! This long term temporary role is an excellent opportunity to work for one of the Lehigh Valley's top manufacturers! Hours are full time, Mon-Fri, 8a-5p. Pay is $23.00/hr. Responsibilities...