Snowflake Developer (Data Warehouse Design & SQL)

Summary:

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

Years of Experience: -

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.

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:

• Strong hands-on experience with Snowflake, including schema design, performance tuning, and platform best practices.
• Advanced SQL skills with experience building complex views and transformations, alongside a strong understanding of data modeling, clustering, partitioning, and query optimization techniques.
• Proven expertise in data warehouse design, including star and snowflake schemas and fact and dimension modeling.
• Workflow orchestration experience using Apache Airflow for data ingestion pipelines, including DAG design, scheduling, dependency management, and operational troubleshooting.
• Experience implementing and managing CI/CD pipelines using Jenkins.
• Working knowledge of GitHub for source control, code reviews, and deployment workflows.

Preferred Skills:

• Demonstrated experience leveraging Liquibase for automated and auditable database change management.
• Experience with AI-enabled solution development and implementation.
• Expertise in building and maintaining Power BI semantic models and dashboards.