Data Engineer - Snowflake - Full Time

Propel; Toronto; On-site; CAD 110,000 - 135,000; Full time

Job summary

Propel is seeking a Snowflake Data Engineer to own the design and maintenance of our cloud data warehouse and pipelines. You will work hands-on with senior engineers on architecture decisions and partner with analysts and data scientists to deliver reliable datasets.

The role requires strong Snowflake experience, SQL proficiency, and cloud platform familiarity. You will implement automation with Snowpipe/Streams, build star/snowflake schemas, and contribute to data governance and CI/CD practices.

Qualifications

• 5–7 years in data engineering with 2–3 years direct Snowflake work.
• Strong SQL and relational/cloud data warehouse experience.
• Understanding of dimensional modelling and ETL/ELT design.
• Experience with an ELT tool, dbt preferred.
• Cloud platform experience (AWS/Azure/GCP).
• Git-based version control and basic CI/CD workflows.
• Python or similar scripting for automation.
• Snowflake features: Streams, Tasks, Snowpipe, Time Travel, Zero Copy Cloning.

Responsibilities

• Design, build, and maintain ETL/ELT pipelines feeding Snowflake.
• Develop Snowflake data models including star and snowflake schemas.
• Write efficient SQL and use Streams, Tasks, Snowpipe for automation.
• Ingest data from APIs, files, and DBs with Fivetran, Airbyte, or custom scripts.
• Implement transformation logic with dbt or similar tools.
• Monitor warehouse performance, optimize queries and costs.
• Implement data quality checks and pipeline health monitoring.
• Support RBAC, data governance and security in Snowflake.
• Collaborate with analysts and data scientists to deliver fit-for-purpose datasets.

Skills

Snowflake experience

SQL proficiency

ETL/ELT design

dbt

Cloud platforms

Git

Python scripting

Data modeling

Orchestrators

Tools

Snowflake

dbt

Airflow

Dagster

Fivetran

Airbyte

Matillion

Git

Python

Job description

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