Snowflake Senior Developer W2 role

Job Description: Job Title: Snowflake Senior Developer
Work Location: ChicagoIL60604

Target Start Date: 05 Sep 2026
**hybrid**Need to work from Chicago office weekly 3 days**

Job Details:

Must Have Skills
Strong handson knowledge with Snowflake and SQL of at least 5 years
Strong knowledge in data ingestion (no ETL) and data warehousing concepts
Hands on with dimensional model, data vault model and medallion architecture

Nice to have skills
Hands on experience in Python preferred
Experience in Asset or Wealth Management is a big plus

Detailed Job Description
* Strong hands-on knowledge with Snowflake and SQL of at least 5 years
* Strong knowledge in data ingestion (no ETL) and data warehousing concepts
* Hands on with dimensional model, data vault model and medallion architecture
* Hands on experience in Python preferred
* Experience in Asset or Wealth Management is a big plus

Minimum years of experience
8-10 years

Certifications Needed :No

Top 3 responsibilities you would expect the Subcon to shoulder and execute
Data Modeling Architecture Architect cloudnative Snowflake data warehouses, implementing starsnowflake schemas and optimizing dimensional models.
Strong knowledge in data ingestion no ETL and data warehousing concepts
Hands on experience in Python preferred