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

Net2Source Inc.

Microbiology Technician Job at Net2Source Inc.

 ...discipline Years of experience: 2-4 years (Ideally 3) More focused on industry experience than education (Minimum is Bachelors) Medical device industry experience Preferred; Pharmaceutical can also work. Job Description: Reporting to the Microbiology Lab... 

Ethos Veterinary Health

Radiation Oncology Certified Veterinary Technician, PCVRH Job at Ethos Veterinary Health

 ...anticipate doctor needs during radiation therapy, diagnostics, and patient exams In addition to expanding services in oncology and neurology, some highlights include: 17 Exam Rooms 2 Comfort Rooms 11 Wet and 20 Dry Treatment Tables 6 Surgery Suites and... 

Peckham Industries

Concrete Pour Crew Member (Req #: 967) Job at Peckham Industries

 ...family by choice ethos delivers value as the trusted supplier of construction materials, products, and services in the communities we serve....  ...and equipment. Check the concrete forms to make sure they are secure and properly braced to receive concrete. 5. Communicate... 

Matlen Silver

Engineering Technician Job at Matlen Silver

 ...Technician, Engineering Location: Mahwah, New Jersey Pay: $25-$26/hour W2 Duration: 1+ year contract Job Summary: We are seeking a hands-on and detail-oriented Engineering with a strong background in CNC machinery, assembly processes, and regulated manufacturing... 

INVOKE

Sr. Databricks Engineer Job at INVOKE

 ...Engineering Professional certification & required classes. ~ Minimum 6-8+ projects delivered with development hands-on experience using databricks. ~ Working knowledge of two or more common Cloud ecosystems (AWS, Azure, GCP) with deep expertise in at least one. ~ Deep...