Lead Data Engineer / Data Product Lead Snowflake

Global Technical Talent; Toronto; Hybrid; CAD 83,000 - 110,000; Part time

Job summary

Global Technical Talent, Inc. is seeking a Lead Data Engineer / Data Product Lead to design and deliver enterprise-scale data products in a life sciences context.

This hands-on leadership role emphasizes Snowflake, SQL, Matillion/dbt, AWS and Python, with end-to-end ownership from architecture to production support. You will work with Product Owners, stakeholders, architects and vendors to translate complex requirements into scalable data solutions, mentoring engineers and ensuring high data

Qualifications

• Hands-on experience with enterprise data products and end-to-end delivery.
• Strong Snowflake and SQL skills with large-scale transformations.
• Experience with Matillion and/or dbt and modern orchestration frameworks.
• Experience with AWS services (S3, Lambda) for data pipelines.
• Proficiency in Python for data processing and automation.
• Ability to own complex data products through full delivery lifecycle.
• Understanding of data quality, observability, lineage, testing, deployment, and production support.
• Experience leading distributed engineering teams (onshore/offshore).

Responsibilities

• Own one or more enterprise data products across architecture, design, development, testing, deployment and production readiness.
• Design scalable data solutions using Snowflake, Matillion, dbt, SQL, AWS and Python.
• Lead architecture across ingestion, transformation, semantic layers, data quality and lineage.
• Collaborate with Product Owners and stakeholders to translate requirements into technical solutions.
• Lead design/architecture reviews and promote reusable patterns.
• Design modular, reusable data models for evolving reporting needs.
• Coordinate delivery across onshore/offshore teams and vendors.
• Manage dependencies, priorities, risks and delivery commitments.
• Mentor engineers and establish clear ownership across teams.
• Drive root-cause analysis for arch, quality and production issues.
• Contribute to data cataloging, lineage, observability, testing and data quality frameworks.
• Explore Snowflake Cortex, AI-enabled analytics and semantic models.

Skills

Snowflake

SQL

Matillion

dbt

Python

AWS

ETL/ELT

Data modeling

Data products

Data quality

Tools

Snowflake

Matillion

dbt

AWS

S3

Job description

Lead Data Engineer / Data Product Lead – Snowflake

Location: Toronto, ON

Onsite Flexibility: Hybrid

Contract Details

• Position Type: Contract
• Contract Duration: 6 months
• Pay Rate: C$60.00–C$80.00 / Hour (CAD)

Job Summary

This client is seeking an experienced Lead Data Engineer / Data Product Lead to support the design and delivery of enterprise-scale data products within a complex life sciences environment. This is a hands-on technical leadership role requiring deep expertise in Snowflake, SQL, Matillion/dbt, AWS, and Python, along with the ability to own data products end to end from architecture and design through development, deployment, production support, and downstream enablement. The successful candidate will work closely with Product Owners, business stakeholders, architects, reporting teams, engineering leads, and external vendors to translate complex business requirements into scalable, maintainable data solutions.

Key Responsibilities

• Own one or more enterprise data products across architecture, design, development, testing, deployment, production readiness, and ongoing enhancement.
• Design and implement scalable data solutions using Snowflake, Matillion, dbt, SQL, AWS, and Python.
• Lead architecture across data ingestion, transformation, semantic layers, data quality, lineage, and downstream consumption.
• Partner with Product Owners, architects, business stakeholders, and reporting teams to translate requirements into technical solutions.
• Lead technical design and implementation reviews to ensure adherence to enterprise standards and reusable design patterns.
• Design modular, reusable data models that support evolving reporting and analytical needs.
• Coordinate delivery across onshore/offshore engineering teams and third-party vendors.
• Manage technical dependencies, priorities, risks, and delivery commitments across concurrent workstreams.
• Mentor engineers and establish clear ownership across functional areas.
• Drive root-cause analysis and resolution of architectural, data-quality, and production issues.
• Contribute to enterprise frameworks for data cataloging, lineage, observability, validation, testing, and data quality.
• Explore emerging capabilities such as Snowflake Cortex, AI-enabled analytics, semantic models, and agent-based analytical solutions.

Required Skills

• Strong data engineering experience with expertise in ETL/ELT, data modeling, data warehouse architecture, and enterprise-scale data products.
• Deep hands-on experience with Snowflake and advanced SQL.
• Strong experience with performance tuning, large-scale transformations, historical processing, and complex business rules.
• Experience with Matillion and/or dbt and modern orchestration frameworks.
• Experience with AWS services, including S3 and Lambda.
• Hands-on Python experience for data processing and automation.
• Proven ability to own complex data products through the full delivery lifecycle.
• Strong understanding of data quality, observability, lineage, testing, deployment, and production support.
• Experience designing semantic layers and reusable enterprise data models.
• Strong stakeholder-management and communication skills.
• Experience leading and mentoring distributed engineering teams, including onshore/offshore delivery models.

Preferred Skills

• Experience within pharmaceutical, biotechnology, or life sciences environments.
• Knowledge of commercial, patient, payer, market access, CRM, or channel-partner data.
• Experience with specialty pharmacy / specialty distributor (SP/SD) sales data, 3PL data, Veeva CRM, Salesforce Service Cloud / Health Cloud, marketing data, or patient-access datasets.
• Exposure to Snowflake Cortex, GenAI, AI-enabled analytics, semantic models, or agent-based analytics.
• SnowPro certification or equivalent demonstrated Snowflake expertise.

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. We highly value diverse and inclusive workplaces and support Fortune 500 organizations across banking, financial services, technology, life sciences, biotech, utilities, and retail sectors throughout the U.S. and Canada.

Job Number: 26-17948 Industry: Data & Analytics

#LI-Hybrid #LI-GTT #gttca