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)