ETL Lead

BrainRidge Consulting

Location
Toronto, Ontario, Canada
Role
Senior · Leadership
Pay
Not disclosed
Listed
Nov 13, 2026
Apply on the original listing →

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 the original listing →

This listing was collected from a public job posting. Applications go through the original listing. It may close without notice.

Job alerts

New Informatica roles, by email.

One short email a day when roles are added. No recruiters, no spam, unsubscribe in one click.

The Brief

The iPaaS newsletter, by email.

What is changing in integration work, who is hiring, and what it pays. From the team behind iPaaS Jobs.

Free. One email to confirm, unsubscribe anytime.