Find work in Canada.

485,597 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 1 day ago
E
Principal Software Engineer
EngRadar
Kitamaat 2, BC
- Full-time
As a Principal Software Engineer on Conga’s B2B Platform Engineering, Core Services team, you’ll own the security, identity, and access management capabilities that every Conga B2B product…
Added 1 day ago
B
Principal Software Engineer
Broadcom
Ottawa, ON
- $114,400 to $183,000 CAD / year
- Full-time
As a Principal Software Engineer, you will design, develop, and deliver software and firmware for ultra-high-performance datacenter-scale solutions. We are looking for candidates who thrive…
Added 1 day ago
Principal Software Engineer
Conga
Canada
As a Principal Software Engineer on Conga’s B2B Platform Engineering, Core Services team, you’ll own the security, identity, and access management capabilities that every Conga B2B product…
Added 1 day ago
AI
Principal Consultant – AWS Data Platforms & Agentic AI
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Toronto, ON
- Full-time
We are looking for a Principal Consultant – AWS Data Platforms & Agentic AI to provide technical leadership in architecting, building and scaling next-generation enterprise Data and Agentic…
Added 1 day ago
Principal Engineer
Scotiabank
Toronto, ON
…while driving cloud platform standards, operational excellence, automation strategies, and continuous improvement…
Added 2 days ago
W
Principal Process Automation Engineer
Worley
AB · Edmonton, AB
- Full-time
…expansion of new business opportunities within the industrial automation sector by leveraging cutting-edge digital, technology, and autonomous solutions. The consultant will play a pivotal…
Added 2 days ago
HE
Ingénieur principal de projet – HVDC/Senior Project Lead Engineer HVDC
Hitachi Energy
Montreal, QC · Saint-Laurent, QC
- Full-time
L’unité d’affaires Automatisation des réseaux (Grid Automation) de Hitachi Energy est à la recherche d’un(e) Ingénieur(e) principal(e) de projet (Senior Project Lead Engineer) pour assumer…
Added 2 days ago
MA
Tech Lead - Snowflake & DBT
Mitra AI
Canada
- Contract
We are seeking a highly experienced, hands-on Lead / Principal Data Engineer with deep expertise in Snowflake, DBT, advanced SQL, and modern data engineering practices to support enterprise…
Added 2 days ago
I
Resiliency Architect
Intact
Montreal, QC
- Full-time
Make blue/green deployments and chaos engineering first-class, codified practices across the estate: design, tooling, automation, and continuous validation.
Added 2 days ago
GV
Gestionnaire de projet - Automatisation et Robotique / Project Manager - Automation and Robotics
GE Vernova
Longueuil, QC
- Full-time
…et au développement des solutions techniques. Il agit comme principal point de contact auprès des clients, des sous-traitants et des équipes internes afin d’assurer l’exécution efficace des…
Added 3 days ago
B
Principal Azure Cloud Platform Engineer
BMO
Toronto, ON · BMOPLACE
- Full-time
As a Principal Azure Platform Engineer, you will play a hands‑on engineering role within BMO’s Azure cloud ecosystem. You will be responsible for designing, building, and operating secure,…
Added 3 days ago
GV
Spécialiste digitalisation et configuration produit (Plateforme Genesis) / Product data specialist (Platform PLM Genesis)
GE Vernova
La Prairie, QC
- Full-time
Nous recherchons un ingénieur principal, données de produits, pour concevoir et optimiser les systèmes numériques régissant nos disjoncteurs haute tension conçus sur commande (ETO). Ce rôle…
Added 4 days ago
D
Senior Wind Energy Analyst
DNV
Toronto, ON
- Full-time
Contribute technical expertise to pre-construction energy assessments, independent engineer assignments, and technical due diligence reviews.
Added 4 days ago
D
Senior Renewable Energy Analytics & Performance Lead
DNV
Toronto, ON
- Full-time
…assessment responsibilities with advanced data analytics, process automation, custom data processing, and technical…
Added 4 days ago
TM
Principal Software Engineer - .Net/C#
The Mirillion Group
Montreal, QC
- $150,000 to $200,000 CAD / year
- Full-time
We're looking for a Principal .NET/C# Engineer who's equally comfortable deep in the stack and crafting smooth, production-grade UIs. You'll be owning automation pipelines, building…
Added 4 days ago
TM
Principal Software Engineer - .Net/C#
The Mirillion Group
Halifax, NS
- $150,000 to $200,000 CAD / year
- Full-time
We're looking for a Principal .NET/C# Engineer who's equally comfortable deep in the stack and crafting smooth, production-grade UIs. You'll be owning automation pipelines, building…
Added 4 days ago
Principal Analog Design Engineer-19318
Synopsys
Markham, ON
…parasitic you anticipated six months earlier. You are the kind of engineer who reads JEDEC standards not to check a box but to find the constraints that matter, then architects around…
Added 4 days ago
Lead Software Engineer, Full-Stack Applications - AI Innovation squads
Fitch Group
Toronto, ON
Lead Software Engineer, Full-Stack Applications – Innovation Squads
Added 4 days ago
RA
Principal Android Engineer
Rakuten Advertising
Toronto, ON · CN-Yonge Sheppard Center
- Full-time
We are seeking a visionary Principal Android Engineer to lead the evolution of our client application architecture and platform capabilities. You’ll define and drive the technical direction…
Added 4 days ago
FG
Lead Software Engineer, Full-Stack Applications - AI Innovation squads
Fitch Group, Inc.
Toronto, ON
- Full-time
Lead Software Engineer, Full-Stack Applications – Innovation Squads
Added 4 days ago
N
Associate Principal Engineer -- Salesforce Technical Architect
Nagarro
Mississauga, ON
- Full-time
Drive architectural decisions covering Salesforce data models, integrations, automation, security, and performance.
Added 4 days ago
Y
SERVICE MANAGER
Yokogawa
NB · Chiasson Office, NB
- Full-time
…Technology’ at the HP Awards, is a leading provider of industrial automation, test and measurement, information systems and industrial services in several…
Added 4 days ago
C
Technicien principal en bâtiment / Senior Building Operator - St Bruno
CBRE
Saint-Bruno-de-Montarville, QC · St-Bruno-de-Montarville, QC
- Full-time
En tant qu’opérateur(trice) de bâtiment principal(e) à CBRE, vous serez responsable de l’entretien de bâtiments de petite ou moyenne taille, de systèmes de bâtiments et d’équipements. Ce…
Added 4 days ago
Principal Engineer, CAD
SiTime Corporation
Ottawa, ON
The Principal Engineer, CAD will provide CAD Software support for Digital, Analog and Mixed-Signal designs, using Cadence, Synopsys, Siemens, Keysight & 3rd party vendor tools.…
Added 4 days ago
SE
Application Lead, Grid Lifecycle Services (GLS)
Siemens Energy
AB · Edmonton, AB
- Full-time
…including FACTS, HVDC, substations, protection and control, automation, auxiliary systems, and related lifecycle…

Mitra AI

Tech Lead - Snowflake & DBT

Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Posting language: English
Posted: Oct 23, 2026

Original job description

About Mitra Innovation

At Mitra Innovation, we are the bridge between technical possibility and operational performance. Founded with a mission to empower businesses through intelligent technology, we are a trusted partner to over 50 strategic clients globally from ambitious scale-ups to global enterprises navigating complex digital transformations.

Project: Data Engineering & Modernization – (Client Based in USA)

JOB OVERVIEW

We are seeking a highly experienced, hands-on Lead / Principal Data Engineer with deep expertise in Snowflake, DBT, advanced SQL, and modern data engineering practices to support enterprise data modernization initiatives.

This role involves designing, developing, optimizing, and maintaining scalable data transformation pipelines, while modernizing existing data processing systems using Snowflake and DBT.

The successful candidate will be a technically strong, independent engineer capable of owning complex data engineering deliverables end-to-end, from understanding existing business logic and data architectures through implementation, testing, reconciliation, and production deployment.

This is primarily a hands-on engineering role (approximately 80% development), with additional responsibility for technical guidance, code reviews, architectural decisions, and mentoring other engineers. We are looking for someone who can go beyond implementing predefined requirements: an engineer who can identify problems, propose sound technical solutions, make informed implementation decisions, and deliver high-quality results with minimal supervision.

WHAT WE ARE LOOKING FOR

The ideal candidate is a highly capable, hands-on technical engineer who:

Can independently understand complex existing data systems and translate them into modern Snowflake/dbt implementations.
Is equally comfortable designing a data architecture and personally implementing the underlying SQL and dbt models.
Can troubleshoot difficult data discrepancies, performance issues, and transformation problems without extensive supervision.
Produces clean, reusable, well-tested, and maintainable engineering solutions.
Takes ownership of technical outcomes rather than simply completing assigned development tasks.
Can provide practical technical leadership while remaining actively involved in development.
Is comfortable working in a fast-paced, distributed engineering environment with a strong emphasis on quality, accountability, and delivery.

This position is best suited to an experienced engineer who combines deep Snowflake and dbt expertise with strong independent problem-solving skills, practical architecture experience, and a hands-on delivery mindset.

KEY RESPONSIBILITIES

1. Data Engineering & Development

Design, develop, and maintain scalable, reliable, and high-performance data transformation pipelines using dbt and Snowflake.
Develop advanced dbt models, reusable macros, Jinja templates, incremental models, and modular transformation frameworks.
Design and implement data models across staging, intermediate, core, and reporting layers.
Build reusable data processing components supporting multiple clients, source systems, and business requirements.
Implement robust data transformation logic using complex SQL, CTEs, window functions, joins, aggregations, and analytical functions.
Apply data engineering best practices to ensure code maintainability, reusability, testability, and scalability.

2. Data Migration & Modernisation

Analyse and understand complex existing data processing systems, including legacy SQL-based ETL implementations.
Translate existing business rules and data processing logic into modern dbt and Snowflake implementations.
Independently investigate and resolve discrepancies between legacy and modernised data pipelines.
Develop reconciliation, validation, and regression testing approaches to ensure data accuracy and functional equivalence.
Identify opportunities to simplify and optimise existing processes without compromising business requirements.
Support the migration and modernisation of complex enterprise data platforms.

3. Snowflake Engineering & Optimisation

Develop and optimise complex Snowflake SQL transformations and analytical workloads.
Investigate query performance, execution plans, warehouse utilisation, and processing bottlenecks.
Apply Snowflake performance optimisation techniques, including query optimisation, incremental processing, and efficient data modelling.
Work with Snowflake objects, permissions, schemas, and environments as required for application development and delivery.
Troubleshoot data processing failures, transformation issues, and production performance problems.

4. Technical Leadership & Ownership

Take end-to-end technical ownership of assigned workstreams and engineering deliverables.
Independently analyse complex requirements, design solutions, and drive implementation.
Provide technical guidance, mentoring, and support to other engineers within the offshore development team.
Perform code reviews, enforce engineering standards, and ensure consistent implementation quality.
Collaborate with data architects, technical leads, business analysts, and stakeholders to align solutions with architectural and business requirements.
Proactively identify technical risks, dependencies, and potential improvements.
Escalate strategic or architectural decisions appropriately while independently resolving routine engineering challenges.

5. Engineering Quality & Modern Development Practices

Maintain high standards for code quality, automated testing, documentation, and production readiness.
Implement dbt tests, data quality checks, and reconciliation processes.
Work with Git/GitHub-based development workflows, including branching, pull requests, code reviews, and release management.
Support CI/CD practices and automated deployment of dbt projects across environments.
Use modern AI-assisted development tools, where appropriate, to accelerate engineering productivity while ensuring code correctness and quality.
Contribute to continuous improvement of data engineering processes, tooling, and technical standards.

REQUIRED QUALIFICATIONS AND EXPERIENCE

Essential Technical Skills

Snowflake – Advanced Proficiency

At least 5+ years of substantial hands-on Snowflake experience in production data engineering environments.
Strong understanding of Snowflake architecture, SQL processing, warehouse management, and performance optimization.
Experience developing, troubleshooting, and maintaining complex transformation pipelines on Snowflake.
Ability to independently diagnose performance, data quality, and processing issues.

dbt – Advanced Proficiency

At least 5+ years of hands-on dbt experience, preferably involving large-scale, production-grade projects.
Strong practical experience with dbt Core and/or dbt Cloud.
Advanced proficiency in dbt models, materialisations, incremental processing, testing, dependencies, and project configuration.
dbt Analytics Engineering Certification or dbt Architect Certification.
Strong experience developing reusable dbt macros, Jinja-based transformations, and modular dbt architectures.
Understanding of dbt development, deployment, testing, and documentation best practices.
Experience maintaining and improving complex dbt projects involving multiple data sources and interdependent models.

SQL & Data Engineering

Expert-level SQL skills, including complex joins, CTEs, window functions, conditional logic, aggregations, and advanced data transformations.
Strong SQL debugging, query optimization, and data discrepancy investigation capabilities.
Experience designing and implementing dimensional, relational, and analytical data models.
Deep understanding of ETL/ELT architectures, enterprise data warehousing, and modern data engineering design patterns.
Experience working with large datasets and complex data transformation requirements.
Proven ability to investigate data mismatches, identify root causes, and implement reliable corrections.

Software Engineering & Delivery

Strong experience with Git/GitHub-based development, version control, branching strategies, and code reviews.
Experience working in structured development and release environments.
Ability to independently interpret requirements, design solutions, and deliver production-quality implementations.
Strong analytical reasoning, debugging, and problem-solving skills.

Professional Experience

12+ years of overall experience in data engineering, data warehousing, ETL/ELT, or related software engineering roles preferred.
Proven experience delivering complex data engineering projects using Snowflake and dbt.
Previous experience as a Senior, Lead, Staff, or Principal Data Engineer, or equivalent hands-on technical leadership experience.
Demonstrated ability to take ownership of complex deliverables with minimal day-to-day supervision.
Experience guiding other engineers and contributing to technical design and implementation decisions.
Strong written and verbal communication skills, particularly when collaborating with distributed and offshore teams.

Preferred / Additional Skills

The following skills will be advantageous but are not mandatory:

Experience migrating legacy data pipelines from Microsoft SQL Server, PostgreSQL, SSIS, or other ETL platforms into Snowflake and dbt.
Experience with Python for data processing, automation, testing, and engineering utilities.
Familiarity with AWS services, particularly S3 and cloud-based data ingestion architectures.
Experience with dbt Fusion and modern dbt development environments.
Knowledge of CI/CD automation for dbt and Snowflake.
Experience with AI coding assistants or agents such as Claude Code, GitHub Copilot, or similar tools.
Familiarity with KNIME and other enterprise ETL tools.
Experience working with CRM, marketing, fundraising, direct mail, or multi-client data platforms.
Experience with reusable data models, metadata-driven transformations, and configurable client-specific processing.
Familiarity with JIRA and Agile delivery methodologies.

Apply About employer

More about this job

Responsibilities

Design, develop, optimize, and maintain scalable Snowflake and dbt transformation pipelines, including modernizing legacy data systems and validating data accuracy. Own engineering deliverables end to end while providing technical guidance, reviewing code, mentoring engineers, and supporting quality and deployment practices.

Requirements

Requires advanced, production-level Snowflake, dbt, and SQL expertise, including at least five years of hands-on experience with both Snowflake and dbt; 12+ years of overall experience is preferred. Candidates should have strong data engineering and modeling skills, experience owning complex projects and guiding engineers, and a dbt Analytics Engineering or dbt Architect certification.

Skills

Snowflake
dbt
Advanced SQL
Data Engineering
Data Modeling
ETL/ELT
Data Migration
Query Optimization
Jinja
Python
Git/GitHub
CI/CD
Data Quality Testing
Technical Leadership
AWS S3
Agile Delivery

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
dbt
SQL
Data Engineering
Data Warehousing
ETL/ELT
Data Migration
Data Modernization
Data Modeling
Jinja
dbt Core
dbt Cloud
dbt Analytics Engineering Certification
dbt Architect Certification
Python
AWS
Amazon S3
Git
GitHub
CI/CD
Automated Testing
Data Quality
Query Optimization
Legacy Systems
Microsoft SQL Server
PostgreSQL
SSIS
KNIME
Agile
JIRA

Report this job