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

VmovSmRYSXFYR2hGWW9kZVc2OTNLRnY4
  • InvestM Technology LLC
  • San Jose, 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

New Horizon Foods

Dining Server Job at New Horizon Foods

 ...Dining Server Location: Stonebrook village No late nights flexible shifts Daily Pay Available! We are seeking a Dining Server to join our team. The ideal candidate will have a positive attitude, excellent customer service skills, and the ability to work... 

Rodolph Brothers, Inc.

Climbing Arborist (Mills) Job at Rodolph Brothers, Inc.

 ...employees that are employed year-round (due to our extensive commercial snow removal operation). We currently have 4 ISA certified arborists on staff, and we are searching for another climbing arborist to fit the needs of a strong team environment within the Tree Care... 

Merryhill School

Before and Afterschool Counselor Job at Merryhill School

 ...curriculum, innovative instruction, and a vibrant school community. A career with Merryhill offers opportunities in education, summer camps, before and after school programs, and regional management with the support of our parent company, Spring Education Group. About... 

Christus Health

Multiskilled Radiology Technologist-Radiology Diagnostic-PRN Job at Christus Health

 ...Technologist will competently function in two (2) or more modalities within the Imaging Department. This can include Diagnostic Radiology, MRI, CT, Ultrasound, Special Procedures, Nuclear Medicine, or Mammography. Performs various technical procedures requiring independent... 

Sysco

Local CDL-A Driver - Home Daily - Earn Up to $100k/Yr + $7.5k Sign-On Job at Sysco

 ...Job Description Sysco is now Hiring Local CDL-A Drivers in Columbus, OH!\nHome Daily - Earn Up to $100,000/Year* - Up to $7,500 Sign-On Bonus*\...  ...provided)\n \n\n Benefits: \n\n \n\t Local routes - Home daily \n\t Earn up to $100,000 per year including...