Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Etl Lead

BrainRidge Consulting

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 deliveryEngage with business and technology stakeholders to gather requirements, set expectations, and translate business needs into clear technical designsPresent solution designs, progress updates, risks, and recommendations to stakeholders and senior leaders in clear, non-technical termsDesign, build, and maintain ETL pipelines that extract data from multiple source systems and transform it into clean, business-ready datasetsDesign and implement a medallion architecture, storing raw data in a bronze layer and refining it through silver and gold layers for analytics and reportingBuild and orchestrate pipelines on AWS using Glue, Redshift, and Step Functions, with supporting services such as S3, Lambda, and CloudWatchWrite and maintain shell scripts to automate, schedule, and support data processing jobs, and stay hands-on in development and troubleshootingOwn data quality and controls across pipelines, including reconciliation, validation rules, audit logging, and data lineage, in line with the bank's governance requirementsGuide and mentor other developers, conduct code reviews, and lead root cause analysis and long-term fixes for production issuesQualifications
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 FunctionsProven experience designing and implementing medallion (bronze, silver, gold) architectures on AWS or AzureStrong stakeholder management skills, including gathering requirements, managing expectations, and presenting technical information to business and executive audiencesExperience with banking, capital markets, or other financial services data, including data quality, reconciliation, and regulatory controlsExpert-level SQL and strong data warehouse design skills, including dimensional modelling, slowly changing dimensions, and change data captureStrong, 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 fieldExcellent communication, problem-solving, organizational, and leadership skillsOur 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.
#J-18808-Ljbffr
Vacancy posted more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Etl Lead. Be the first to apply!