Data Migration Architect Manager

Data Migration Architect

Data & AI | Avanade Australia

Location: Sydney, Melbourne, Brisbane or Perth (Hybrid)

About the Role

As a Data Migration Architect , you will play a critical role in delivering complex enterprise transformation programs by designing and leading end-to-end data migration solutions. You will work closely with business stakeholders, solution architects, data engineers, and delivery teams to ensure data is migrated accurately, securely, and efficiently across modern cloud and enterprise platforms.

This role requires a strong blend of technical expertise, consulting capability, stakeholder management, and hands-on experience delivering large-scale migration initiatives.

Key Responsibilities

Define and lead data migration strategies, architectures, and delivery roadmaps for enterprise transformation programs.

Conduct source system analysis, data profiling, and migration assessments to determine migration readiness and identify data quality issues.

Facilitate business and technical workshops to define migration scope, data mappings, transformation rules, validation criteria, and reconciliation requirements.

Design and oversee data extraction, transformation, and loading (ETL/ELT) frameworks to support migration activities.

Establish data governance, data quality, cleansing, and remediation processes to improve migration outcomes.

Develop and manage reconciliation frameworks, exception handling processes, and migration validation controls.

Lead migration planning, mock migrations, cutover activities, deployment execution, and post-go-live support.

Collaborate with business stakeholders, solution architects, developers, and project teams to ensure successful delivery of migration programs.

Provide leadership and guidance to data engineers and project teams throughout the migration lifecycle.

Identify and mitigate migration risks, dependencies, and issues while ensuring project milestones are achieved.

.

About You

8+ years of experience in Data & Analytics, Data Engineering, Data Migration, Data Architecture, or Solution Architecture roles.

Proven experience delivering complex enterprise data migration programs across cloud and on-premises platforms.

Strong expertise in:

Data analysis and profiling

Data migration strategy and planning

Data mapping and transformation design

Data quality assessment and remediation

Data reconciliation and validation

Data governance and master data management

Data migration testing and cutover planning

Hands-on experience with modern data platforms and technologies, including:

Microsoft Fabric

Azure Data Factory

Azure Data Lake

Azure Databricks

Azure Synapse Analytics

SQL Server

Snowflake

Other enterprise data integration and analytics platforms

Strong stakeholder engagement and consulting skills with the ability to facilitate workshops and influence decision-making.

Excellent communication skills with the ability to translate technical concepts into business outcomes.

Experience working within Agile and enterprise delivery environments.

Desirable Experience

Experience delivering Dynamics 365 (D365) data migration projects, including:

Data extraction

Data cleansing

Data mapping

Transformation design

Data validation

Migration testing

Cutover execution

Experience supporting ERP and CRM transformation programs involving:

Dynamics 365

SAP

Oracle

Salesforce

Other enterprise platforms

Microsoft Azure and/or Microsoft Fabric certifications.

Knowledge of modern data governance, data quality, and master data management frameworks.

TOGAF, DAMA/CDMP, or equivalent architecture and data management certifications.

What You'll Bring

A consulting mindset with a passion for solving complex business challenges through data.

Strong leadership skills and the ability to drive outcomes in enterprise-scale programs.

The ability to balance strategic thinking with hands-on delivery.

Experience working with cross-functional teams in fast-paced consulting environments.

A commitment to delivering high-quality, business-focused solutions that create measurable value for clients.

.