Data Analyst
On-siteShanghai, Shanghai, China
Job Summary
Lead and support data migration activities from local China platforms (SaaS and on-prem) into Microsoft Dynamics 365. Analyze legacy systems to understand data structures, dependencies, and lineage, then design and implement extraction and transformation approaches for structured migration. Perform data profiling, cleansing, validation, and reconciliation while collaborating with functional, data, and integration teams to ensure accurate data mapping aligned with business processes. Support data migration testing cycles prior to UAT, document transformation logic and migration rules, and identify data quality issues to implement mitigation strategies. Ensure adherence to data governance, compliance, and security standards while providing insights on data improvements and optimization. Requires 5+ years in data analysis and migration, strong SQL skills, and fluency in Chinese and English. Located in Shanghai, this fixed-term role is with Dentsu Apac.
Required Qualifications
- 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
- 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
Desired Qualifications
- Understanding of D365 data structures and migration concepts (preferred)
Hiring someone like this?
Get your role in front of qualified candidates on Sorce.