Back to job search
LT
Lorven Technologies Inc.Verified Job Source

Data Engineer – Snowflake

Design and operate Snowflake in production using advanced features like Snowpark, Streams, and Tasks. Implement ETL/ELT pipelines and maintain CI/CD practices for data workloads.

  • On-site
  • Toronto, ON
  • Posted Aug 12, 2026
  • Apply by Sep 11, 2026
  • 1 position

More jobs you can apply to directly

Similar opportunities posted by employers hiring on Jobs.ca, with no external application form.

Job summary

Data Engineer – Snowflake Position: Contract Location: Downtown Toronto Duration: 12+ months Job description: Strong hands-on experience designing and operating Snowflake in production Deep experience with Snowflake features, like Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, external functions and user-defined functions. Hands-on ETL/ELT development experience with dbt, SQL, and one or more ingestion tools (Streamsets, Fivetran, Matillion, Airbyte, Kafka connectors). Proficient in Python (Snowpark/connector), SQL tuning and query optimization techniques. Experience with IaC and automation (Terraform, GitHub Actions, Jenkins, or equivalent). Strong knowledge of cloud platforms and native services (AWS, Azure or GCP) as they relate to Snowflake deployment and integrations. Solid understanding of medallion architecture, data modeling patterns, data governance, and secure data sharing. Demonstrated ability to implement CI/CD, automated testing and production operational practices for data workloads. Preferred qualifications Snowflake SnowPro Core or advanced Snowflake certifications. Experience with dbt (core or Cloud) for transformation and modular SQL engineering. Experience with data virtualization, data catalogs or data lineage tools. Familiarity with analytics and BI integrations (Looker, Tableau, Power BI) and building Snowflake-optimized semantic layers. Experience building internal developer tools or data apps using Snowpark or lightweight web frameworks.

What you’ll do

Design and operate Snowflake in production using advanced features like Snowpark, Streams, and Tasks. Implement ETL/ELT pipelines and maintain CI/CD practices for data workloads.

Requirements

Requires deep expertise in Snowflake, Python, and SQL, along with experience in IaC tools like Terraform. Proficiency in cloud platforms and data modeling patterns is essential.

Listed skills

  • Microsoft AzurePreferred
  • SQLPreferred
  • CI/CDPreferred
  • Amazon Web ServicesPreferred
  • Google CloudPreferred
  • TerraformPreferred
  • PythonPreferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Snowflake
  • Snowpark
  • dbt
  • SQL
  • Python
  • Terraform
  • GitHub Actions
  • Jenkins
  • AWS
  • Azure
  • GCP
  • Medallion Architecture
  • CI/CD
  • Data Modeling
  • ETL/ELT
  • Data Governance

Job areas

  • Data & Analytics
  • Technology
  • Software
  • Engineering
  • Consulting

Additional details

Minimum education
Professional degree
Minimum experience
5+ years
Apply by
Sep 11, 2026
Posting language
English
Working hours
40 hours per week
Seniority
Mid-Senior level
Application method
Direct apply is available