Talent.com
Data Engineer
Data EngineerVySystems • Toronto, ON, CA
Data Engineer

Data Engineer

VySystems • Toronto, ON, CA
3 days ago
Job type
  • Full-time
Job description

Responsibilities

  • 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

    Similar jobs
    Sr. Data Engineer

    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

    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

    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

    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

    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)

    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

    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

    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

    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

    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

    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)

    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

    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

    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

    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

    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)

    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

    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
    Last updated: 12 days ago • Promoted