ETL Lead

BrainRidge Consulting

Toronto

On-site

CAD 120,000 - 190,000

Full time

33 hours ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

BrainRidge Consulting is seeking an experienced ETL Lead to own the end-to-end design and delivery of data pipelines for a major Canadian bank on AWS. You will lead projects, translate business needs into technical designs, and drive quality and governance across the medallion architecture.

You will work hands-on with Glue, Redshift, and Step Functions, mentor developers, and partner with stakeholders to ensure reliable, analytics-ready data for risk and regulatory reporting.

Qualifications

  • 10+ years of ETL or data engineering experience including leading projects or teams
  • Hands-on experience building ETL pipelines on AWS (Glue, Redshift, Step Functions)
  • Proven medallion architecture design experience on AWS or Azure
  • Strong stakeholder management and ability to present to executives
  • Experience with banking/financial data quality, reconciliation and governance
  • Expert SQL and data warehouse design skills
  • Shell scripting and hands-on development ability
  • Assets: Python/PySpark, Azure data services, and enterprise ETL tools
  • Bachelor's degree in Computer Science or related field
  • Excellent communication and leadership skills

Responsibilities

  • Lead ETL projects end-to-end, including planning, estimation, and delivery
  • Gather requirements from stakeholders and translate into technical designs
  • Present designs and progress to executives in clear terms
  • Design, build and maintain ETL pipelines from multiple sources
  • Implement medallion data architecture (bronze, silver, gold) for analytics
  • Orchestrate pipelines on AWS with Glue, Redshift, and Step Functions
  • Develop automation scripts to support data processing jobs
  • Ensure data quality, lineage, audit logging and governance compliance
  • Mentor developers, review code, and drive production issue fixes

Skills

ETL/Data engineering
SQL
Stakeholder management
Leadership
Problem solving

Education

Bachelor's degree in CS/IS

Tools

AWS Glue
AWS Redshift
AWS Step Functions
S3
Lambda

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Data Engineer
Sr Data Engineer

ML arteka • Toronto

Hybrid
CAD 110,000 - 150,000
Discounts on shopping & gym
Insurance plans
Office perks & coffee
Data Analytics Lead
Data Analytics Lead

Altis • Markham

Hybrid
CAD 100,000 - 150,000
Hybrid work
Career growth
Impactful projects
+1
Data Engineer
Data Engineer

Jliconsulting • Vaughan

On-site
CAD 80,000 - 100,000
Data & Analytics lead
Data & Analytics lead

Altis • Markham

Hybrid
CAD 100,000 - 125,000
Senior ETL Developer
Senior ETL Developer

Randstad Digital • Oakville

Hybrid
CAD 90,000 - 110,000
Competitive salary and benefits
Dynamic team environment
Recognition as a top workplace
Senior AWS Data Engineer (Strong Databricks)
Senior AWS Data Engineer (Strong Databricks)

Ccube • Mississauga

Hybrid
CAD 120,000 - 170,000
Senior Data Engineer
Senior Data Engineer

Cpus Engineering Staffing Solutions Inc. • Pickering

Hybrid
CAD 90,000 - 120,000
Senior Data Developer
Senior Data Developer

Cpus Engineering Staffing Solutions Inc. • Pickering

Remote
CAD 80,000 - 120,000
Intermediate Data Engineer ( SQL, Databricks/ Snowflakes, DBT, Airflow)
Intermediate Data Engineer ( SQL, Databricks/ Snowflakes, DBT, Airflow)

Talent To Hire Inc. • Toronto

Hybrid
CAD 80,000 - 100,000
Data Team Lead / Data Architect (MongoDB, Redshift, Glue) B2B SaaS
Data Team Lead / Data Architect (MongoDB, Redshift, Glue) B2B SaaS

Confidential Company • Toronto

Remote
CAD 130,000 - 160,000
Paid Vacation
Holidays
Benefits Program