Data Engineer Snowflake

Role snapshot

• Title: Data Engineer – Snowflake

• Location: Toronto, ON (hybrid, 2–3 days on-site)

• Engagement: Full-time, placed with an Augmented enterprise client

• Level: Intermediate to Senior (4+ years in data engineering)

• Reports to: Data Platform / Engineering Lead

About the role

Augmented is hiring a Data Engineer to build and scale a Snowflake data platform for one of our large enterprise clients in a regulated industry. You will design reliable ingestion and transformation pipelines, model data for analytics and AI use cases, and help move legacy warehouse workloads to the cloud.

You will join a small, senior delivery team that works directly with client stakeholders. The work spans greenfield builds and migrations, with a strong focus on data quality, governance and cost.

Key responsibilities

• Design and build Snowflake data pipelines using layered (raw/staging/curated) architecture

• Ingest batch and near-real-time data from databases, APIs, files and event streams using Snowpipe, Snowpipe Streaming, Fivetran or CDC tools

• Build ELT transformations in SQL and dbt; use Streams, Tasks and Dynamic Tables for incremental processing

• Model curated data sets (dimensional, Data Vault or wide tables) for BI, analytics and ML teams

• Tune warehouse sizing, clustering and query performance; monitor and control credit spend

• Implement data quality tests, lineage and observability; own pipeline SLAs and incident response

• Apply governance and security: RBAC, masking and row access policies, tagging and PII handling

• Migrate legacy warehouse and ETL workloads (e.g. Teradata, Oracle, SQL Server, Informatica) to Snowflake

• Build CI/CD for data code and infrastructure-as-code for Snowflake objects

• Partner with client architects, analysts and data scientists; document designs and decisions

Required qualifications

• 4+ years in data engineering, with 2+ years building on Snowflake in production

• Advanced SQL and strong Python

• Hands-on dbt experience (models, tests, macros, documentation)

• Experience with at least one major cloud: AWS, Azure or GCP (storage, IAM, networking basics)

• Orchestration with Airflow, Dagster, dbt Cloud or Azure Data Factory

• Solid grasp of data modelling, Snowflake performance tuning and cost management

• Git-based workflows and CI/CD (GitHub Actions, Azure DevOps or GitLab)

• Clear communicator, comfortable working directly with enterprise client teams

• Legally entitled to work in Canada

Nice to have

• SnowPro Core or SnowPro Advanced: Data Engineer certification

• Snowpark (Python), Snowflake Cortex or other in-platform ML/AI features

• Terraform or schemachange for Snowflake object management

• Experience in Life Sciences (GxP, clinical or commercial data) or Financial Services (risk, payments, regulatory reporting)

• Data sharing, Snowflake Marketplace or data product design

• Consulting or client-facing delivery background

Tech stack

• Platform: Snowflake (Streams, Tasks, Dynamic Tables, Snowpark)

• Languages: SQL, Python

• Cloud: AWS (S3) or Azure (ADLS Gen2)

• Ingestion: Snowpipe / Snowpipe Streaming, Fivetran, Kafka, CDC tools

• Transformation: dbt (Core or Cloud)

• Orchestration: Airflow, Dagster, dbt Cloud, Azure Data Factory

• DevOps: Git, CI/CD pipelines, Terraform

• Consumption: Power BI, Tableau, Sigma

Why Augmented

Augmented is an AI-native engineering delivery hub serving large enterprises in Life Sciences and Fintech, with teams in Toronto and the US.

• Work on high-impact data platforms for enterprise clients

• Small, senior teams with direct access to client decision-makers

• Exposure to AI-native delivery practices and modern tooling

• Compensation: [salary range to confirm] plus benefits

How to apply

Apply through this posting with your resume and a short note on a Snowflake pipeline you built (scale, stack, your role).

Augmented is an equal opportunity employer. Accommodations are available on request at any stage of the hiring process.