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

Data Engineer

VySystems • Toronto, ON, CA
5 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
    Enterprise Data Architect (Hybrid / Remote)

    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

    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

    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)

    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

    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)

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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

    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)

    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
    Last updated: 23 hours ago