Lead Data Engineer / Data Product Lead – SnowflakeLocation: 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 SummaryA leading life sciences consulting organization 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 GTTGTT 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
