Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 12 hours ago
BC
ETL Lead
BrainRidge Consulting
Toronto, ON
- Full-time
Present solution designs, progress updates, risks, and recommendations to stakeholders and senior leaders in clear, non-technical terms
Added 12 hours ago
M
Junior Rail Operations Analyst
Metrolinx
Canada
- Full-time
Proficiency in Power BI, along with strong Excel skills, are highly valued. Experience with Python or R, for data analysis and scripting, as well as knowledge of SQL or an equivalent…
Added 12 hours ago
Senior Software Engineer - Search & AI
Guidepoint
Toronto, ON
We are hiring a Senior Software Engineer to build and run the search systems that connect Guidepoint clients with the right experts. You will join the Search team in Data Engineering and…
Added 12 hours ago
GT
Senior Analyst, Trading Systems Management
Global Technical Talent, an Inc. 5000 Company
Toronto, ON
- $50 to $58 CAD / hour
- Contract
Identify opportunities to streamline processes through automation and improved data workflows using tools such as SQL, Python, Excel, or similar technologies
Added 12 hours ago
I
Systems Testing/QA Specialist - Senior
isgSearch
Toronto, ON · Greater Toronto Area, Canada
- Contract
Proficient in the use of SQL in supporting testing activities
Added 13 hours ago
ZS
Core Java Developer (Python, Apache, Spark)
Zodiac Solutions, Inc
Montreal, QC
- Full-time
We are seeking a highly motivated and experienced Software Engineer with strong expertise in Core Java, Apache Spark, Python, SQL, and Linux to design, develop, and support scalable…
Added 15 hours ago
M
Senior Java Full Stack Developer
Miratech
Toronto, ON
- Full-time
Working Model: This is a hybrid role requiring 2 days per week in a downtown Toronto office
Added 23 hours ago
J
Staff Threat Intelligence Researcher
Jobgether
Canada
- $86,000 to $240,000 USD / year
- Full-time
Strong analytical and scripting skills, including experience with SQL, Python, Kusto Query Language (KQL), SPL, or similar languages for large-scale data analysis, enrichment, and workflow…
Added 1 day ago
EC
Développeur(euse) logiciel sénior C# / Senior C# Software Developer
Eaton Corporation
Brossard, QC
- Full-time
Eaton’s Utility Digital Solutions (UDS) division is currently seeking a Senior Software Developer. Our team develops software solutions for the analysis and modeling of electrical…
Added 1 day ago
AI
QA Automation Engineer – Python, Playwright & SQL
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Toronto, ON
- Full-time
Senior QA Automation Engineer – Python, Playwright & SQL
Added 1 day ago
CI
Senior Automation & Performance Test Engineer - Contract
Compugen Inc
Toronto, ON
- Contract
Position Overview: We are seeking an experienced Senior Automation & Performance Test Engineer to design, develop, and execute automated and performance testing solutions for enterprise…
Added 1 day ago
B
Full Stack Engineer
BuzzClan
Toronto, ON
- Contract
Job Title: Software Developer - Full Stack - Senior
Added 1 day ago
CM
Marketing Science Lead
Critical Mass
Toronto, ON
- Full-time
Technical Expertise: Deep proficiency across modern marketing analytics platforms and cloud architecture (e.g., SQL, BigQuery, Python, Google Analytics 4, Adobe Analytics).
Added 1 day ago
K
Backend Engineer
Kablamo
Toronto, ON
- Full-time
Construct, deploy, and refine scalable backend services and APIs using Go, Python, or other modern languages that perform exceptionally in real-world environments.
Added 1 day ago
RB
Senior Manager, Business Intelligence & Reporting
Royal Bank of Canada
Toronto, ON
- Full-time
…structured, accessible and easy to use. Develop and maintain SQL Server Reporting Services (SSRS)…
Added 1 day ago
JG
Senior FinOps Engineer / Cloud Cost Optimization Lead
J&M Group
Toronto, ON
- Full-time
Strong Python, SQL, Terraform and infrastructure automation skills.
Added 1 day ago
C
Senior Manager AML Risk Insights
CIBC
Toronto, ON
- Full-time
You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit
Added 1 day ago
R
Senior Manager, Business Intelligence & Reporting
RBC
Toronto, ON
- Full-time
…structured, accessible and easy to use. Develop and maintain SQL Server Reporting Services (SSRS)…
Added 1 day ago
RI
Mobile Application Developer
Raas Infotek
Brampton, ON
- Contract
Job Title: Senior Full Stack & Mobile Application Developer
Added 1 day ago
K
Senior Manager, Data Platform(s) Architect, Data & AI
KPMG
Montreal, QC
- Full-time
Expert skills in SQL, Python, and distributed data processing.
Added 1 day ago
ZS
Senior AI Engineer
Zodiac Solutions, Inc
Montreal, QC
- Full-time
Strong hands-on Python development experience.
Added 1 day ago
GT
Senior BI Developer / Data Analyst - DAX and Power Query
Global Technical Talent, an Inc. 5000 Company
Toronto, ON
- $85 to $100 CAD / hour
- Contract
The Senior BI Developer will design and develop complex static and paginated reports using Power BI Report Builder, along with interactive Power BI dashboards. This individual will support…
Added 1 day ago
Senior Data Analyst
Gore Mutual Insurance
Toronto, ON · Cambridge, ON
Creation of data asset using SQL or Python that is used in consumption of downstream analysis (OBT creation)
Added 1 day ago
AG
Marketing Science Lead
Adelphi Group
Toronto, ON
- Full-time
· Technical Expertise: Deep proficiency across modern marketing analytics platforms and cloud architecture (e.g., SQL, BigQuery, Python, Google Analytics 4, Adobe Analytics).
Added 1 day ago
S
Manager, Unsecured Credit Risk
Scotiabank
Toronto, ON
- Full-time
This position combines strong technical execution with business acumen and effective communication to translate portfolio performance into actionable insights for senior stakeholders.

BrainRidge Consulting

ETL Lead

Toronto, ON, Canada

Full-time

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Dec 13, 2026
Experience: 10+ years of experience in ETL or data engineering, including leading ETL projects or workstreams (experience leading a team of developers is an asset)
Posting language: English
Posted: Nov 13, 2026

Original job description

About BrainRidge

BrainRidge Consulting is a premium FinTech technology consulting firm with the energy of a startup and the experience of an enterprise. Our mission is to empower financial institutions to thrive in the digital age, providing cutting-edge technology solutions and strategic guidance that drive innovation and growth. As we continue to grow, we're seeking a motivated and experienced ETL Lead.

Role Overview

We're seeking an experienced, hands-on, client-facing ETL Lead to own the design, delivery, and quality of data pipelines for a major Canadian bank as it modernizes its data platform on AWS. You'll lead ETL projects and workstreams from design through production. That means extracting data from multiple sources, storing it in raw form, and refining it through a medallion (bronze, silver, gold) architecture using AWS Glue, Redshift, and Step Functions. Working closely with business stakeholders, data architects, and analysts, you'll translate requirements into practical solutions, present designs and progress with confidence, and deliver reliable, well-controlled financial data that supports analytics, risk, and regulatory reporting.

Key Responsibilities

Lead ETL projects and workstreams end to end, including planning, estimating, coordinating with other teams, and tracking delivery

Engage with business and technology stakeholders to gather requirements, set expectations, and translate business needs into clear technical designs

Present solution designs, progress updates, risks, and recommendations to stakeholders and senior leaders in clear, non-technical terms

Design, build, and maintain ETL pipelines that extract data from multiple source systems and transform it into clean, business-ready datasets

Design and implement a medallion architecture, storing raw data in a bronze layer and refining it through silver and gold layers for analytics and reporting

Build and orchestrate pipelines on AWS using Glue, Redshift, and Step Functions, with supporting services such as S3, Lambda, and CloudWatch

Write and maintain shell scripts to automate, schedule, and support data processing jobs, and stay hands-on in development and troubleshooting

Own data quality and controls across pipelines, including reconciliation, validation rules, audit logging, and data lineage, in line with the bank's governance requirements

Guide and mentor other developers, conduct code reviews, and lead root cause analysis and long-term fixes for production issues

Qualifications

10+ years of experience in ETL or data engineering, including leading ETL projects or workstreams (experience leading a team of developers is an asset)

Hands-on experience building ETL pipelines on AWS, including Glue, Redshift, and Step Functions

Proven experience designing and implementing medallion (bronze, silver, gold) architectures on AWS or Azure

Strong stakeholder management skills, including gathering requirements, managing expectations, and presenting technical information to business and executive audiences

Experience with banking, capital markets, or other financial services data, including data quality, reconciliation, and regulatory controls

Expert-level SQL and strong data warehouse design skills, including dimensional modelling, slowly changing dimensions, and change data capture

Strong, hands-on shell scripting skills (e.g., Bash or Korn shell)

Assets: Python or PySpark, Azure data services, and enterprise ETL tools (e.g., Informatica, DataStage, or Talend)

Bachelor's degree in Computer Science, Information Systems, or a related field

Excellent communication, problem-solving, organizational, and leadership skills

Our Commitment

At BrainRidge Consulting, we value and prioritize diversity, equity, and inclusion. We believe a diverse and inclusive workplace leads to a more innovative and productive team. We welcome applicants of all backgrounds and are committed to a safe, fair, and welcoming environment where everyone feels valued and respected. If you require accommodations during the hiring process, please let us know.

Apply on LinkedIn About employer

More about this job

Responsibilities

Lead ETL projects end to end, designing, building, and operating AWS data pipelines that refine raw data through bronze, silver, and gold layers. Coordinate with stakeholders, ensure data quality and governance controls, communicate delivery progress, and mentor developers while resolving production issues.

Requirements

Requires 10+ years of ETL or data engineering experience, hands-on AWS Glue, Redshift, and Step Functions expertise, and experience implementing medallion architectures. Candidates should bring strong SQL, shell scripting, data warehouse design, financial-services data controls, stakeholder communication, and leadership skills; a bachelor's degree in a related field is listed.

Skills

ETL
AWS Glue
Amazon Redshift
AWS Step Functions
Amazon S3
AWS Lambda
Amazon CloudWatch
SQL
Shell Scripting
Data Warehouse Design
Dimensional Modeling
Slowly Changing Dimensions
Change Data Capture
Data Quality
Stakeholder Management
Medallion Architecture

Visa sponsorship

Not detected in the job text

Keywords

ETL
Data Engineering
AWS
AWS Glue
Amazon Redshift
AWS Step Functions
Amazon S3
AWS Lambda
Amazon CloudWatch
Medallion Architecture
Bronze Layer
Silver Layer
Gold Layer
SQL
Bash
Korn Shell
Python
PySpark
Azure Data Services
Informatica
DataStage
Talend
Data Warehouse Design
Dimensional Modeling
Slowly Changing Dimensions
Change Data Capture
Data Quality
Data Reconciliation
Data Lineage
Regulatory Reporting

Report this job

Work requirements

Jobs in Canada