Data Analyst

Dentsu Aegis Network • Chinese: C1 • SQL • ETL/ELT • 2 months ago
Apply now
Save
372,576open jobs
9,648companies
49,982added this week
Browse all
Location
In office (Shanghai)
Seniority
Senior · 5+ years exp
Employment
Full-Time
Overview
Company
Impact
Profile match

Dentsu Aegis Network

Dentsu Aegis Network (rebranded globally as dentsu) is a major multinational media and digital marketing communications network specializing in advertising, brand strategy, and business transformation. The organization provides integrated solutions spanning creative storytelling, data analytics, media planning, and customer experience management for leading global brands.
dentsu.com • HQ: Tokyo, Japan • Media & Entertainment • Sales & Marketing • Advertising • 501-1000 employees
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)
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
372,576 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Similar stack
Same company
Shanghai
≈ $28k – $81k per year (Estimated) • In office • Full-Time • Madrid
Python
SQL
DevOps
Git
Analytics
ETL/ELT
Power BI
Apply
$108k – $195k per year • In office • Full-Time • 5+ years exp • Master's Degree • Ashburn
SQL
Databases
Azure SQL Database
Oracle
PostgreSQL
DevOps
AWS
Azure
Analytics
ETL/ELT
Power BI
Tableau
Apply
≈ $86k – $207k per year (Estimated) • In office • Full-Time • Canberra
SQL
Databases
Amazon Redshift
Apache Kafka
Databricks
Delta Lake
Google BigQuery
Microsoft Fabric
Snowflake
AI/ML
dbt
DevOps
AWS
Azure
CI/CD
Analytics
ETL/ELT
Apply
≈ $82k – $215k per year (Estimated) • In office • 10+ years exp • Sydney
Node JS
Python
SQL
TypeScript
JavaScript
Frontend
Angular
Vue.js
Mobile
Clean Architecture
DevOps
AWS
CI/CD
Apply
≈ $37k – $83k per year (Estimated) • In office • Full-Time • Bristol
Python
SQL
Analytics
Power BI
Tableau
Apply
Senior Manager 2 days ago
In office • Full-Time • 14+ years exp • Bachelor's Degree • Mumbai
JavaScript
Node JS
Perl
Java
Java
Hibernate
Spring Boot
Databases
MySQL
Frontend
Vue.js
DevOps
AWS
Azure
CI/CD
Docker
GCP
Git
Kubernetes
Apply
Remote/Hybrid • Full-Time • Rotterdam
JavaScript
SQL
Mobile
Braze
Marketing
Salesforce
Apply
≈ $45k – $89k per year (Estimated) • In office • Full-Time • 1+ year exp • Bachelor's Degree • New York
AI/ML
ChatGPT
Claude
Apply
≈ $14k – $35k per year (Estimated) • In office • Full-Time • 2+ years exp • Bachelor's Degree • Makati
Analytics
Power BI
Tableau
Marketing
Amplitude
Apply
Remote/Hybrid • Full-Time • 3+ years exp • Belgrade • Prague • Brno
Python
Analytics
Power BI
Tableau
SpaceTech
QGIS
Apply
In office • Full-Time • Shanghai • Guangzhou • Shenzhen • Dalian • Chengdu
Apply
In office • Full-Time • 7+ years exp • Shanghai
Marketing
Salesforce
Apply
In office • Full-Time • 8+ years exp • Shanghai • Guangzhou • Shenzhen • Dalian • Chengdu
Apply
In office • Internship • 5+ years exp • Bachelor's Degree • Shanghai
C++
Java
Kotlin
Python
Ruby
AI/ML
NLP
Cybersecurity
GDPR
Apply
In office • Full-Time • Shanghai
Apply
See all jobs
This is one of many
372,576 more open roles from verified company boards, updated every day.
Browse all jobs Get matched roles