ETL Lead

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.