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.
#J-18808-Ljbffr
Create a job alert for this search
Data Engineer • Toronto, ON, CA
Popular searches
Similar jobs
Sr. Data Engineer
Xplore Inc. • Markham, ON, Canada
Full-time
Canada’s fibre, 5G and satellite broadband company for rural living.Xplore is committed to the relentless pursuit of an improved broadband experience for all Canadians.
Xplore is building a world-cl...Show more
Last updated: 22 days ago • Promoted
Senior Data Engineer
Scene+ • Toronto, ON, Canada
Full-time
At Scene+, we foster an entrepreneurial spirit that drives our mission : making tomorrow even more rewarding for our members.
As a unique joint venture between Cineplex, Empire, and Scotiabank, and a...Show more
Last updated: 30+ days ago • Promoted
Senior Data Engineer
Phoenix • Toronto, ON, Canada
Full-time
As the first Senior Data Engineer at Phoenix Digital, you’ll be able to shape what our data ecosystem looks like.You’ll work closely with our cofounders and cross-functional teams to de...Show more
Last updated: 30+ days ago • Promoted
Azure Data Engineer
Cloudious LLC • Toronto, ON, Canada
Full-time
Quick Apply
Table" style="border : undefined"> Rate : CAD 55 / hr on T4 ...Show more
Last updated: 5 days ago
Senior Data Engineer
Alpaca • Toronto, ON, Canada
Full-time
Alpaca is a US-headquartered self-clearing broker-dealer and brokerage infrastructure for stocks, ETFs, options, crypto, fixed income, 24 / 5 trading, and more.
Our recent Series C funding round broug...Show more
Last updated: 8 days ago • Promoted
Senior Data Engineer - Snowflake / Azure (Hybrid)
Moneris • Toronto C6A, ON, Canada
Full-time
Senior Data Engineer (Corporate Data and Analytics).As the Senior Data Engineer, you will create data collection, extraction, and transformation frameworks for structured and unstructured data.You ...Show more
Last updated: 14 days ago • Promoted
Lead Data Platform Engineer for AI & Analytics
Tangerine • Toronto C6A, ON, Canada
Full-time
A leading direct bank in Canada is seeking a skilled Data Engineer to build a new data platform for business analytics and AI.
This role involves leading the data engineering strategy and collaborat...Show more
Last updated: 24 days ago • Promoted
Senior Full Stack Engineer, Data Ecosystem
Carta • Toronto C6A, ON, Canada
Full-time
Carta connects founders, investors, and limited partners through world-class software, purpose-built for everyone in venture capital, private equity and private credit.
Trusted by 65,000+ companies ...Show more
Last updated: 14 days ago • Promoted
Senior Data Platform Engineer - Build Real-Time Data Infra
Gusto • Toronto C6A, ON, Canada
Remote
Full-time
A leading small business solutions provider in Toronto is looking for a Senior Software Engineer to architect and maintain data infrastructure.
This role involves collaboration with cross-functional...Show more
Last updated: 30+ days ago • Promoted
Distinguished Engineer, Data & ML / AI, Office of the CTO
Equinix • Toronto C6A, ON, Canada
Full-time
Distinguished Engineer, Data, ML and AI, Office of the CTO.Equinix is the world’s digital infrastructure company, shortening the path to connectivity to enable the innovations that enrich our work,...Show more
Last updated: 30+ days ago • Promoted
Data Engineer - Snowflake
Tiger Analytics Inc. • Toronto, ON, Canada
Full-time
Tiger Analytics is a fast-growing advanced analytics consulting firm.Our consultants bring deep expertise in Data Science, Machine Learning and AI.
We are the trusted analytics partner for several F...Show more
Last updated: 30+ days ago • Promoted
Principal Consultant, Data Engineer (Level 4)
Lovelytics • Toronto, ON, CA
Full-time
Quick Apply
Lovelytics is a Databricks-focused data and AI consulting firm specializing in artificial intelligence, data, and analytics solutions.
Since partnering with Databricks in 2019, Lovelytics has experi...Show more
Last updated: 30+ days ago
Senior Data Platform Engineer — TB-Scale Pipelines
ZoomInfo • Toronto C6A, ON, Canada
Full-time
A leading data intelligence firm in Toronto is looking for a Senior SW Engineer to enhance their data platforms.The ideal candidate will have extensive experience in Java and Python, and a passion ...Show more
Last updated: 30+ days ago • Promoted
Senior Data Engineer
Gore Mutual Insurance • Toronto, ON, Canada
Full-time
Fueled by investments in talent and technology, our bold strategy to transform is nearly complete.At Gore Mutual, we've always set ourselves apart as a modern mutual that does good.Now, we'...Show more
Last updated: 30+ days ago • Promoted
Sr. Data Engineer
Hire DigITalent • Toronto, ON, Canada
Full-time
Hybrid – 2-3 days in the Toronto office.Only candidates whose experience closely matches the requirements will be contacted.
Our client is a fast-moving, innovation-driven team at the forefron...Show more
Last updated: 30+ days ago • Promoted
Software Engineer I / II - Data Engineering
Rocket Lab Corporation • Toronto, ON, Canada
Permanent
Rocket Lab is an end-to-end space company delivering responsive launch services, complete spacecraft design and manufacturing, payloads, satellite components, and more – all with the goal of ...Show more
Last updated: 2 days ago • Promoted
Data Engineer (x4) (54540)
Vaco by Highspring • Richmond Hill, Ontario, Canada
Full-time
Our client is a leading Canadian energy organization with a strong presence across Ontario.They operate critical infrastructure that supports millions of customers and drives economic growth.Our cl...Show more
Last updated: 4 days ago • Promoted
Oliver Wyman - Principal Data Engineer
Marsh • Toronto C6A, ON, Canada
Remote
Full-time
Oliver Wyman - Principal Data Engineer at Marsh.Oliver Wyman Performance Transformation.Be among the first 25 applicants.
Locations : Boston, New York, Chicago, Washington DC, Toronto, Montreal.No tw...Show more