Data Engineer Snowflake

Job summary

Design, build, and optimize Snowflake ingestion and transformation pipelines, curated data models, and cloud warehouse migrations. Implement data quality, governance, security, observability, and CI/CD practices while partnering with client teams and managing pipeline reliability and costs.

Job details

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.

What you’ll do

Design, build, and optimize Snowflake ingestion and transformation pipelines, curated data models, and cloud warehouse migrations. Implement data quality, governance, security, observability, and CI/CD practices while partnering with client teams and managing pipeline reliability and costs.

Requirements

Requires 4+ years of data engineering experience, including 2+ years building production Snowflake solutions, advanced SQL, strong Python, and hands-on dbt experience. Candidates should also have cloud platform experience, orchestration and CI/CD skills, data modeling and Snowflake tuning knowledge, and legal authorization to work in Canada.

Listed skills

• SQL · Preferred
• CI/CD · Preferred
• Terraform · Preferred
• Python · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• SQL
• Python
• Dbt
• Data Engineering
• Data Pipeline Development
• Data Modeling
• Snowflake Performance Tuning
• Cloud Platforms
• Airflow
• Data Quality
• Data Governance
• CI/CD
• Terraform
• Data Migration
• Client Communication

Job areas

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

More jobs from Augmented