Talent.com
Snowflake Developer (Data Warehouse Design & SQL)
Snowflake Developer (Data Warehouse Design & SQL)Lancesoft • Montreal, QC, CA
No longer accepting applications
Snowflake Developer (Data Warehouse Design & SQL)

Snowflake Developer (Data Warehouse Design & SQL)

Lancesoft • Montreal, QC, CA
30+ days ago
Job type
  • Full-time
  • Quick Apply
Job description
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
  • 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.

*//EEO Employer: Minorities/ Females/ Disabled/ Veterans/ Gender Identity/ Sexual Orientation//*
Create a job alert for this search

Snowflake Developer (Data Warehouse Design & SQL) • Montreal, QC, CA

Similar jobs

Remote Senior Data Engineer Focused on Snowflake Development

Myticas ConsultingMontreal (administrative region), QC, CA
Remote
Full-time

Elevate data engineering as a Senior Data Engineer specializing in Snowflake development.Your expertise will drive the creation of scalable data pipelines in a remote contract environment.In this r...Show more

 • Promoted

DB Developer: SQL, DB2, Data Warehouse & Unix

Info-WaysMontreal (administrative region), QC, CA
Full-time

A leading technology firm in Montreal is seeking a Database Developer for a full-time position.The role involves collaboration with other developers on the end-to-end product development across the...Show more

 • Promoted

Guidewire Developer

ThoughtStormsaint-esprit, qc, ca
Temporary

We are seeking a Guidewire DataHub / InfoCenter Developer for an 8-month contract with the potential for extension.The ideal candidate will have extensive experience with Guidewire DataHub and Info...Show more

 • Promoted

Senior Developer with SQL and Snowflake Expertise

Intact Financial CorporationMontreal
Full-time

Drive marketing success as a Senior SQL Developer who specializes in data extraction and campaign support.Work in a hybrid model while leveraging SQL and Snowflake to boost data-driven decision-mak...Show more

 • Promoted

Data Platform Engineer: Snowflake & Cloud Data Solutions

BRPMontreal (administrative region), QC, CA
Full-time

A leading recreational vehicle company is seeking a motivated Data Platform Engineer to join their Data Solutions team.In this role, you will explore and evaluate emerging data technologies, design...Show more

 • Promoted

Lead Data Engineer (Snowflake) | DataOps & Architecture

KpcgroupMontreal, Montreal (administrative region), CA
Full-time

Une entreprise de technologie recherche un Lead Data Engineer Snowflake à Montréal.Vous serez responsable de l'élaboration d’architectures optimisées, de la mise en place des ingestions de données ...Show more

 • Promoted

Talend/Snowflake - Senior Data Engineer

GenpactMontreal
Full-time

The Corporate Workspace Technology area is currently hiring for the role of.Snowflake data store utilizing effective data pipelines such as Talend, Informatica and APIs.The ideal candidate should h...Show more

 • Promoted

Senior Cloud Data Warehouse Engineer (Snowflake & Python)

VLink IncMontreal
Full-time

A leading digital technology services company is seeking a Senior Cloud Data Warehouse Engineer in Montreal.The role involves building and refining the Cloud Data Warehouse using Snowflake and Pyth...Show more

 • Promoted

Senior Data Engineer — Remote Canada (Snowflake DW)

Infostrux Solutions Inc.Montreal (administrative region), QC, CA
Remote
Full-time

A leading data consultancy in Canada seeks a Senior Data Engineer to guide customers in building cloud-based data warehouses using Snowflake.The role involves data ingestion, transformation, and op...Show more

 • Promoted

Senior Data Engineer

Inizio Partners Corpsaint-esprit, qc, ca
Full-time

Job Title: Consultant Data Engineer.We're looking for a Senior Data Engineer with strong data platform experience to help with support of existing AWS/dbt platform and that can help with standing u...Show more

 • Promoted

Snowflake Developer - laval

Lorven Technologies Inc.laval, qc, ca
Full-time

Job Title: Snowflake Developer.Location: Montreal, QC (Local Candidates Only - Face-to-Face Interview Required).Job Type: Contract to Hire / Long-term contract.Proficient in Snowflake architecture,...Show more

 • Promoted • New!

Senior Snowflake Engineer - Remote-First Data Architect

LateralgroupMontreal, Montreal (administrative region), CA
Remote
Full-time

A dynamic technology company in Montreal is seeking a Senior Snowflake Engineer to design and optimize scalable data solutions.The ideal candidate will have over 5 years of data engineering experie...Show more

 • Promoted

Azure Databricks Engineer

Tredence Inc.saint-esprit, qc, ca
Full-time

We are seeking a skilled Azure Databricks Engineer with strong experience in Azure Data Factory (ADF) to design, develop, and maintain scalable data pipelines and analytics solutions on the Azure c...Show more

 • Promoted

Senior Snowflake Data Platform Backend Engineer (Remote)

UpworkMontreal (administrative region), QC, CA
Remote
Full-time

A leading online work marketplace is seeking a Senior Backend Engineer to support their Snowflake Data Platform.This hands-on role involves building and operating backend services, developing Airfl...Show more

 • Promoted

Senior Tableau Dashboard Developer

Iris Software Inc.Montreal (administrative region), QC, CA
Full-time

Join a dynamic team as a Senior Tableau Developer.Utilize your advanced Tableau Desktop and Server skills to create impactful dashboards and visualizations that drive critical business insights.In ...Show more

 • Promoted

Senior Data Engineer, Databricks - saint-esprit

Insight Globalsaint-esprit, qc, ca
Temporary

Senior Databricks Data Engineer (Migrations & Orchestration).Hybrid in Mississauga 2x a week, or remote for those outside of the GTA.Hourly Rate: 65-70/hour depending on relative experience.Strong ...Show more

 • Promoted • New!

Data Platform Infrastructure Senior Developer

CoveoMontreal (administrative region), QC, CA
Full-time

Shape scalable data solutions as a Senior Developer in Infrastructure.Drive the improvement of Snowflake and Databricks reliability and operational practices through innovative engineering.This rol...Show more

 • Promoted

Senior Snowflake Data Engineer: Scale, Optimize, Automate

Compunnel Inc.Montreal (administrative region), QC, CA
Full-time

A leading tech firm in Montreal seeks a Senior Data Engineer to enhance their data infrastructure using Snowflake.This role requires designing scalable data solutions, migrating legacy systems, and...Show more