What are the responsibilities and job description for the Data Analyst position at dentsuaegis?
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) Can’t find a suitable job? Sign up for job alerts tailored to your interests and be first in line for new opportunities. About dentsu For over 120 years, innovation has been a core tenet of our offering – exploring new ways to reach, engage and nurture relationships with audiences. Together we drive a multiplier effect for clients at a global scale, through the development of Integrated Growth Solutions that are underpinned by our promise to clients: innovating to impact. Be a force for good. Sustainability is a vital part of our business and an important area of focus for our clients. We’re leading the way – helping to build a more sustainable planet. Dream loud. In this moment of transformation, we need our people to be fearless, embracing change and ambiguity, driven by the love for their work and excitement for the future. Team without limits. We create opportunities for connection and collaboration between our colleagues and clients, building a sense of belonging and having some fun along the way. Find out more about us Who we are Our Social Impact Our work