Dentsu

Discussion

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)
Show