About this role
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)