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 - $140k 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
- 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
- Astra-North Infoteck Inc. seeks a senior data engineer to design and develop scalable ETL/ELT processes, and to optimize loading and transformation for efficiency. You will collaborate with stakeholders to model data warehouses and build dashboards using Tableau. The role requires...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...
$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...- ...in the Greater Toronto Area, seeks a Manager, Data Integration to lead a 6+-person team delivering end-to-end integration solutions. You... ...Engineering, and Customer Success to meet client needs. You will oversee ETL delivery, data modeling, and post-go-live maintenance, with a...
- ...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...
- CIBC is seeking a Sr. Consultant, Data Developer to lead end-to-end data solutions for CAM, spanning ETL, ODS, and large migrations in a Azure-centric SaaS/PaaS ecosystem. You will set technical direction, own data layer design, and partner with architecture and vendors. You...Remote work
- ...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...
- ...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
- ...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...
- 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...
- 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
- 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
- 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...
- RQ09230 - Software Developer - ETL - Senior About the job RQ09230 - Software Developer - ETL - Senior DescriptionA Note on Assignment... ...or other ETL tools.5+ years of experience working on, preferably leading, testing teams and efforts.In-depth knowledge of integration...Contract workWork at officeMonday to friday
- À Montréal, Avanquest recherche un ingénieur ETL maîtrisant Databricks, Python et SQL pour développer des pipelines de données fiables. Le poste s’exerce selon un mode hybride flexible, avec télétravail possible depuis l’étranger.Vous prendrez en charge l’ingestion, le nettoyage...Remote workFlexible hours
$100 per hour
SENIOR SOFTWARE DEVELOPER/ETL (Azure & Python; Enterprise AI & Data Centre of Excellence)Requisition #: R26-3629 (RQ00241) Location: Hybrid (3 days onsite / 2 days WFH; Toronto, ON - *See WorkModel) Engagement Type: Contract Number of Resources required...Hourly payContract workFor contractorsWork at office- We're Hiring | Senior Snowflake ETL Developer Locations: Kansas, USA | Calgary, Canada (Onsite) Contract: Long term Experience: 12+ Years | Minimum 6+ Years in Snowflake We are looking for a hands-on Senior Snowflake ETL Developer to build and optimize...Long term contractContract work
- 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...
- ...Python2+ years of non-internship professional software development experienceThis position involves working with data warehousing and ETL processes, which aligns with your expertise. It's a chance to further develop your skills and contribute to exciting projects. Given that...Internship
- ...RQ08100: Software Developer - ETLGeneral ResponsibilitiesThis role is responsible for designing, developing, maintaining, and optimizing ETL (Extract, Transform, Load) processes in Databricks for data warehousing, data lakes, and analytics. The developer will work closely...Work at office3 days per week
- Build Azure ETL solutions as a Senior Software Developer, using Azure Data Factory and Informatica in a hybrid office schedule. Integrate data across complex environments.This senior developer designs, implements, and supports data pipelines throughout the software development...Work at office
- ...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...
- RQ09315 - Software Developer - ETL - SeniorAbout the job RQ09315 - Software Developer - ETL - SeniorNOTE Assignment Type: This position... ...Azure platform and Databricks. Under the supervision of the IT QA Lead, you will collaborate closely with data engineers and DevOps teams...Contract workInternship3 days per week
- Lead ETL requirements and data analysis for TCS Financial Services initiatives, applying SQL, Python or PySpark, and stakeholder management skills.This senior Business Systems Analyst supports Data, Analytics, and Machine Learning initiatives within Financial Services. The work...
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Etl Lead. Be the first to apply!

