Azure Data Integration & Migration Lead

RSM Canada; Toronto; On-site; CAD 88,000 - 162,000; Full time

Job summary

RSM Canada is seeking a strategic Data Integration & Migration Supervisor to lead end-to-end data integration and migration engagements across ERP, CRM, and other business applications. You will oversee data extraction, transformation, loading, validation, and cutover planning while mentoring a team of professionals.

The role blends technical delivery with client engagement, driving best practices in data quality, security, and scalable architectures within on-premise and cloud environments,

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field.
• 5+ years of experience in data integration and data migration roles supporting enterprise business applications.
• Demonstrated experience leading data migration or integration workstreams on complex implementations, upgrades, or system consolidations.
• Strong hands-on understanding of ETL/ELT concepts, data modeling, and integration architectures.
• Experience working with cloud platforms (Azure preferred) and enterprise integration tools.
• Proven leadership experience managing teams or workstreams in a consulting or delivery environment.
• Familiarity with DevOps practices, version control, and structured delivery methodologies.
• Strong communication skills with the ability to engage both technical and business stakeholders.
• Ability and willingness to travel to client locations throughout Canada and the United States, based on project needs.

Responsibilities

• Lead and manage data integration and migration engagements for enterprise clients, spanning ERP, CRM, and other business applications.
• Oversee end-to-end data migration workstreams including data extraction, transformation, loading, validation, reconciliation, testing, and cutover planning.
• Supervise and mentor a team of data integration and migration professionals, providing delivery oversight, technical guidance, and career development.
• Collaborate with client business, data, technical, and project management teams to define scope, assumptions, dependencies, timelines, and delivery approaches.
• Define and enforce best practices for data migration methodology, integration patterns, data quality, security, scalability, and performance.
• Lead data mapping, transformation rule definition, reference data management, and data lineage documentation across source and target systems.
• Partner with solution architects and engineers to design and implement integration solutions using cloud, hybrid, and iPaaS architectures.
• Manage project execution including resource planning, risk management, issue resolution, and stakeholder communication.
• Support pre-sales activities by contributing to solution design, estimates, proposals, and client presentations.
• Drive continuous improvement through reusable frameworks, tooling, documentation, and team enablement.

Skills

Data integration

Data migration

ETL/ELT

Azure cloud

Leadership

Stakeholder comms

DevOps practices

Data modeling

Project management

Travel willingness

Education

Bachelor/Master degree

Tools

Azure Integration Services

Boomi

Informatica

MuleSoft

Job description

RSM Canada is seeking a strategic Data Integration & Migration Supervisor to lead end-to-end data integration and migration engagements across ERP, CRM, and other business applications. You will oversee data extraction, transformation, loading, validation, and cutover planning while mentoring a team of professionals.

The role blends technical delivery with client engagement, driving best practices in data quality, security, and scalable architectures within on-premise and cloud environments,