ERP Data Migration Analyst - London - £65k

The Opportunity

A well-established UK organisation is embarking on a major enterprise transformation programme, replacing several legacy systems with a modern Microsoft-based ERP platform. This multi-year initiative will transform finance, operational and property-related processes across the business.

As part of this programme, we are seeking a Data Migration Analyst to support the preparation, cleansing, validation and migration of business-critical data into a new Dynamics 365 environment.

This is an excellent opportunity to join a high-profile transformation project and play a key role in ensuring data quality and successful system adoption.

Key Responsibilities

• Analyse, extract and assess data from legacy systems and business-owned spreadsheets.
• Cleanse, standardise and enrich data to ensure readiness for migration.
• Support the creation of source-to-target mappings and transformation rules.
• Maintain migration templates, load files and supporting documentation.
• Perform data validation, reconciliation and issue investigation activities.
• Support migration cycles across test, training and production environments.
• Assist with user testing activities by investigating and resolving data-related queries.
• Produce data quality reports, reconciliation outputs and audit documentation.
• Work closely with business stakeholders, project teams and implementation partners.
• Support cutover, go-live and post-implementation activities

Essential Experience

• Previous experience supporting ERP, finance system or business transformation programmes.
• Hands-on experience with data migration, data cleansing or data quality initiatives.
• Advanced Microsoft Excel skills, including Pivot Tables, XLOOKUP and Power Query.
• Experience working with large, complex datasets.
• Strong analytical and problem-solving skills.
• Experience reconciling data and investigating discrepancies.
• Excellent communication and stakeholder management capabilities.

Desirable Experience

• Microsoft Dynamics 365 Finance & Operations experience.
• ERP implementation or migration project experience.
• Experience with ETL tools such as KingswaySoft or SSIS.
• Knowledge of D365 Data Management Framework (DMF).
• Experience within property, real estate, finance or accounting sectors.
• Familiarity with Azure-based data or integration technologies.

Please apply for further information regarding the organisation, project scope and package details. Please email me at