Sr Snowflake Engineer

Apexon; Toronto; On-site; CAD 110,000 - 165,000; Full time

Job summary

Apexon in Toronto, Canada, is building a modern data platform centered on Snowflake. We seek a Snowflake-focused data professional to design, build and operationalize Snowflake-native solutions, including Snowpark, Streams & Tasks, and Snowpipe, to enable analytics and data products across the business.

You will lead architectures, pipelines, governance and tooling, mentor engineers, and collaborate across teams to drive performance, cost efficiency, and secure data sharing in cloud

Qualifications

• Strong hands-on experience designing and operating Snowflake in production.
• Deep experience with Snowflake features: Snowpark, Streams & Tasks, Snowpipe, Time Travel, cloning, materialized views, UDFs.
• Hands-on ETL/ELT development with dbt, SQL, and ingestion tools (Streamsets, Fivetran, Matillion, Airbyte, Kafka connectors).
• Proficient in Python (Snowpark/connector), SQL tuning and query optimization.
• Experience with IaC and automation (Terraform, GitHub Actions, Jenkins).
• Strong knowledge of cloud platforms (AWS, Azure or GCP) and Snowflake deployments.
• Solid understanding of data modeling, governance, and secure data sharing.
• Ability to implement CI/CD and automated testing for data workloads.

Responsibilities

• Lead design and implementation of Snowflake-based data architectures and models.
• Build and maintain production ETL/ELT pipelines into Snowflake using Snowpipe, Snowpark, Streams & Tasks.
• Develop Snowflake-native utilities and apps to accelerate delivery.
• Optimize query performance and cost through clustering, partitioning and resource monitors.
• Implement governance, security and access controls in Snowflake.
• Automate infrastructure and deployments using IaC and CI/CD pipelines.
• Build observability and operational tooling including monitoring and incident playbooks.
• Mentor engineers and contribute to roadmap decisions for Snowflake platform.

Skills

Snowflake design/operation

Snowpark

Streams & Tasks

Snowpipe

Python

SQL tuning

IaC

Terraform

GitHub Actions

Jenkins

Cloud platforms (AWS/Azure/GCP)

Data governance

CI/CD for data workloads

Tools

Streamsets

dbt

Fivetran

Matillion

Airbyte

Kafka connectors

Looker

Tableau

Power BI

Job description

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.

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.