Talent.com
Senior Software Engineer (Snowflake)
Senior Software Engineer (Snowflake)Drillo.AI • Toronto C6A, ON, Canada
Senior Software Engineer (Snowflake)

Senior Software Engineer (Snowflake)

Drillo.AI • Toronto C6A, ON, Canada
26 days ago
Job type
  • Full-time
Job description

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.

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.
  • #J-18808-Ljbffr

    Create a job alert for this search

    Senior Software Engineer Snowflake • Toronto C6A, ON, Canada

    Similar jobs
    Senior Snowflake Platform Engineer (Hybrid)

    Senior Snowflake Platform Engineer (Hybrid)

    Aviva plc • Markham
    Full-time
    A leading insurance firm in York Region is seeking a highly skilled Senior Snowflake Administrator to manage and optimize their Snowflake cloud data platform. The ideal candidate will have over 5 ye...Show more
    Last updated: 20 days ago • Promoted
    Senior Java Software Engineer - Luxoft

    Senior Java Software Engineer - Luxoft

    Luxoft • markham, on, ca
    Full-time
    One of the world's largest providers of products and services to the energy industry has a need to develop and support enterprise information system in Oil & Gas domain. Product being developed is a...Show more
    Last updated: 30+ days ago • Promoted
    Senior AI-Driven Software Engineer - Full-Stack & ML Infra

    Senior AI-Driven Software Engineer - Full-Stack & ML Infra

    Sitero LLC • Markham
    Full-time
    A leading clinical trial solutions partner is seeking a Software Engineer to advance clinical research through cutting-edge technology integration. This full-stack role requires expertise in AI and ...Show more
    Last updated: 5 days ago • Promoted
    Contract T4 || Senior Cloud Engineer [Azure] - Healthcare - newmarket

    Contract T4 || Senior Cloud Engineer [Azure] - Healthcare - newmarket

    Ampstek • newmarket, on, ca
    Full-time
    Job Title : Senior Cloud Engineer (Azure).Terraform, Azure Cloud Services.Terraform (Strong experience – 4+Yrs).Show more
    Last updated: 15 hours ago • Promoted • New!
    Senior Programmer (Salesforce Commerce Cloud)

    Senior Programmer (Salesforce Commerce Cloud)

    Ateko, backed by Bell Canada • newmarket, ON, ca
    Full-time
    Senior Programmer - Salesforce Commerce Cloud (SFCC) - remote contract Salesforce Commerce Cloud (SFCC) Show more
    Last updated: 2 hours ago • Promoted • New!
    Systems Engineer Senior

    Systems Engineer Senior

    TekWissen LLC • Markham, ON, Canada
    Temporary
    Quick Apply
    Overview : Show more
    Last updated: 1 day ago
    Software Engineer

    Software Engineer

    Epson Canada • Markham
    Full-time
    Get AI-powered advice on this job and more exclusive features.EPSON Canada is committed to providing its customers with cutting‑edge digital imaging solutions. Our product portfolio includes industr...Show more
    Last updated: 20 days ago • Promoted
    Senior Principal Software Engineer AI MultiAgents

    Senior Principal Software Engineer AI MultiAgents

    Huawei Technologies Canada Co., Ltd. • Markham, ON, CA
    Permanent
    Huawei Canada has an immediate permanent opening for a Principal Software Engineer.Established in 2014, the Distributed Scheduling and Data Engine Lab is Huawei Cloud's technical innovation center ...Show more
    Last updated: 30+ days ago