Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 1 month ago
EB
Lead AI Platform Engineer
EQ Bank | Canada's Challenger Bank
Toronto, ON
- Full-time
This role provides hands-on technical leadership across AI platform design, implementation, automation, observability, and production readiness. The incumbent ensures AI platform services…
Added 1 month ago
I
AI Engineer
Insight
Remote, Canada
- Full-time
- Remote
As a Solutions Architect, you will design and implement production-grade AI agents and multi-agent systems that use tools, call APIs, reason over enterprise data, and power modern mobile,…
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 2 months ago
FI
Principal Software Engineer - Zynque
Fulfillment IQ
Toronto, ON
- Full-time
Built or scaled an integration platform, ETL/data pipeline product, or API platform (connectors, transformation pipelines, webhooks)
Added 1 month ago
BC
Sr. Full Stack Software Engineer
Blackpoint Cyber
Remote, Canada
- $131,400 to $175,200 CAD / year
- Full-time
- Remote
The Product Engineering team is growing a small tiger team and is seeking an experienced Senior Full Stack Software Engineer who thrives in a fast-paced, remote environment. In this role,…
Added 1 month ago
J
Senior Software Engineer, Applied AI (Toronto)
Justworks
Toronto, ON
- $188,000 to $242,000 CAD / year
- Full-time
We are seeking a Senior Software Engineer with a strong passion for building AI-native systems in a product environment. The ideal candidate will be able to take ownership of large segments…
Added 1 month ago
KR
Senior BI ETL Developer
KTek Resourcing
Canada
- Contract
Working closely with application engineering, architecture, data/analytics and vendor teams. The Senior / Lead ETL Developer designs, develops, tests, deploys, and supports enterprise data…
Added 1 month ago
KR
Senior Java Software Engineer
KTek Resourcing
Montreal, QC
- Contract
Work Model: Hybrid – 3 days in office
Added 1 month ago
PX
Staff Machine Learning Engineer – AI & Agentic Systems
Project X Ltd.
Toronto, ON
- Full-time
…marketing decisions and workflows. The successful candidate will design and build production integrations between AI agents, enterprise APIs, agent orchestration frameworks and managed AI…
Added 1 month ago
PX
Staff Machine Learning Engineer – AI & Agentic Systems
Project X
Toronto, ON
- Full-time
…marketing decisions and workflows. The successful candidate will design and build production integrations between AI agents, enterprise APIs, agent orchestration frameworks and managed AI…
Added 1 month ago
VT
Senior AI Engineer
Vision Talent Co.
Toronto, ON
- $110,000 to $130,000 CAD / year
- Full-time
We are seeking a Senior AI Engineer to join a growing Corporate AI team responsible for delivering innovative AI solutions across the organization. The team has evolved from delivering…
Added 2 months ago
A
Senior Lead Software Engineer (Tax Solution), FinTech (Bangkok based, Relocation provided)
Agoda
Toronto, ON
- Full-time
…work across product, engineering, finance, and architecture to design robust solutions that balance control, flexibility, and…
Added 2 months ago
A
Senior Lead Software Engineer (Tax Solution), FinTech (Bangkok based, Relocation provided)
Agoda
Vancouver, BC
- Full-time
…work across product, engineering, finance, and architecture to design robust solutions that balance control, flexibility, and…
Added 2 months ago
A
Senior Lead Software Engineer (Tax Solution), FinTech (Bangkok based, Relocation provided)
Agoda
Montreal, QC
- Full-time
…work across product, engineering, finance, and architecture to design robust solutions that balance control, flexibility, and…
Added 2 months ago
A
Staff Technical Architect
Appnovation
Toronto, ON
- Full-time
As a Senior Technical Architect (Director level), you will join a highly motivated and experienced team as the technical leader accountable for crafting the technical strategy and…
Added 3 months ago
BV
Senior Full Stack Engineer, AI
Big Viking Games
Toronto, ON
- $100,000 to $150,000 CAD / year
- Full-time
This is a hybrid role based in Toronto, with an expectation of working in office three days per week
Added 2 months ago
EL
Solutions Architect – Digital Identity, Telco & Data Platforms
EnStream LP
Toronto, ON
- Full-time
EnStream is seeking an experienced Solutions Architect with a strong software engineering background to design and help implement secure, scalable solutions across our digital identity,…
Added 2 months ago
E
Senior Software Engineer, GenAI Workflows
Eyeline
Vancouver, BC
- $165,000 to $200,000 CAD / year
- Full-time
As Senior Software Engineer within GenAI Workflows, you will collaborate closely with GenAI-powered VFX stakeholders to understand user needs and use your deep understanding of ML processes…
Added 2 months ago
O
Senior Data Engineer, Data Integration & Performance Platform (12-Month Contract)
OMERS
Toronto, ON · Head Office Toronto
- Full-time
This is a senior engineering role on a multi‑year investment platform transformation that is replacing our core investment book of record with BlackRock Aladdin and building a new cloud…
Added 2 months ago
GP
Senior Software Engineer
Generac Power Systems
Toronto, ON · Canada - Toronto
- Full-time
Design, build, and evolve high-load, highly concurrent backend services that directly support ecobee’s products and business goals, including the Energy Control Platform (ECP), ecobee's API…
Added 2 months ago
UF
Senior Implementation Consultant
United Fintech
Toronto, ON
- Full-time
We are looking for an ambitious Senior Implementation Consultant, based in Toronto, to own delivery of our full-service Order Management (OMS) and Portfolio Management (PMS) platform for…
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
ES
Senior IAM Engineer
EPAM Systems
Toronto, ON
- Full-time
We are seeking a Senior IAM Engineer to design, implement, and maintain robust identity and access management solutions for customer-facing applications, ensuring secure and seamless…
Added 2 months ago
AG
DevSecOps – MTL / DevSecOps – Montréal
Aduna Global
Montreal, QC
- Full-time
…enabling engineering to move fast and adopt AI safely. As a Senior Security Engineer, you'll be an individual contributor accountable for implementing security solutions across Aduna's…
Added 2 months ago
Senior Software Engineer
BuildOps
Toronto, ON
We’re looking for a Senior Software Engineer to help build and scale the product experiences and systems behind that mission. In this role, you’ll work across frontend applications, backend…

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