Overview
The Data Analyst for the Dynamics 365 ERP Migration will be crucial in leading the data migration efforts from a legacy AS400 system to Microsoft Dynamics 365 Finance & SCM. This role requires collaboration with business and technical stakeholders to ensure accurate data extraction, cleansing, and transformation, thereby preparing data for a successful migration process while addressing data quality issues along the way.
Responsibilities
- Analyze and understand data held within the existing AS400 ERP environment.
- Extract, cleanse, map, and transform legacy data ready for Dynamics 365.
- Use SQL and ETL techniques to manipulate and prepare large datasets.
- Identify data quality issues, inconsistencies, and gaps ahead of migration.
- Work with business and technical stakeholders to define mapping and transformation requirements.
- Support migration testing, reconciliation, and validation to ensure data is complete and accurate.
- Help establish repeatable migration processes ahead of the D365 implementation.
Requirements
- Strong expertise in SQL and ETL/data transformation techniques.
- Experience in ERP or large-scale systems migration programmes.
- Familiarity with AS400/IBM i data is highly desirable.
- Previous exposure to Dynamics 365 ERP migrations is advantageous.
- Proven ability to work with complex legacy datasets.
- Strong analytical skills for data quality assessment and transformation.
- Hands-on experience in data cleansing and preparation for migration.