Data Engineer (Snowflake)

Toronto, ON
On-site
Posted Nov 10, 2026
1 position

$80–$90 / hour

Applications are currently unavailable for this posting.

Employment type: Contract
Posting language: English
Application method: Apply on LinkedIn (LinkedIn sign-in required)

Job summary

Develop and operate reliable Snowflake data pipelines for batch and streaming ingestion, transformation, and data modeling. Implement testing, data-quality checks, monitoring, CI/CD, performance and cost optimization, and documentation for data lineage and operational procedures.

Job details

Data Engineer Mission: Build and operate the data pipelines that land, transform, and model data on the Snowflake platform reliably and efficiently. Key responsibilities: Develop and maintain ingestion pipelines from source systems into Snowflake, covering both batch and streaming (e.g., Snowpipe, Streams & Tasks, connectors). Build transformation and data-modelling logic using SQL, dbt, and/or Snowpark (Python/Java). Implement automated testing, data-quality checks, monitoring, and alerting across pipelines. Apply CI/CD and version control so pipeline changes are reviewed, tested, and deployed consistently. Optimize queries and warehouse usage for performance and cost (pruning, clustering, rightsizing). Document data lineage, transformations, and operational runbooks. Qualifications: 7+ years in data engineering in an enterprise environment 3+ years in snowflake (snowpipe and snowpark) Strong SQL and Python; hands-on experience with ELT/ETL tooling, dbt, and orchestration (e.g., Airflow, dbt Cloud) Git-based version control and CI/CD familiarity; exposure to streaming ingestion a plus. SnowPro Core certification preferred. Key skills: SQL, Python, dbt, pipeline orchestration, data quality, performance tuning, Git/CI-CD. This is a temporary contractor position and is a current existing vacancy. Please note that assignment durations, pay rates, and job duties are subject to Hydro One’s business needs and project requirements.

What you’ll do

Requirements

Requires 7+ years of enterprise data engineering experience and 3+ years of Snowflake experience, including Snowpipe and Snowpark. Candidates should have strong SQL and Python skills, hands-on experience with ETL/ELT tools, dbt, orchestration, Git, and CI/CD; SnowPro Core certification is preferred.