Senior Data Migration Engineer: Dataverse & Cloud Pipelines

Troocoo Pty; Brisbane; On-site; AUD 130,000 - 190,000; Full time

Job summary

Troocoo Pty is seeking two Senior Data Migration Engineers to design, build and support repeatable data migration processes from Appian-based SQL sources into Microsoft Dataverse within a Queensland Government technology transformation project.

You will work with architects, developers, testers and business stakeholders to deliver auditable migration pipelines and reliable data flows that enable a modern, cloud-based platform and improved services.

Qualifications

• Proven experience migrating data into Microsoft Dataverse, Dynamics 365 or Power Platform.
• Strong SQL skills for data analysis, extraction, transformation, validation and reconciliation.
• Experience with Microsoft cloud data tooling (Azure Data Factory, Fabric, Power Platform dataflows).

Responsibilities

• Design and build repeatable data migration pipelines, scripts, dataflows and loading processes.
• Analyse SQL source systems, profile data and implement source-to-target mappings and transformation rules.
• Migrate data into Microsoft Dataverse, managing relationships and platform-specific requirements.
• Develop data validation, reconciliation, exception reporting and data quality checks.
• Support test migrations, mock loads, defect resolution, production cutover and post-migration validation.
• Apply automation, logging, error handling and retry logic to improve migration reliability and traceability.
• Work within an Agile delivery team, collaborating with technical and business stakeholders to resolve issues and maintain delivery quality.

Skills

Microsoft Dataverse

SQL

Azure Data Factory

Power Platform dataflows

SSIS

KingswaySoft

Azure SQL

Agile

Data migration

Data validation

Tools

SSIS Integration Toolkit

XrmToolBox

KingswaySoft

Job description

Troocoo Pty is seeking two Senior Data Migration Engineers to design, build and support repeatable data migration processes from Appian-based SQL sources into Microsoft Dataverse within a Queensland Government technology transformation project.

You will work with architects, developers, testers and business stakeholders to deliver auditable migration pipelines and reliable data flows that enable a modern, cloud-based platform and improved services.