Location: Toronto, ON (hybrid, 2–3 days on-site)Engagement: Full-time, placed with an Augmented enterprise clientLevel: Intermediate to Senior (4+ years in data engineering)Reports to: Data Platform / Engineering LeadRole snapshotTitle: Data Engineer – SnowflakeLocation: Toronto, ON (hybrid, 2–3 days on-site)Engagement: Full-time, placed with an Augmented enterprise clientLevel: Intermediate to Senior (4+ years in data engineering)Reports to: Data Platform / Engineering LeadAbout the roleAugmented 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 responsibilitiesDesign and build Snowflake data pipelines using layered (raw/staging/curated) architectureIngest batch and near-real-time data from databases, APIs, files and event streams using Snowpipe, Snowpipe Streaming, Fivetran or CDC toolsBuild ELT transformations in SQL and dbt; use Streams, Tasks and Dynamic Tables for incremental processingModel curated data sets (dimensional, Data Vault or wide tables) for BI, analytics and ML teamsTune warehouse sizing, clustering and query performance; monitor and control credit spendImplement data quality tests, lineage and observability; own pipeline SLAs and incident responseApply governance and security: RBAC, masking and row access policies, tagging and PII handlingMigrate legacy warehouse and ETL workloads (e.G. Teradata, Oracle, SQL Server, Informatica) to SnowflakeBuild CI/CD for data code and infrastructure-as-code for Snowflake objectsPartner with client architects,



analysts and data scientists; document designs and decisionsRequired qualifications4+ years in data engineering, with 2+ years building on Snowflake in productionAdvanced SQL and strong PythonHands‑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 FactorySolid grasp of data modelling, Snowflake performance tuning and cost managementGit‑based workflows and CI/CD (Git Hub Actions, Azure Dev Ops or Git Lab)Clear communicator, comfortable working directly with enterprise client teamsLegally entitled to work in CanadaNice to haveSnow Pro Core or Snow Pro Advanced: Data Engineer certificationSnowpark (Python), Snowflake Cortex or other in‑platform ML/AI featuresTerraform or schemachange for Snowflake object managementExperience in Life Sciences (Gx P, clinical or commercial data) or Financial Services (risk, payments, regulatory reporting)Data sharing, Snowflake Marketplace or data product designConsulting or client‑facing delivery backgroundTech stackPlatform: Snowflake (Streams, Tasks, Dynamic Tables, Snowpark)Languages: SQL, PythonCloud: AWS (S3) or Azure (ADLS Gen2)Ingestion: Snowpipe / Snowpipe Streaming, Fivetran, Kafka, CDC toolsTransformation: dbt (Core or Cloud)Orchestration: Airflow, Dagster, dbt Cloud, Azure Data FactoryDev Ops: Git, CI/CD pipelines, TerraformConsumption: Power BI, Tableau, SigmaWhy AugmentedAugmented 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 clientsSmall, senior teams with direct access to client decision-makersExposure to AI-native delivery practices and up-to-date toolingCompensation: (salary range to confirm) plus benefitsAugmented is an equal opportunity employer. Accommodations are available on request at any stage of the hiring process.#J-18808-Ljbffr

📌 Data Engineer Snowflake (Toronto)
🏢 Augmented
📍 Toronto