Snowflake Developer (Data Warehouse Design & SQL)
O
Open Systems Technologies
📍 Montreal, QC, Canada
Job Description
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 Jenkin...