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
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
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
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.
We are committed to hiring military and Veteran spouses and encourage you to identify your connection with the MSEN when reaching out to us or applying to any of our open roles.
Have questions or want to learn more about us? We would love to hear from you!
Whenever possible, reach out to a named contact rather than a general inbox - it helps ensure a quicker, more personalized response. If you hit a bounce-back, let us know at
We’re proud to be the official bank of the Canadian Defence Community – and that goes beyond supporting your financial well-being. We value the skills you’ve earned in the military, and we’re here to help as you move into the next stage of your professional life.
BMO is a top ten North American bank that provides personal and commercial banking, global markets and investment banking services to 13 million customers and clients. Founded in 1817, we’re driven by our Purpose: Boldly Grow the Good in business and life. BMO has established itself as a destination for top talent, with an employee experience that’s built on personalized career development opportunities, a performance-driven winning culture, competitive rewards and benefits, and a deepcommitment to the health and well-being of our people.
If you’re ambitious, curious, creative, and eager to make an impact, you should consider BMO as a place to build your career.
#ProudtoWork@BMO