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

dVVQQmVHYkhrR3BrdjJXdTNQcHhxcWpWQ3c9PQ==
  • 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

BEPC Inc. - Business Excellence Professional Consulting

HR Systems Data Analyst Job at BEPC Inc. - Business Excellence Professional Consulting

 ...Job Title: HR Operations Data Analyst Location: Newark, NJ (On-site 4 days/week) Employment...  ...Data Analyst to support our client's People and Places (P&P) team. This role is...  .... ~ Strong problem-solving and analytical skills. ~ Excellent interpersonal and... 

Big Tex Trailers

Materials Manager Job at Big Tex Trailers

 ...Job Overview The Materials Manager is responsible for purchasing, receipt, control, and storage of Raw and Finished Goods materials inventory within a multi-site territory assignment including Texas and Oklahoma locations. The role is responsible for executing the materials... 

Ricoh USA, Inc.

Delivery Driver Job at Ricoh USA, Inc.

 ...The Delivery & Set-Up Driver is tasked with the efficient and high-quality pick-up, relocation, and delivery of office equipment in a safe manner. This role may involve the installation and networking of equipment upon delivery to customers. The professionalism and quality... 

Midtown Athletic Clubs

Facilities Manager Job at Midtown Athletic Clubs

 ...Midtown is looking for a Facilities Manager to add to our world-class organization in Weston, Florida (2300 Royal Palm Blvd, Weston, FL 33326). Check out our beautiful club here: Midtown is committed to delivering world-class hospitality to members and we understand... 

Medix™

Risk Adjustment Medical Coder - 239180 Job at Medix™

Job Title: Risk Adjustment Medical Coder (hybrid) Location: Must be open to traveling within the 5 boroughs 2-3 days in the field, remaining days can be remote Duration: Contract to Hire Pay: up to $51/hr DOE Shift: M-F day shift Requirements...