Snowflake Data Engineer (W2 Only) Job at InvestM Technology LLC, Santa Rosa, CA

WEtDTmdkeDBXeEROdU5nc0k0N2xJSkJ2RUE9PQ==
  • InvestM Technology LLC
  • Santa Rosa, 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

Raybrex Dental Recruiting

Associate dentist Job at Raybrex Dental Recruiting

We are seeking a dedicated and skilled Associate Dentist to join our dynamic dental PPO/FFS practice. The ideal candidate will possess a strong commitment to patient care and demonstrate proficiency in various dental procedures. Daily guarantee $ 700-$1,000.00 daily pending... 

Catalyst Life Sciences

Operations Project Manager Job at Catalyst Life Sciences

 ...partnered with a large and fast growing pharma company for their Houston, TX facility. Ideal candidates should be coming from a project management background with a proven record of customer service optimization or operations focused projects. Day to day you will: Lead... 

Hearst Digital Marketing Services

Digital Account Executive Job at Hearst Digital Marketing Services

 ...strategies. Access to existing scripts and coaching resources. Training on prospecting tools and best practices. Utilize our online learning management system. Benefit from best-in-class sales tools, including Salesforce and Gong. Currently accepting... 

Founding Farmers Restaurant Group

Executive Sous Chef Job at Founding Farmers Restaurant Group

 ...EXECUTIVE SOUS CHEF Starting Salary: $100K/YR Our Executive Sous Chefs are a vital part of our restaurant management team. They assist the Executive Chef to lead our entire culinary team. The Executive Sous Chef is committed to leading our team, assisting in daily... 

Tutor Doctor

Summer Reading/Math Tutor Job at Tutor Doctor

Join Our Team as an In-Home/Person Tutor!Are you a dedicated educator passionate about helping students succeed? Tutor Doctor Charlotte is seeking skilled tutors in elementary reading and math to provide personalized, in-home instruction to local students. This is a...