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

UGRUVXhwT0NmeXpOQ3FkancxM1pXVTVYUUE9PQ==
  • InvestM Technology LLC
  • Sonoma, 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

Visa sponsorship,

Similar Jobs

United States Postal Service

Electrical Technician Job at United States Postal Service

 ...equipment. EXAMINATION REQUIREMENTS: Applicants must successfully complete Postal Service Test 955, for the Electronics Technician job group, which measures maintenance knowledge, skills and abilities. In addition, applicants must successfully complete a... 

Acumen

Executive Coach Job at Acumen

 ...Lead. Coach. Multiply Your Impact. Are you a former CEO, Owner, or President ready to leverage your experience in a new way? At Acumen, we invite accomplished leaders to step into a purpose-driven season-where your wisdom becomes a platform for transformation,... 

Source One Technical Solutions

Entry-level Drivers Job at Source One Technical Solutions

 ...Collection (Driver) Location: Los Angeles, CA Pay Rate: $25/hr (W-2) Shifts are available 7 days a week for weekdays or weekends Day Shift: 6:45am-3:15pm or 7:45am-4:15pm Night Shift: 2:45pm-11:15pm or 3:45pm-12:15am Wednesday-Sunday, Thursday-Monday... 

bealls

bealls Temporary New Store Associate Job at bealls

 ...follow multi-step processes # Utilization of Zebra PDA and POS Systems # Ability to work varying hours including early mornings, days, mid shifts, nights, weekends, and holidays PHYSICAL DEMANDS: # Must have adequate vision, speech, hearing, and physical ability... 

The LiRo Group

Project Manager Job at The LiRo Group

 ...Our Program and Construction Management division has an immediate need for a Project Manager for our Parks Program....  ...management solutions. You can become part of an organization that has a strong...  ...we have delivered on that label time and again. Recently, Global...