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
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 1 hour ago
Similar jobs that could be interesting for youBased on the Etl Lead in Winnipeg, MB vacancy
- Iris's Direct client, a highly diversified financial services provider based in Canada is looking to hire an ETL Lead for a Long Term Contract opportunity. Location: Toronto, ON (Hybrid, 3 days onsite in a week) Required Qualifications SQL, ETL tools (Informatica...SuggestedLong term contract3 days per week
$75k - $125k per year
Job Summary: We are seeking an experienced ETL/ELT Engineer to design, develop, and maintain robust data pipelines using Informatica IICS and Snowflake. The ideal candidate will have strong SQL skills, experience with source-to-target mappings, and the ability to validate...Suggested- AWS ETL leadership meets hands-on data engineering at BrainRidge Consulting, delivering reliable pipelines for a major Canadian bank. Design... ...Redshift, and Step Functions.As an experienced, client-facing ETL Lead, you will own projects from design through production. Translate...Suggested
- ...role is responsible for designing, modeling, developing, and managing data warehouse objects in the Snowflake cloud data store, utilizing ETL pipelines (Talend, Informatica) and APIs. The ideal candidate is a self-driven, strategic thinker who thrives in collaborative...Suggested
- A data solutions provider in Toronto, Ontario is seeking a Data Dev Lead to oversee data development activities. The role focuses on hands-on work using IBM DataStage for ETL workflows, and requires proficiency in SQL Server and PL/SQL. Responsibilities include leading development...SuggestedManual labor
- A leading data solutions firm in Toronto is seeking a QA Lead to manage ETL testing across data migration and analytics projects. With over 5 years of ETL/Data QA experience, including at least 2 years in a leadership role, the ideal candidate will have strong SQL and ETL skills...Contract work
$75k - $140k per year
...Cognizant Technology Solutions Corporation in Canada is seeking an experienced ETL/ELT Engineer to design, develop, and maintain data pipelines using Informatica IICS and Snowflake. The ideal candidate will have strong SQL skills, expertise in source-to-target mappings, and...- ...transformations. Job DescriptionJob Description:Strong experience in functional and automation testing Strong knowledge of ETL testing Experience in leading a team Experience working with Data Cloud Strong expertise in SQL, Data Warehouse, and Azure Good knowledge of...
- A leading health information organization in Toronto seeks a Team Lead for Quality Assurance. This individual will oversee QA processes ensuring the delivery of high-quality applications. Responsibilities include leading a QA team, developing test strategies, and working on...
- Become a Lead ETL Developer focusing on Teradata SQL and compliant workflow documentation. Shape the future of data management by creating efficient ETL solutions alongside business needs. With a strong background of 8-10 years in ETL development and 6+ years in Enterprise...
- ...consulting firm in Mississauga is looking for a US IT Recruitment Executive with at least 5 years of experience in data integration and ETL development. The ideal candidate should possess strong skills in SQL, SSIS, SQL Server, and Python, along with familiarity in finance...Contract work
- A well-known consulting firm in Toronto is seeking a Senior Business Intelligence Specialist. The role involves developing BI solutions and supporting clients' data management needs. The ideal candidate will have 10+ years of experience, proficiency in R scripting and Power ...
- A leading insurance firm in Canada is seeking a Senior ETL Developer to join their hybrid team. The role involves building efficient data pipelines and operationalizing high-quality data solutions. Candidates should have extensive experience in data modeling, SQL, and using...
- Lead Talent Acquisition | Financial Services | Client relationsIris's client, the largest bank in Canada, is looking to hire ETL Tester/Data Tester . Please find below the job details and share your resume if interested at ****@*****.*** . Job DescriptionLocation...Long term contractFlexible hours3 days per week
- ...Kumaran, we don’t just solve problems, we engineer future-ready transformations. Job DescriptionRole OverviewWe are looking for an ETL QA Engineer with strong experience inDatabricks and PySpark, combined with hands‑on exposure to AI‑assisted development and prompt engineering...
- ...support business and technical requirements.Develop robust data models and data warehousing solutions.Develop, maintain, and optimize ETL processes using Microsoft SQL Server and SQL Server Integration Services (SSIS) .Ensure data integrity and accessibility across integrated...
- ...and government organizations. We are committed to delivering innovative technology solutions and connecting top-tier IT talent with leading organizations. Location: Downtown Toronto, ON (5 days onsite in the office) Position Type: Contract Responsibilities: Power...Contract workWork at office
- ...we’d like to hear from you! We’re looking for an Intermediate ETL Developer to join Pandell-ESG's Project Services team. You’ll help... ...the way. You’ll also have opportunities to take the technical lead on small to medium-sized projects and help other team members build...Manual laborWork at officeWork from homeFlexible hours
- 10 years of Strong experience in ETL testing. Preferred to have experience on Snowflake IDMC. Strong knowledge on SQL with enough hands on exp. Must have exp on regression Integration testing and EndEnd testing. Understand the business requirements the system needs collaborate...
- Roe : Informatica ETL Developer – PowerCenter / Data Warehousing Job Description: We are looking for an experienced Informatica ETL Developer with strong hands-on expertise in Informatica PowerCenter and Enterprise Data Warehousing to design, develop, and optimize...
- Senior Software Developer, ETL & AI Data Engineering Location: Toronto, ON (Hybrid, 3 days onsite per week, near Union Station)Language: Written and spoken language requirements to be confirmedDuration: 6-month contract, until May 31, 2027About the Opportunity...Contract work3 days per week
- Overview Our client, an innovative industry leader in the insurance domain, is looking for a Senior ETL Developer - Hybrid to join their growing team. The successful candidate will have extensive experience building reliable, scalable, and efficient data pipelines to operationalize...Permanent employmentFull timeWork at office3 days per week
- To respond to the priorities of the Government of Ontario through the passage of the Bill 5, Protect Ontario by Unleashing Our Economy Act 2025, the resource may be partially assigned to Bill 5 related projects or initiatives on an as needed basis. This position is listed...Work at officeMonday to friday
- Lead ETL testing at Tangerine using SQL, Python, and rigorous data validation across Data Warehouse environments. This senior role supports reliable data pipelines.As a Senior Quality Engineer, you will test ETL workflows, validate transformations, and reconcile source-to-target...
- Bring multi-cloud and ETL expertise to Air Canada Vacations as a Data Analyst Developer based in Montréal or Mississauga.This permanent,... ...and automating data pipelines and infrastructure. Reporting to the Lead Data Analyst Developer, you will support the Data Architect’s...Permanent employmentFull time
- ...skills A team player with a track record for meeting deadlines ETL Skills Knowledge and experience in gathering requirements and... ...) Experience with liaising with IT specialists and unit leads and working closely with support team members and relevant stakeholders...
- ...Universe and Dashboarding, WebI, Bursting technologies, and Informatica ETL. Responsibilities:This request is for strong developers to help... ...Strong analytical and problem-solving skills. Ability to mentor junior developers and lead technical discussions. #J-18808-LjbffrApprenticeship
- Develop enterprise ETL pipelines with Databricks, Azure Data Factory, and PySpark in Toronto. Transform data from diverse systems into curated downstream feeds.Apex Systems seeks a Databricks Data Engineer for a large-scale data migration and centralization initiative. The...
- Design data architecture and optimize ETL processes as a Consultant using Microsoft SQL Server and SSIS across integrated systems.This ETL Consultant develops data models, data warehousing solutions, and reliable integration processes. The work combines data engineering, process...
- You should have experience with InfoSphere on the Linux Platform administration Must have experience in DataStage and QualityStage Experience in Linux and shell scripting Strong experience in Information Services Director, Information Analyzer and PL SQL Hands on...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Etl Lead. Be the first to apply!

