Snowflake Developer (Data Warehouse Design & SQL)

Job Title : 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 techniques, including clustering, query optimization, and warehouse best practices within Snowflake.
• Build and maintain CI / CD pipelines using Jenkins to support reliable and automated deployments.
• Manage version control, code reviews, and release deployments using GitHub.

Required Skills & Experience

Preferred Skills