Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 2 months ago
AA
Software Developer IV, Data
ACV Auctions
Toronto, ON
- Full-time
We are looking for an exceptional Senior Software Developer to join our Platform Engineering group, focusing on the VIN Decoder platform. The position will focus on backend development, AWS…
Added 1 month ago
KR
Senior BI ETL Developer
KTek Resourcing
Canada
- Contract
Platform scope: Snowflake, Matillion ETL/ELT, Microsoft Azure data services, Microsoft SQL Server, Azure SQL, Azure Data Lake Storage, Azure Key Vault, Azure DevOps, secure file and API…
Added 1 month ago
SI
Full Stack Engineer
Stelvio Inc.
Saskatoon, SK
- Full-time
…solutions for complex, real-world environments. Working alongside senior developers, architects, project managers and wider cross-functional teams, you’ll help design, develop and maintain…
Added 2 months ago
TT
2027 Accelerated Development Program - BrainBox AI
Trane Technologies
Montreal, QC
- Full-time
Une présence physique à votre lieu de travail assigné est requise 5 jours par semaine
Added 2 months ago
HR
Senior Engineering Supervisor, Electrical
Hughes Recruitment & Strategy Collective
Saskatoon, SK
- Full-time
As the Intermediate/Senior Electrical Engineer, you will possess the following qualities:
Added 2 months ago
Z
Lead Engineer - Data
ZS
Toronto, ON
- Full-time
Proficiency in SQL, Python, or other relevant programming languages.
Added 2 months ago
TA
Manager, Analytics Consulting
Tiger Analytics
Canada
- Full-time
Working familiarity with analytical tools such as Excel, SQL, BI/visualization tools and/or Python
Added 2 months ago
E
Senior Software Engineer, Finance Systems
Eyeline
Vancouver, BC
- $165,000 to $200,000 CAD / year
- Full-time
The Senior Software Engineer (Finance System) sits on the Platform Engineering team and works day to day with Production Finance to build, support, and improve the studio's bidding,…
Added 2 months ago
TT
2027 Accelerated Development Program - BrainBox AI
trane technologies
Montreal, QC
- Full-time
Une présence physique à votre lieu de travail assigné est requise 5 jours par semaine
Added 2 months ago
ES
Senior Application Engineer
EPAM Systems
Canada
- Full-time
We are seeking a highly skilled Senior Application Engineer with deep T-SQL expertise to join the Liquid Credit Engineering Team, a key division within our broader Investment Systems…
Added 2 months ago
O
Senior Data Engineer, Data Integration & Performance Platform (12-Month Contract)
OMERS
Toronto, ON · Head Office Toronto
- Full-time
Write production‑grade SQL and Python/PySpark code; optimise query performance, partition strategies, and warehouse sizing for cost and speed.
Added 2 months ago
O
Data Engineer, Data Integration & Performance Platform (12-Month Contract)
OMERS
Toronto, ON · Head Office Toronto
- Full-time
…someone to simply complete tickets. We are looking for a future senior engineer - someone who wants to learn how enterprise data platforms are built, operated, and scaled, and who is…
Added 2 months ago
S
Technical Engineer, Healthcare IT & PACS/Spécialiste technique, TI en santé et PACS
Sectra
Vancouver, BC
- Full-time
…service-minded individuals with a passion for healthcare. As a Technical Engineer your role will focus on deploying and supporting critical systems that drive improved clinical…
Added 2 months ago
C
Senior Software Engineer - AI / ML
CyberCoders
Canada
- Full-time
We're looking for a Senior AI/ML Engineer to help expand our next-generation document intelligence system. Working in close collaboration with our Data Science team, you'll bring deep…
Added 2 months ago
OS
Python Developer
Open Systems Technologies
Mississauga, ON
- Contract
…building and supporting modern software solutions leveraging Python, microservices, APIs, event-driven architectures, and emerging AI…
Added 2 months ago
A
Senior Full Stack Engineer (Application + Data)
Article
Vancouver, BC
- $165,000 to $175,000 CAD / year
- Full-time
We are a hybrid team - you'll be in the office 3 days per week
Added 2 months ago
Senior AI/ML Engineer
Katalyst Data Management
Calgary, AB
Join the dynamic and collaborative team at Katalyst Data Management (KDM)! KDM is seeking a Senior AI/ML Engineer to help design, build, and operate the infrastructure that powers our next…
Added 2 months ago
AG
Senior Data Engineer / Ingénieur(e) de données senior
Aduna Global
Montreal, QC
- Full-time
…cross-operator analytics that feed our BI, analytics, and ML. As our Senior Data Engineer, you will design our lakehouse from the first table onward, then build and operate the pipelines…
Added 2 months ago
R
Senior Data Engineer
RBC
Vancouver, BC
- Full-time
In this role as a Senior Data Engineer, you will be responsible for development deliverables for the Finance Data Platform. The Platform, leverages Airflow and Databricks and serves as the…
Added 2 months ago
P
Principal AI Engineer
PointClickCare
Mississauga, ON
- $191,700 to $213,000 CAD / year
- Full-time
PointClickCare is searching for a Principal AI Engineer who will lead and design AI systems across multiple SaaS solutions following our AI Design Patterns, defining technical standards and…
Added 2 months ago
P
Senior Data Engineer - Snowflake - Contract
Propel
Canada
- Contract
We are looking for a Snowflake Data Engineer to help build and maintain their cloud data warehouse and pipelines. This is a hands on role that involves taking ownership of moderately…
Added 2 months ago
TA
Manager, Analytics Consulting (Retail/CPG)
Tiger Analytics Inc.
Remote, Canada
- Full-time
- Remote
Working familiarity with analytical tools such as Excel, SQL, BI/visualization tools and/or Python.
Added 2 months ago
Senior Data Engineer, AI & Agents
Appnovation Technologies
Toronto, ON
As a Senior Data Engineer, AI & Agents, you will prepare enterprise domain data for consumption by AI agents, partnering directly with business stakeholders and subject-matter experts. The…
Added 2 months ago
F
Senior Data Engineer / Ingénieur(e) de données senior
Flinks
Remote, Canada
- Full-time
- Remote
We're hiring our Senior Data Engineer (Data / ML Platform) to stand up data engineering as a discipline at Flinks. You'll own the data and ML platform that turns models into reliable…
Added 2 months ago
RB
Senior Data Engineer
Royal Bank of Canada
Vancouver, BC
- Full-time
In this role as a Senior Data Engineer, you will be responsible for development deliverables for the Finance Data Platform. The Platform, leverages Airflow and Databricks and serves as the…

KTek Resourcing

Senior BI ETL Developer

Canada

Contract

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type: Contract
Posting language: English
Posted: Sep 14, 2026

Original job description

BI ETL Sr Developer /Lead developer

Working closely with application engineering, architecture, data/analytics and vendor teams. The Senior / Lead ETL Developer designs, develops, tests, deploys, and supports enterprise data integration solutions. The role provides hands-on technical leadership for reliable, secure, scalable, and maintainable data pipelines that moves and transforms data across our operational environments. The position leads complex delivery efforts, establishes ETL development standards, performs design and code reviews, mentors developers, troubleshoots production issues, and ensures solutions align with enterprise architecture, data governance, SDLC, DevOps, security, and operational standards.

Platform scope: Snowflake, Matillion ETL/ELT, Microsoft Azure data services, Microsoft SQL Server, Azure SQL, Azure Data Lake Storage, Azure Key Vault, Azure DevOps, secure file and API integrations, and enterprise reporting and analytics touchpoints. Additional technologies may include Power BI, Python, PowerShell, REST APIs, SFTP, event-driven integration, and metadata or data quality tooling.

Essential functions:

Design, develop, test, deploy, and support complex ETL and ELT pipelines using Matillion, Snowflake, Azure services, and SQL Server.
Serve as the technical lead for assigned data integration initiatives, translating business and technical requirements into scalable solution designs and delivery plans.
Build reusable ingestion, transformation, orchestration, and publishing patterns for batch, micro-batch, near-real-time, file-based, API-based, and database-source workloads.
Develop and optimize Snowflake solutions, including SQL transformations, schemas, tables, views, stages, file formats, streams, tasks, stored procedures, and secure data-sharing patterns as applicable.
Develop and maintain Matillion jobs, components, variables, environments, orchestration workflows, error handling, scheduling, and operational controls.
Implement Azure-based integration components using services such as Azure Data Lake Storage, Azure Key Vault, Azure Functions, Logic Apps, Azure Data Factory, and related platform capabilities where appropriate.
Lead source-to-target mapping, data profiling, transformation rule definition, reconciliation design, and technical data lineage documentation.
Apply data quality controls for completeness, accuracy, validity, timeliness with measurable validation and exception handling.
Engineer restartable and supportable pipelines with logging, auditability, checkpoints, alerts, dependency management, retry behavior, and recovery procedures.
Optimize pipeline through query tuning and workload analysis.
Implement secure data integration practices, including least-privilege access, secrets management, encryption, service account governance and masking.
Create unit and reconciliation tests.
Lead peer reviews of solution designs, SQL, Matillion jobs, deployment artifacts, and technical documentation to ensure quality, consistency, supportability, and standards compliance.
Build and maintain CI/CD practices using Azure DevOps, including source control, branching, pull requests, automated deployment, environment-specific configuration, approvals, and rollback planning.
Coordinate releases across development, test, user acceptance, and production environments, including readiness reviews and post-deployment validation.
Troubleshoot failed or delayed pipelines, and upstream or downstream integration failures.
Create and maintain technical specifications, diagrams, source-to-target mappings, runbooks, support procedures, deployment instructions, and knowledge articles.
Provide estimates, identify dependencies and risks, break work into actionable deliverables, and communicate progress, blockers, decisions, and technical tradeoffs to delivery stakeholders.
Collaborate with internal teams, managed service providers, and technology vendors to resolve issues, coordinate delivery, and promote effective knowledge transfer.
Perform other duties as assigned.

Qualifications: Required Minimum Education and Industry Experience:

Bachelor's degree in Information Technology, Computer Science, Data Engineering, Information Systems, Engineering, or a related field; or an equivalent combination of education and experience.
7+ years of progressive experience developing and supporting enterprise ETL, ELT, data integration, data engineering, or data warehouse solutions.
3+ years of experience serving as a senior developer, technical lead, workstream lead, or primary technical owner for complex data integration delivery.
Demonstrated hands-on experience with CI/CD pipelines (Azure DevOps), Snowflake, Matillion, Microsoft Azure, and Microsoft SQL Server in production enterprise environments.
Experience leading solution design, code review, release coordination, production troubleshooting, and technical mentoring for data integration teams.

Preferred Education, Additional Qualifications and Experience:

Master's degree in Information Technology, Computer Science, Data Science, Data Engineering, Business Information Systems, Engineering, or a related field.
Experience in healthcare, insurance, financial services, or another regulated environment with strong privacy, security, auditability, retention, and compliance requirements.
Experience modernizing legacy ETL platforms and migrating data pipelines or analytical workloads to Snowflake and Azure.
Experience integrating relational databases, flat files, JSON, XML, REST APIs, SFTP endpoints, SaaS platforms, and external vendor data feeds.
Relevant certifications such as SnowPro, Matillion, Microsoft Azure Data Engineer, Azure Solutions Architect, or Microsoft data platform certifications.
Experience working with agile delivery teams, managed service providers, offshore partners, software vendors, and cross-functional enterprise stakeholders.

Required Knowledge, Skills, and/or Abilities:

Advanced hands-on Snowflake knowledge, including SQL development, virtual warehouses, resource monitors, stages, file formats, data loading and unloading, performance optimization, security concepts, and cost-aware design.
Advanced Matillion development skills, including orchestration and transformation jobs, reusable components, variables, environments, connectors, scheduling, logging, error handling, and deployment practices.
Strong knowledge of Microsoft Azure data and integration services, cloud security patterns, managed identities or service principals, secrets management, storage, networking considerations, monitoring, and deployment automation.
Strong understanding of ETL and ELT architecture, batch and incremental loading, change data capture concepts, slowly changing dimensions, dependency management, orchestration and restart ability.
Ability to translate functional requirements, data mappings, interface specifications, and business rules into technically sound integration designs.
Knowledge of enterprise data warehousing, dimensional modeling, normalization, data lakes, analytical platforms, semantic and reporting layers, and data lifecycle management.
Experience implementing data quality, reconciliation, control totals, balancing, exception processing, lineage, metadata, and audit frameworks.
Strong understanding of secure engineering practices for sensitive data, including least privilege, encryption, masking, credential management, access logging, retention, and environment separation.
Experience with Git-based source control and Azure DevOps practices, including branching, pull requests, build and release pipelines, approvals, configuration management, and deployment traceability.
Ability to diagnose complex data, application, database, network, authentication, and performance issues across multi-platform integration flows.
Experience applying SDLC, DevOps, change management, incident management, problem management, and production support practices.
Ability to lead technical design discussions, provide constructive review feedback, establish standards, mentor developers, and influence delivery without direct supervisory authority.
Strong analytical, organization, and prioritization skills with the ability to manage multiple initiatives, production concerns, and competing deadlines.
Excellent written and verbal communication skills, including the ability to explain data issues, solution options, risks, dependencies, and tradeoffs to technical and non-technical audiences.
Ability to operate effectively within agile, waterfall, hybrid, governance-driven, and ITIL-based operating models."

Apply on LinkedIn About employer

More about this job

Responsibilities

The Senior BI ETL Developer designs, develops, and supports enterprise data integration solutions and scalable data pipelines. They provide technical leadership, establish development standards, and ensure alignment with enterprise architecture and security standards.

Requirements

Requires a bachelor's degree and 7+ years of experience in ETL/ELT development, with at least 3 years in a lead role. Proficiency in Snowflake, Matillion, Azure services, and CI/CD pipelines is essential.

Skills

Snowflake
Matillion
Azure Data Factory
SQL Server
Azure DevOps
ETL/ELT
Python
Power BI
CI/CD
Data Modeling
REST APIs
Data Governance
Azure Data Lake Storage
Azure Key Vault
Data Profiling
Performance Tuning

Visa sponsorship

Not detected in the job text

Keywords

Snowflake
Matillion
Azure
SQL Server
Azure Data Lake Storage
Azure Key Vault
Azure DevOps
Power BI
Python
PowerShell
REST APIs
SFTP
ETL
ELT
CI/CD
Data Warehousing
Dimensional Modeling
Data Governance
SDLC
SnowPro
Azure Data Engineer
Azure Solutions Architect
Data Lineage
Data Quality
Change Data Capture
Slowly Changing Dimensions
Agile
ITIL
Data Engineering
Cloud Security

Report this job

Work requirements

Jobs in Canada