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
Enterprise Data Architect (Hybrid / Remote)
Util-Assist Inc. • Newmarket L0G, ON, Canada
Remote
Full-time
A utility consulting firm is seeking a skilled Data Architect to design and implement enterprise data solutions that enable advanced analytics for utility clients.
This hybrid / remote role demands pr...Show more
Last updated: 4 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
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: 10 days ago • Promoted
Data Engineer (x4) (54540)
Vaco by Highspring • Aurora, 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: 7 days ago • Promoted
AWS data engineer DWIDC5725169
Compunnel Inc. • Greater Toronto Area, Canada
Full-time
Data Engineer with AWS, Glue, Lambda, SQL, Python, Redshift.Must have working knowledge in designing and implementing data pipelines on any of the cloud providers (AWS is preferred).Must be able to...Show more
Last updated: 13 hours ago • Promoted • New!
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: 16 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: 26 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: 16 days ago • Promoted
Senior Data Engineer - Python & Spark
NearSource • Toronto, ON, Canada
Full-time
Senior Data Engineer – Python & Spark.Remote - Toronto, Ontario, Canada.NearSource is looking for a Data Platform Engineer with expertise in Python, Spark, and Snowflake to join our engin...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
Azure Data Engineer
Four Seasons Hotels and Resorts • Toronto, Canada
Full-time
Four Seasons is powered by our people.We are a collective of individuals who crave to become better, to push ourselves to new heights and to treat each other as we wish to be treated in return.Our ...Show more
Last updated: 9 hours ago • Promoted • New!
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
Azure Data Engineer
Synechron • Toronto, Canada
Full-time
Overview At Synechron, we believe in the power of digital to transform businesses for the better.Our global consulting firm combines creativity and innovative technology to deliver industry-leading...Show more
Last updated: 11 hours ago • Promoted • New!
Data Engineer
Hays • toronto, ON, ca
Full-time
Job Title : Data Engineer- BigData and GCP Location : Toronto, ON(1day / week onsite) Duration : Contract <...Show more
Last updated: 1 hour ago • Promoted • New!
GCP Data Engineer
Tata Consultancy Services • Toronto, ON, Canada
Full-time
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c...Show more
Last updated: 7 hours ago • Promoted • New!
Senior Data Platform Engineer
IGM US Holdings, Inc. • Toronto, Ontario, Canada, M4B 0A3
Full-time
Gravity is the platform public agencies use to manage budgeting, automate financial reporting, and meet compliance with confidence.
From Annual Comprehensive Financial Reports (ACFR) to Budget Books...Show more
Last updated: 30+ days ago
Data Engineer
CI Financial Corp. • Toronto, ON, Canada
Full-time
At CI, we see a great place to work as one that is a safe place for everyone to have a voice, where people are empowered to take ownership over meaningful work, where there is an opportunity to gro...Show more
Last updated: 30+ days ago • Promoted
Senior Data Engineer (AWS)
Clickatell • Toronto, ON, CA
Full-time
Quick Apply
We Are Innovators & Category Creators.Visa, ABSA, MTN, Toyota, and Pick n Pay.Clickatell has led multiple .WhatsApp payments, KYC chat banking, and Chat-2-Pay.
As a Data Engineer, you will ...Show more