The objective of this role is to support end-to-end data migration from local China-based platforms (both SaaS and on-premise systems) into Microsoft Dynamics 365. The role will focus on understanding data lineage, designing extraction and transformation strategies, and ensuring high-quality, compliant data migration aligned with enterprise standards.
Job Description:
Key Accountabilities
-
Lead and support data migration activities from local China platforms (SaaS and on-prem) into D365
-
Analyze legacy systems to understand data structures, dependencies, and lineage
-
Design and implement data extraction and transformation approaches for structured migration
-
Perform data profiling, cleansing, validation, and reconciliation
-
Collaborate with functional, data, and integration teams to ensure accurate data mapping aligned with business processes
-
Work with databases such as SQL Server, Oracle, and other enterprise data sources
-
Support data migration testing cycles (functional and system testing) prior to UAT
-
Document data lineage, transformation logic, and migration rules
-
Identify data quality issues and implement mitigation and improvement strategies
-
Ensure adherence to data governance, compliance, and security standards
-
Provide insights and recommendations on data improvements and optimization
Professional Knowledge/Skills
-
5+ years of experience in data analysis and data migration roles
-
Strong experience in migrating data from heterogeneous systems (SaaS and on-prem)
-
Solid understanding of data lineage, data flow mapping, and transformation methodologies
-
Hands-on experience with databases such as SQL Server, Oracle, and similar platforms
-
Experience with ETL/ELT tools and data extraction frameworks
-
Understanding of D365 data structures and migration concepts (preferred)
-
Strong SQL and data querying skills
-
Knowledge of data quality, validation frameworks, and reconciliation processes
-
Experience working in cross-functional and multi-region teams
-
Fluency in Chinese (Mandarin) and English preferred
Personal attributes
-
Strong analytical mindset with attention to detail
-
High ownership of data accuracy and quality
-
Ability to work with complex and fragmented data environments
-
Strong collaboration and stakeholder communication skills
-
Proactive and solution-oriented approach
Location:
Shanghai - Haisu Plaza
Brand:
Dentsu Apac
Time Type:
Full time
Contract Type:
Fixed Term Contract (Fixed Term)
