Data Engineer (Snowflake)
- Toronto, ON, Canada
$80 to $90 CAD / hour · Contract
Applications open in a new tab.
Job details
- Pay
- $80 to $90 CAD / hour
- Job type
- Contract
- Apply by
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
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.
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.
Skills
- SQL
- Python
- Snowflake
- Snowpipe
- Snowpark
- Dbt
- Pipeline Orchestration
- Data Quality
- Performance Tuning
- Git
- CI/CD
- ETL/ELT
- Airflow
- Streaming Ingestion
- Data Modeling
- Data Monitoring
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Energy
Keywords
- Data Engineering
- Snowflake
- Snowpipe
- Streams & Tasks
- Snowpark
- SQL
- Python
- Java
- Dbt
- ETL
- ELT
- Airflow
- Dbt Cloud
- Data Pipelines
- Batch Ingestion
- Streaming Ingestion
- Data Modeling
- Automated Testing
- Data Quality
- Monitoring
- Alerting
- CI/CD
- Git
- Query Optimization
- Warehouse Optimization
- Data Lineage
- SnowPro Core
- Utilities
- Energy Technology