Home
Jobs
Open Systems Technologies
Snowflake Developer (Data Warehouse Design & SQL)

Snowflake Developer (Data Warehouse Design & SQL)

Hybrid

Montreal, Canada

Freelance

17-02-2026

Share this job:

Score my CV

Skills

SQL Apache Airflow GitHub CI/CD Version Control Jenkins Change Management Analytics and Reporting Databases apache power bi Analytics Snowflake CI/CD Pipelines

Job Specifications

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

• 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.

About the Company

Open Systems Technologies is a tier-one vendor for the world's most competitive financial and technology companies, offering both full-time and contract recruiting services across the country. We offer a positive, entrepreneurial, high performing culture where all employees have the unique opportunity to run a full desk. Our office looks, feels, and operates like a start-up, but with the stability, clientele, and resources that only an industry veteran can provide. At our core, we are structured to be flexible. With over 3... Know more