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

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

FOOTBRIDGE BREWERY

Server/Waitstaff Job at FOOTBRIDGE BREWERY

 ...Footbridge Brewery in Boothbay Harbor, ME is looking for seasonal servers/waitstaff to join our team. We are located on 25 Granary Way....  ...customer experience We are a brewery first, so learning about the beer we make is a must Check customers identification to confirm... 

CVR Associates

Mobility Counselor Job at CVR Associates

 ..., including, but not limited to data entry, office organization, filing, copying...  ...duties as assigned.QualificationsBachelors degree in Psychology, sociology, social services, human services...  ...necessary.Interacts well with all levels of personnel.Possess strong... 

Sedano’s

Hot Food Clerk Job at Sedano’s

 ...tienda surtida y organizada, y brindar un excelente servicio al cliente de manera regular. Position Summary Food Servers in the Hot Foods Department attend to customer requests for prepared food that is sold by the pound or individual servings and ensure customer... 

SeekTeachers

Primary PE Teacher Job at SeekTeachers

 ...from Early Years to Year 13 adopting the National English Curriculum and IBDP programme.The school network has provided quality education to over 10,000 students, spanning from infancy to tertiary, across 20 locations in Hong Kong and mainland China. The international... 

Seabrook Village by Erickson Senior Living

Certified Home Health Aide (CHHA) Job at Seabrook Village by Erickson Senior Living

 ...Location: Seabrook Village by Erickson Senior Living We are hiring Home Care Aides for our award-winning retirement community. Do what you love....  ..., and mission What you will need: Current Certified Home Health certification for the state in which you are working. 1-2...