Int. ETL Developer with Ai/ML exp to help migrate our banking client's data infrastructure from on-premises systems to AWS cloud

Int. ETL Developer with Ai/ML exp to help migrate our banking client's data infrastructure from on-premises systems to AWS cloud

Duration: 12 Months

Location: Toronto, Hybrid (2-3x/week)

Department: Risk Data Technology - Credit Risk Data Team

Reports To: Director, Risk Data Technology

Role Overview

We are seeking a Junior to Intermediate Developer to join our Credit Risk Data team during an exciting transformation period. The successful candidate will play a key role in migrating our data infrastructure from on-premises systems to AWS cloud, building modern ETL pipelines, and preparing our data architecture to support AI-driven initiatives.

Key Responsibilities

• Develop and maintain ETL processes, migrating existing SSIS packages to AWS Glue
• Build and optimize data transformation layers on AWS cloud infrastructure
• Work with Redshift and other AWS data services to create scalable data solutions
• Support the migration of legacy Netezza/on-prem data workloads to cloud-based architecture
• Write clean, well-documented code following team standards and best practices
• Collaborate within agile pods to deliver incremental value on sprint cycles
• Participate in code reviews and contribute to technical documentation
• Ensure data is structured and formatted for downstream AI/ML consumption

Must Haves:

Technical:

• 2-4 years of experience in data/ETL development
• Proficiency in SQL and relational database concepts
• Experience with SSIS (SQL Server Integration Services)
• Exposure to or working knowledge of AWS services (Glue, Redshift, S3)
• Familiarity with Java development is an asset
• Understanding of data pipeline architecture and ETL best practices

Tools & Environment:

• Jira and Kanban for agile project tracking
• Git or similar version control systems
• Data lineage tools (e.g., Manta) is an asset

Soft Skills:

• Strong documentation and communication skills
• Ability to work collaboratively in an agile team environment
• Self-motivated with a desire to learn new cloud technologies
• Attention to detail with a focus on data quality

Nice to Have

• Experience in financial services or risk data
• Exposure to AI/ML data preparation concepts
• Previous experience at BMO or similar financial institutions