Lead data migration from SQL-based systems into Microsoft Dataverse. Hands-on experience with SQL, Azure Data Factory, Fabric and Dynamics 365. Build reliable migration pipelines, data validation and reconciliation processes.

We are partnering with a Queensland Government agency, seeking an experienced Senior Data Migration Engineer to join a major digital transformation project, helping deliver a contemporary enterprise platform and migrate complex legacy data into Microsoft Dataverse.

Working within an Agile delivery team, you’ll be responsible for designing, building, testing and executing repeatable data migration processes from SQL-based source systems into Microsoft Dataverse. You’ll work closely with architects, developers, testers and business stakeholders to ensure data is migrated accurately, securely and reliably.
This is a hands-on engineering role suited to someone with strong SQL skills, proven enterprise data migration experience and a solid understanding of the Microsoft cloud and Power Platform ecosystem.

Contract Details

- Contract: Initial engagement through to October 2027, with a potential six-month extension.
- Start date: ASAP.
- Location: Brisbane CBD, 1-2 days per week in the office

Key Responsibilities

- Design, build and maintain repeatable data migration pipelines, scripts, dataflows and load processes.
- Extract, profile, cleanse, transform and migrate data from SQL-based source systems into Microsoft Dataverse.
- Implement source-to-target mappings, validation rules, reconciliation checks and exception reporting.
- Manage Dataverse-specific migration complexities, including relationships, lookups, alternate keys, ownership and data dependencies.
- Execute test migrations, mock loads, performance tuning, defect resolution and production cutover activities.
- Develop automated processes with appropriate logging, error handling, retry logic and audit trails.
- Collaborate with technical and business stakeholders to validate data quality,



resolve issues and confirm migration readiness.
- Contribute to migration documentation, technical standards, runbooks and operational handover.

Skills and ExperienceTo be successful in this role, you will have:

- Significant experience delivering complex data migrations in enterprise environments.
- Proven experience migrating data into Microsoft Dataverse, Dynamics 365, Power Platform or comparable enterprise SaaS platforms .
- Strong SQL skills across data profiling, extraction, transformation, validation, reconciliation and troubleshooting.
- A solid understanding of Dataverse data structures, relationships, lookups, alternate keys, security and data loading dependencies.
- Hands-on experience with Microsoft data and cloud technologies such as Azure Data Factory, Microsoft Fabric, Power Platform dataflows, Power Query and Azure SQL .
- Experience with migration tools such as KingswaySoft, SSIS, XrmToolBox, Configuration Migration Tool or equivalent.
- Experience building automated, repeatable and auditable migration processes.
- Familiarity with Azure DevOps or equivalent tools for source control, backlog management, defect tracking and deployment.
- Strong problem-solving, communication and stakeholder engagement skills.
- Experience working in Agile delivery environments and supporting multiple migration and testing cycles.
- Ability to design, implement, and maintain data models to support business intelligence and reporting.

Desirable ExperienceThe following experience will be highly regarded:

- Appian-based SQL databases, case management systems or workflow data migration.
- Microsoft Fabric lakehouses, warehouses,



pipelines, notebooks or Dataflow Gen2.
- Migration of documents, attachments, notes, activity history and complex relationship structures.
- Data governance, lineage, privacy, records management and migration audit requirements.
- Relevant Microsoft Fabric, Azure Data Engineering, SQL, Dynamics 365 or Power Platform certifications.

Interested?If you have hands-on experience delivering complex data migrations into Microsoft Dataverse or Dynamics 365 and enjoy solving challenging data engineering problems, we’d like to hear from you.
Email View email address on redirect.jobsurf.com.au quote REF#250634 for a confidential conversation

Diversity, Equity & Inclusion at Hudson
Hudson is committed to helping you find a workplace where you feel respected, supported, and free to thrive. We welcome applications from all backgrounds, identities, and lived experiences—because when different voices come together, amazing things happen.

Casual Loading
Please note for all Australian based contract and temporary roles only, the pay rate is inclusive of mandatory 25% casual loading. This excludes permanent and fixed term roles.

Due to current Victorian labour hire licence restrictions, Hudson is not advertising, offering or accepting applications for contract, temporary or labour hire roles that are based in Victoria or otherwise connected to Victoria. This includes contract, temporary or labour hire roles where the candidate resides in Victoria, even if the role is based in another state. These restrictions do not apply to permanent or fixed term employment opportunities.

Consultant

View email address on redirect.jobsurf.com.au

Reference number: 250634
Profession:IT, Technology & DigitalData Analysts

IT, Technology & DigitalEngineering - Cloud

IT, Technology & DigitalEngineering - Dev Ops

IT, Technology & DigitalEngineering - System

Company: Hudson
Date posted: 20th Oct, 2026

📌 Senior Data Migration Engineer New (Brisbane)
🏢 Hudson
📍 Brisbane