Snowflake Developer (Data Warehouse Design & SQL)

Snowflake Developer (Data Warehouse Design & SQL)

Location: Montreal (day 1 onboarding onsite/in-office presence required 3x/week)

Years of Experience: 5-7

Snowflake Developer with strong expertise in Data Warehouse design and SQL development. The candidate will be responsible for designing and building a scalable data warehouse layer on Snowflake, creating schemas, views and optimizing data models for analytics and reporting.

Key Responsibilities

• Design and implement enterprise-grade data warehouse architectures on Snowflake.
• Develop and manage dimensional data models, including fact and dimension tables using star and snowflake schemas.
• Plan and execute data migrations from legacy and existing databases to Snowflake, ensuring data integrity and consistency.
• Develop and optimize SQL queries and views to support reporting and downstream data consumption.
• Implement performance tuning techniqu...