Back to job search
A
ApexonVerified Job Source

SENIOR SNOWFLAKE ENGINEER

Lead the design and implementation of Snowflake-native data architectures and production ETL/ELT pipelines. Develop internal utilities and apps while optimizing query performance, cost, and data governance.

  • On-site
  • Toronto, ON
  • Posted Aug 6, 2026
  • Apply by Sep 5, 2026
  • 1 position

Job summary

Job Overview We are building a modern data platform centered on Snowflake and we’re seeking a Snowflake-focused data professional to design, build and operationalize Snowflake-native solutions. The role combines advanced Snowflake development (Snowpark, Streams & Tasks, Snowpipe), data architecture and platform engineering to deliver performant, secure, governed data products, developer utilities and Snowflake-based apps that enable analytics and data products across the business. Reports To Director, Data and AI Responsibilities and Duties · Lead design and implementation of Snowflake-based data architectures: schemas, data vault/house/star models, materialized views, and zero-copy cloning patterns for environments. · Build and maintain production ETL/ELT pipelines into Snowflake using Snowpipe, Snowpark, Streams & Tasks and partner tools (Streamsets, dbt, Fivetran, Matillion, Airbyte, etc.). · Develop Snowflake-native utilities and apps (Snowpark for Python, UDFs, external functions, and internal tools) to accelerate developer productivity and data product delivery. · Optimize query performance and cost through clustering keys, partitioning strategies, resource monitors, warehouse sizing, and workload isolation. · Implement data governance, security and access controls in Snowflake based on role-based access, masking policies, object tagging, data lineage and audit logging. · Automate infrastructure and deployments leveraging IaC for Snowflake objects and cloud infra CI/CD pipelines, and automated testing for SQL/Snowpark code. · Build observability and operational tooling by monitoring, alerting, usage/cost reporting, and incident playbooks for Snowflake workloads. · Mentor engineers, review designs and contribute to roadmap decisions for Snowflake platform evolution. Required skills and experience · 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

Lead the design and implementation of Snowflake-native data architectures and production ETL/ELT pipelines. Develop internal utilities and apps while optimizing query performance, cost, and data governance.

Requirements

Requires deep hands-on experience with Snowflake features, Python, SQL, and ingestion tools like dbt or Fivetran. Proficiency in IaC, CI/CD pipelines, and cloud platforms (AWS, Azure, or GCP) is essential.

Listed skills

  • SQLPreferred
  • CI/CDPreferred
  • TerraformPreferred
  • PythonPreferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

  • Snowflake
  • Snowpark
  • Python
  • SQL
  • dbt
  • ETL/ELT
  • Terraform
  • CI/CD
  • Data Modeling
  • Data Governance
  • Cloud Platforms
  • Snowpipe
  • Streams & Tasks
  • Infrastructure as Code
  • Query Optimization
  • Data Architecture

Job areas

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

Additional details

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