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

ZjFVVHh5S3ZTRDI0UmsrQXU0MExtRTl2K3c9PQ==
  • InvestM Technology LLC
  • San Mateo, 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

Enchanté Accessories

Graphic & Packaging Designer Job at Enchanté Accessories

 ...Figma, or CAD ~ Bachelor's degree in Graphic Design or related field ~2+ years of experience in graphic design, preferably in the food or packaging industry ~ Strong portfolio showcasing design skills and experience ~ Proficiency in design software, such as Adobe... 

THRIVE BEYOND DREAMS

Leadership Education Consultant (Remote) Job at THRIVE BEYOND DREAMS

 ...purpose-driven role that allows you to use your life experience and leadership skills to support others? Were looking for individuals who...  ...Dreams specializes in leadership development and success education. We offer digital training programs, virtual events, and mentorship... 

Saint-Gobain North America

Director, Compensation Job at Saint-Gobain North America

Whats the job? The Director, Compensation is a key member of the Saint-Gobain Total Rewards leadership team reporting to the Vice President, Total Rewards. This position is responsible for directing a team of six in managing the strategy, plan design, communications, ...

Omega Holdings

HVAC Electrical Engineer/Designer Job at Omega Holdings

 ...development of new product. Development of wiring harness design. Development of electrical schematics Maintains day to day engineering design activities. Write project documentations. Assists R&D Engineer who builds, install and test Proto-type automotive AC... 

United Counseling Services

Staffed Living Program Coordinator Job at United Counseling Services

 ...knowledgeable about DS Public Safety clients, stay informed about their status, and ensure the completion of required public safety documentation. The Program Coordinator for Staffed Living serves as the Service Coordinator for clients in Staffed Living, ensuring all...