Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 4 mins ago
GC
AI Engineer
GEI Consultants, Inc.
Guelph, ON
- $110,000 to $150,000 CAD / year
- Full-time
Proficiency in at least one programming language such as Python, PySpark, R, or SQL.
Added 4 mins ago
U
Insurance Business Analyst
UST
ON · Ontario, Canada
- Full-time
Familiarity with data tools (SQL, Power BI, Tableau, Python)
Added 4 mins ago
E
Senior Java Full Stack Developer
EngRadar
Toronto, ON
- Volunteer
Working Model: This is a hybrid role requiring 2 days per week in a downtown Toronto office
Added 5 mins ago
RI
Full Stack Mobile Application Developer (Front-End, Back-End, iOS, and Android platforms)
Raas Infotek
Brampton, ON
- Contract
Location: Brampton, ON (Hybrid- 3days in office per week)
Added 5 mins ago
CI
Data Engineer
Citylitics Inc.
Toronto, ON
- $90,000 to $110,000 CAD / year
- Full-time
This role requires a strong command of data engineering best practices, a track record with orchestration and data warehouses, and hands-on experience shipping LLM and agentic workflows to…
Added 5 mins ago
M
Senior Business Intelligence Performance Analyst
Metrolinx
Toronto, ON
- Full-time
Advanced skills in MS Excel and familiarity with BI tools for both query and visualization (i.e. SQL, Python, Power BI, Power Automate, etc.)
Added 21 mins ago
C
IT Quality Sr Analyst - Assistant Vice President
Citi
Mississauga, ON
- Full-time
Perform database validation by writing and executing SQL queries to ensure data integrity.
Added 35 mins ago
Data Analyst
Aecon
Toronto, ON
Strong SQL and Excel skills, with practical scripting ability in Python or PowerShell.
Added 51 mins ago
Y
Full stack Developer (Web and App)
Yochana
Brampton, ON
- Contract
Role: Full stack Developer (Web and App)-Hybrid - Brampton
Added 1 hour ago
RI
Full stack Developer (Web and App) - iOS / Android
Raas Infotek
Toronto, ON
- Contract
Full stack Developer (Web and App) Job Description – Senior Full Stack Developer (FE / BE / iOS / Android)
Added 1 hour ago
B
Senior Database Administrator
Bombardier
Dorval, QC
- Full-time
Working knowledge of scripting and automation such as PowerShell, Python, Bash, or equivalent, together with an understanding of DevOps and Infrastructure-as-Code practices.
Added 1 hour ago
BC
ETL Lead
BrainRidge Consulting
Toronto, ON
- Full-time
Expert-level SQL and strong data warehouse design skills, including dimensional modelling, slowly changing dimensions, and change data capture
Added 1 hour ago
HM
Junior Data Analys
Hossam Magdy And Partners
Canada
- Full-time
Familiarity with SQL for querying and extracting data is preferred.
Added 1 hour ago
GC
January 2027 Industrial Networking (Digital Systems) Co-op
Glencore Canada
Sparwood, BC
- $4,117 to $6,167 CAD / month
- Full-time
Understanding of WhatsUp Gold, ServiceNow, PLC's, IO servers, c, c++, Power shell, SQL, Python, Cisco switches Fortinet firewall, Cisco wireless access points, RTUs, PLCs, IoT/edge devices,…
Added 1 hour ago
A
MS Fabric Data Engineer
Altis
Toronto, ON · North York, ON
- $70 to $80 CAD / hour
- Contract
You’ll use scripting and SQL to extract, transform, validate, and reconcile data from multiple sources.
Added 1 hour 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…

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