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

bVZZTDc1Q3dPT0J6OVlVZGZ0d09aMFVYOEE9PQ==
  • InvestM Technology LLC
  • San Jose, 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

BEPC Inc. - Business Excellence Professional Consulting

Research Associate Job at BEPC Inc. - Business Excellence Professional Consulting

 ...Bepc, Inc has an open position for a Research Associate II in South San Francisco, CA!! W2 Contract 3 years Pay and Benefits-$38-$44 an hour-Medical, Dental, Vision, Paid Life Insurance We are seeking a highly motivated contractor to support discovery efforts... 

Celertek

Senior Technical Recruiter Job at Celertek

 ...Celertek, a technology staffing firm supporting mid-market clients, is hiring internally for...  ...with recent experience at a staffing agency ideally supporting mid-market accounts...  ...DC Metro tech ecosystem ~ Comfortable working in a hybrid role (in-office and remote)... 

Beacon Partners

Graphic Designer Job at Beacon Partners

 ...Graphic Designer will produce high quality, professional and compelling marketing materials that promote the Beacon brand and our industrial, office and mixed-use properties throughout the Carolinas. This highly organized, creative candidate has a keen eye for details,... 

Arhaus

Store Manager Job at Arhaus

 ...the world who share our vision, creating beautiful, heirloom-quality pieces that can be usedand lovedfor generations. The Store Manager takes ownership of all aspect of the business at the store level. This individual drives sales in order to consistently exceed business... 

Global Connect Technologies

Controls Engineer Job at Global Connect Technologies

Job Title: Controls Engineer Location: Whitakers, NC Client: Cummins Job Description Looking for an experience controls engineer that can assist with the machining area & production line work orders as well as handle project-based work in the plant. Assist...