Data Analyst

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)