Lead Data Engineer

About the role

Application Deadline:

08/20/2026 Address:

4100 Gordon Baker Road Job Family Group:

Data Analytics \& Reporting We are seeking a **Lead Data Engineer** with strong **ETL and Application** expertise to lead the enhancement of existing ETL applications and design modern **ETL/ELT pipelines** as part of application redesign and migration to AWS. This role requires hands\-on technical leadership, strong data engineering fundamentals, experience in **Agile delivery models** , proficiency with **Jira** for planning, tracking, and execution with the ability to guide teams through cloud\-based data transformations while ensuring stability of current platforms.

**Key Responsibilities**

**ETL Application Ownership \& Enhancement**

* Lead the **support, enhancement, and optimization of existing Ab Initio ETL applications** * Analyze current ETL frameworks and recommend performance, scalability, and reliability improvements * Ensure adherence to enterprise data engineering standards, coding best practices, and governance * Drive defect resolution, root cause analysis, and proactive optimization

**AWS Data Platform Design \& Modernization**

* Architect and design **ETL/ELT pipelines in AWS** for redesigning existing on‑prem or legacy ETL applications * Lead migration and modernization initiatives from Ab Initio/on‑prem platforms to **AWS\-native solutions** * Design scalable data ingestion, transformation, and orchestration patterns using AWS services * Evaluate and implement cost‑effective, performant cloud solutions aligned with business needs

**Agile Delivery \& Team Leadership**

* Work in an **Agile/Scrum or SAFe environment** , actively participating in sprint planning, backlog grooming, daily stand‑ups, sprint reviews, and retrospectives * Collaborate with **Product Owners, Scrum Masters, Architects, QA, and DevOps teams** * Break down complex data engineering work into **Jira epics, stories, and tasks** * Provide accurate estimations, track progress, and manage dependencies using **Jira** * Mentor and guide junior engineers, ensuring high\-quality and timely delivery

**Required Skills \& Qualifications**

**Experience \& Education**

---------------------------

* **Typically between 5–7 years of relevant experience** in data engineering, ETL development, and/or data platform design * **Post‑secondary degree** in Computer Science, Engineering, Information Technology, or a related field of study, **or an equivalent combination of education and experience** **Core Technical Skills**

* **Strong hands\-on experience with Ab Initio**

+ GDE, metadata management + Graph performance tuning and complex data transformations * **AWS Data Engineering Expertise**

+ Services such as S3, Glue, Redshift, Lambda + Experience designing **ETL/ELT architectures** in cloud * Strong SQL and data modeling skills (dimensional \& analytical models) * Experience with large\-scale batch data processing and data warehousing

**Engineering \& Delivery**

* Strong experience with **data pipeline orchestration and scheduling** * CI/CD knowledge (Ansible, Artifactory, GitHub Actions, or similar) * Familiarity with data quality, reconciliation, and controls * Solid understanding of security, IAM, and data governance in AWS

**Soft Skills**

* Proven **technical leadership** and mentoring capabilities * Strong analytical and problem‑solving skills * Excellent communication skills with both technical and non‑technical stakeholders * Ability to manage multiple priorities in a fast‑paced environment

**Nice to Have**

* Experience with **Business Intelligence tools like Business Objects, PowerBI, Axiom** * Experience in **financial services, regulatory, or risk data platforms** * Experience with modernization or sunset of legacy ETL platforms

**Salary** **:**

$75,900\.00 \- $141,900\.00 **Pay Type:**

Salaried The above represents BMO Financial Group’s pay range and type.

Salaries will vary based on factors such as location, skills, experience, education, and qualifications for the role, and may include a commission structure. Salaries for part\-time roles will be pro\-rated based on number of hours regularly worked. For commission roles, the salary listed above represents BMO Financial Group’s expected target for the first year in this position.

BMO Financial Group’s total compensation package will vary based on the pay type of the position and may include performance\-based incentives, discretionary bonuses, as well as other perks and rewards. BMO also offers health insurance, tuition reimbursement, accident and life insurance, and retirement savings plans. To view more details of our benefits, please visit: https://jobs.bmo.com/global/en/Total\-Rewards

**About Us**

At BMO we are driven by a shared Purpose: Boldly Grow the Good in business and life. It calls on us to create lasting, positive change for our customers, our communities and our people. By working together, innovating and pushing boundaries, we transform lives and businesses, and power economic growth around the world.

As a member of the BMO team you are valued, respected and heard, and you have more ways to grow and make an impact. We strive to help you make an impact from day one – for yourself and our customers. We’ll support you with the tools and resources you need to reach new milestones, as you help our customers reach theirs. From in\-depth training and coaching, to manager support and network\-building opportunities, we’ll help you gain valuable experience, and broaden your skillset.

To find out more visit us at https://jobs.bmo.com/ca/en .

BMO is committed to an inclusive, equitable and accessible workplace. By learning from each other’s differences, we gain strength through our people and our perspectives. Accommodations are available on request for candidates taking part in all aspects of the selection process. To request accommodation, please contact your recruiter.

Note to Recruiters: BMO does not accept unsolicited resumes from any source other than directly from a candidate. Any unsolicited resumes sent to BMO, directly or indirectly, will be considered BMO property. BMO will not pay a fee for any placement resulting from the receipt of an unsolicited resume. A recruiting agency must first have a valid, written and fully executed agency agreement contract for service to submit resumes.