We are looking for a Snowflake Data Engineer on a Full Time basis to help build and maintain a cloud data warehouse and pipelines. This is a hands on role that involves taking ownership of moderately complex data engineering tasks, working closely with senior engineers on architecture decisions and partnering with analysts and data scientists to deliver reliable, well modelled data.

Key Responsibilities

Design, build and maintain ETL/ELT pipelines feeding into Snowflake

Develop and optimise Snowflake data models, including star and snowflake schemas and staging/curated layers

Write efficient SQL and use Snowflake features such as Streams, Tasks and Snowpipe for automation

Manage data ingestion from APIs, files and databases using tools such as Fivetran, Airbyte or custom scripts

Implement transformation logic using dbt or similar frameworks

Monitor and optimise warehouse performance, query efficiency and credit/cost usage

Implement data quality checks and basic monitoring/alerting for pipeline health

Support role based access control, data governance and security within Snowflake

Participate in code reviews, follow CI/CD practices and maintain version control via Git

Troubleshoot pipeline failures and data quality issues, escalating complex problems as needed





Document pipelines, data models and processes for team and stakeholder reference

Collaborate with analysts and data scientists to understand data requirements and deliver fit for purpose datasets

Technical Skills Required

5 to 7 years of experience in data engineering, including at least 2 to 3 years working directly with Snowflake

Solid SQL skills and experience with relational or cloud data warehouses

Understanding of dimensional data modelling and ETL/ELT design principles

Experience with at least one ELT/transformation tool, dbt preferred

Familiarity with a cloud platform (AWS, Azure or GCP) that Snowflake runs on

Experience with Git based version control and basic CI/CD workflows

Working knowledge of Python or another scripting language for automation

Experience with Snowflake native features including Streams, Tasks, Snowpipe, Time Travel and Zero Copy Cloning

Familiarity with orchestration tools such as Airflow, Dagster or Snowflake Tasks

Exposure to data ingestion tools such as Fivetran, Airbyte or Matillion

Basic understanding of streaming data concepts

CAD $110,000 - $135,000 Depending on Experience

#J-18808-Ljbffr

📌 Data Engineer - Snowflake - Full Time (Ontario)
🏢 Propel
📍 Ontario