Senior Snowflake Engineer

Princeton IT Services, Inc; Toronto; On-site; CAD 90,000 - 130,000; Part time

Job summary

Princeton IT Services, Inc. is seeking a Senior Snowflake Engineer to design, build, and operationalize Snowflake-native solutions.

You will lead Snowflake-focused development, data architecture, and platform engineering to deliver performant data products and developer utilities across the business. The role entails hands-on work with Snowpark, Streams & Tasks, Snowpipe, and partner tools, ensuring secure, governed data deployment and cost-efficient operations in a fintech-like environment.

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, external functions, and UDFs.
• Proficient in Python (Snowpark/connector) and SQL tuning/optimization techniques.

Responsibilities

• Lead design and implementation of Snowflake-based data architectures: schemas, data vault/house/star models, materialized views, and zero-copy cloning patterns.
• 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.

Skills

ETL development

Snowflake data pipelines

SQL

Python

Fintech background

Tools

Streamsets

dbt

Fivetran

Matillion

Airbyte

Kafka connectors

Job description

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.

Job title: Senior Snowflake Engineer

Location : Toronto, Canada

Job type: Contract

Must-Have Technologies

• Data Engineer with strong expertise in ETL development, building Snowflake data pipelines, SQL, Python, and scalable data engineering solutions.


• Look for candidate from Fintech or Payment background

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.