Job Description

We're looking for an experienced ETL and data engineering consultant to support enterprise data pipelines and cloud platform operations in Toronto. The ideal candidate brings strong SQL and Python skills, hands-on ETL experience, and a production-focused mindset for building and maintaining reliable data workflows.

What you'll do

• Build, maintain, and troubleshoot batch ETL pipelines with complex dependencies
• Perform advanced SQL transformations, debugging, and performance tuning
• Support data quality checks, reconciliation logic, and validation frameworks
• Work across source, staging, transformation, and target layers to perform deep-dive analysis
• Contribute to CI/CD pipelines and Git-based workflows for data engineering
• Collaborate with platform and delivery teams on cloud-based data infrastructure

What you bring

• 5+ years of experience with ETL tools such as Talend, Informatica, or Python-based pipelines
• Advanced SQL skills for complex transformations and performance tuning
• Hands-on experience with Snowflake and/or Databricks, preferably in AWS environments
• Working knowledge of Python for data processing, automation, or validation
• Solid understanding of data modeling — both relational and dimensional
• Familiarity with cloud security concepts including IAM and RBAC
• Experience with Docker and some exposure to Kubernetes-based deployments
• Experience with Git and CI/CD pipelines for data workflows
• Strong production mindset with attention to logging, alerting, monitoring, and failure recovery
• Eligibility for a mandatory background check

Nice to have

• Experience with CDC tools such as IBM CDC or Debezium
• Ability to read and interpret generated SQL, Java, or ETL tool metadata

Work setup

• Hybrid in Toronto, ON
• 12+ month contract
• English proficiency required