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

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

Similar Jobs

MFA

Senior Coordinator, Office of the President & CEO Job at MFA

 ...Position Title : Senior Coordinator, Office of the President & CEO Location : Washington, D.C. (Hybrid) Company Background: MFA, based in Washington, DC, New York, Brussels, and London, represents the global alternative asset management industry. MFAs mission... 

Patterson & Company CPAs

Administrative Specialist / Tax / Receptionist Job at Patterson & Company CPAs

Administrative Specialist/Tax/Receptionist Patterson & Company CPAs is seeking a reliable, organized Office Assistant/Receptionist to perform day-to-day administrative and clerical tasks. The successful applicant will have a positive attitude, a desire to work as efficiently...

Andiamo

Sales Management Trainee (entry level) Job at Andiamo

 ...of our business, propelling our clients to unparalleled success. Role Description This is a full-time position as a Sales Management Trainee at Andiamo and is an on-site role located in Austin,TX. As a Sales Manager in Training, you'll embark on a... 

TGS International Group

Data Center Engineer Job at TGS International Group

Data Centre Engineer - Field Location: Denver, Colorado, USA We are seeking a Data Center Engineer to join a global telecom and data infrastructure provider. This hands-on, field-based role supports new data center builds, performs installations, and responds to...

Digital Prospectors

Biorepository Associate Job at Digital Prospectors

 ...Position: Biorepository Associate Location: Redwood City, CA (Onsite First Shift) Length: 6+ months Job Description: Our client is seeking a detail-oriented and dependable Biorepository Associate to support its biospecimen management operations in a fast...