Find work in Canada.

571,727 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 3 mins ago
C
Winter 2027 : AI Developer Co-op (8 months)
CGI
Toronto, ON
- Full-time
The AI Developer (Co-op) will contribute to the design, development, and deployment of AI-powered software solutions, with a strong focus on Generative AI, Agentic AI, LLM integration, and…
Added 3 mins ago
A
Power BI Developer
Akkodis
Toronto, ON
- Full-time
The Power BI Developer is a business-focused analytics role responsible for partnering closely with business teams to design, deliver and sustain insightful Power BI dashboards and reports.…
Added 3 mins ago
C
DevOps & Cloud Application Support Consultant
CGI
AB · Alberta, Canada
- Full-time
CGI is seeking a DevOps & Cloud Application Support Consultant to join our team and support the development, deployment, and ongoing operation of modern digital banking solutions. In this…
Added 3 mins ago
UO
Digital Enablement Developer
University of Manitoba
Winnipeg, MB
- $60,205.6 to $86,850.4 CAD / year
- Full-time
We are seeking a Digital Enablement Developer who enjoys solving complex business challenges through technology and is passionate about building practical solutions that improve efficiency,…
Added 3 mins ago
S
Manager, Quantitative Strategies & Analytics
Scotiabank
Toronto, ON
- Full-time
The Manager provides analytical expertise to deliver data-driven insights, modernize and automate processes, and build purpose-built quantitative tools that enhance the investment process…
Added 3 mins ago
Millwright / Machine Builder / Tool & Die Maker
Eclipse Automation
Cambridge, ON
Eclipse Automation delivers cutting-edge custom automated manufacturing solutions across multiple industries. We combine advanced automation expertise with digital innovation to create…
Added 3 mins ago
UT
Software Developer 3- #26-27660
US Tech Solutions
Markham, ON
- $60 to $70 USD / hour
- Contract
Develop and integrate APIs, backend services, and data solutions that support automation workflows.
Added 3 mins ago
AI
Nuclear Services Tech
ATS Industrial Automation
Cambridge, ON
- Full-time
At ATS, a publicly traded global company with a proud 40-year history, we help drive the future with our factory-wide automation solutions. At ATS Industrial Automation, what we do matters…
Added 18 mins ago
M
Innovation Leader, Financial Advisory Services
MNP
AB · Calgary, AB
- Full-time
…with key leaders across MNP to evaluate, prioritize, design, and execute on new products and services that will continually redefine and enhance how we serve our clients. As a trusted…
Added 33 mins ago
E
Specialist, System Integration - Health Care
EllisDon
Mississauga, ON
- Full-time
We recognize that the construction industry is changing at a rapid pace and we continually strive to be at the forefront. Our core values empower people to deliver great careers to one…
Added 48 mins ago
S
Account Manager, Enterprise Sales
SOTI
Mississauga, ON
- Full-time
At SOTI, we are committed to delivering best-in-class mobile and IoT device management solutions. We are looking for unconventional thinkers who appreciate the art of creating great…
Added 48 mins ago
F
Senior / Staff Engineer, Applied AI (Float Intelligence)
Float
Remote, Canada
- Full-time
- Remote
You Act Like an Owner. You take responsibility for outcomes, step up to challenges, and seek solutions proactively - doing what's best for the business, not just your role.
Added 48 mins ago
OT
Junior Instrumentation Technician
Ontario Transit Group
Toronto, ON
- Full-time
Strong proficiency in Python, Power Query, or other data automation tools, with the ability to develop innovative solutions, streamline workflows, and transform complex datasets into…
Added 48 mins ago
VI
Staff Information Security Engineer - Threat Detection & Response
Visier Inc.
Vancouver, BC
- Full-time
…technology by surfacing the insights leaders need to plan, decide, and act with confidence in the moments that matter most. As the market leader in people analytics, workforce planning,…
Added 48 mins ago
Z
Software Engineer, Backend (All Levels)
Zip
Toronto, ON
- Full-time
Work closely with cross functional product and customer-facing teams to understand requirements and ship thoughtful solutions.
Added 49 mins ago
Q
Senior Revenue Enablement Specialist, Digital
Quadient
Markham, ON
- $90,000 to $100,000 CAD / year
- Full-time
At Quadient, we support businesses of all sizes in their digital transformation and growth journey, unlocking operational efficiency with reliable, secure, and sustainable automation…
Added 49 mins ago
H
Bilingual Senior L3 AI Engineer
HRConnects
Montreal, QC
- Full-time
Are you a seasoned AI professional with a passion for enterprise-scale solutions and a knack for solving complex technical challenges? We are seeking a dynamic Senior Level 3 AI Engineer to…
Added 1 hour ago
PG
Commercial Marketing Manager
Purity Gas
Toronto, ON · Greater Toronto Area, Canada
- Full-time
Lead the commercial marketing strategy for new products, solutions and programs, including positioning, value propositions, messaging, sales tools and customer communications.
Added 1 hour ago
EA
Business Development Manager
Ethos Automation Inc
Brantford, ON
- Full-time
At Ethos Automation, we're passionate about solving problems, building relationships, and creating innovative solutions for our customers. We believe great ideas come from great people, and…
Added 1 hour ago
H
Tester (Point-of-Sale)
HCLTech
Vancouver, BC
- $70,000 to $80,000 CAD / year
- Full-time
2+ years of experience in using automation tools such as Playwright or Cypress and should be comfortable to program as needed
Added 1 hour ago
B
Maintenance & Reliability Manager
Bimeda
Cambridge, ON
- Full-time
Lead implementation and adoption of new maintenance processes, technologies, automation and digital tools where they create measurable value.
Added 1 hour ago
AP
Senior Backend Developer
Accommodations Plus International
Markham, ON
- $125,000 to $135,000 CAD / year
We’re hiring a Senior Backend Developer to build and maintain the services, APIs, and integrations behind our enterprise-grade applications. This is a hands-on development role: you’ll…
Added 1 hour ago
AP
Senior Full Stack Developer
Accommodations Plus International
Markham, ON
- $125,000 to $135,000 CAD / year
We’re hiring a Senior Full Stack Developer to build and maintain enterprise-grade applications across our Java and modern frontend stack. This is a hands-on development role: you’ll write…
Added 1 hour ago
FS
Senior Analyst, Quality Assurance Products
Four Seasons Hotels and Resorts
Toronto, ON · Four Seasons Corporate Headquarters Toronto
- Full-time
The Senior Analyst, Quality Assurance (QA) Products is responsible for executing and supporting QA activities across Microsoft Dynamics 365 Finance & Operations enhancements, integrations,…
Added 1 hour ago
TH
Maintenance Specialist - The Stella
Tricon Homes
Toronto, ON · The Stella, Toronto ON
- Full-time
Tricon was one of the first movers to enter Toronto’s purpose-built rental apartment sector with scale in 2016 and is developing the highest quality multi-family portfolio in North…

Mitra AI

Lead / Principal Data Engineer - Snowflake & dbt

Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Posting language: English
Posted: Nov 3, 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 production-quality development practices.

Requirements

Requires at least five years of hands-on experience with Snowflake and dbt, expert SQL skills, and demonstrated ability to deliver complex data engineering projects. The posting prefers 12 or more years of overall experience and expects independent technical ownership, leadership, and strong communication skills; a dbt Analytics Engineering or Architect certification is also specified.

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

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
dbt
dbt Core
dbt Cloud
dbt Analytics Engineering Certification
dbt Architect Certification
SQL
Jinja
Python
Git
GitHub
AWS
Amazon S3
CI/CD
ETL
ELT
Data Warehousing
Data Modeling
Dimensional Modeling
Data Migration
Legacy System Modernization
Incremental Models
dbt Macros
Data Quality
Reconciliation Testing
Query Optimization
KNIME
Microsoft SQL Server
PostgreSQL
SSIS

Report this job