EMEA Data Analyst

Location: London

*** Mention DataYoshi when applying ***

Management of data from legacy platforms to the strategic platform.

Job Title:

EMEA Data Analyst

Job Description:

This is an exciting time to join Dentsu International as we focus on fundamentally transforming our business globally, with a huge agenda spanning realignment of our go-to-market brands, our service delivery organisation, globalising our functions, and building an integrated technology capability underpinning all aspects of our business. We are well placed to build capability, scale and sustainable growth as a high-performance business.

The role

This is an exciting opportunity to join the Platform Delivery & Operational Management team on a fixed term contract, helping to migrate our German business onto the WorkDay platform.

Key responsibilities:

  • Plans, designs, and executes the extract of data from the legacy platform, the transformation of data to the new format and structure and the load of that data in to the target platform
  • Responsible for all activities leading up to transformation (Field Mapping, Value Mapping & Data Cleansing).
  • Managing and coordinating all data requests and activities
  • Managing the Data Cleansing process between Prototype Builds
  • Building the ETL Tool, including any mappings and / or validations for Prototype Builds in line the functional scope
  • Coordinating Field & Value Mapping sessions to input into the development of the ETL Tool
  • Ensure Data security / privacy compliance throughout the process.
  • Generating detailed sample data sets to fulfil E2E test scenarios
  • Loading Complex Configuration between Prototype Builds
  • Loading Employee Data for each Prototype Build - providing detailed error reports detailing data elements which require cleansing
  • Ensures all data is accounted for during the transition to the satisfaction of future audits
  • Plans the Extract / Transform/Load processes during cutover and rehearsals

Education, Work Experience, Skills

  • Previous experience Field Mapping, Value Mapping & Data Cleansing
  • Experience planning, designing, and delivering data migration across HR transformation projects
  • Experience building ETL Tools
  • Experience ensure data security and privacy compliance is adhered to throughout a data migration
  • Experience with Prototype Builds

About dentsu international

Part of dentsu, dentsu international headquartered in London operates in over 145 markets worldwide with more than 48,000 dedicated specialists. We help clients to win, keep and grow their best customers and achieve meaningful progress for their businesses. With best-in-class services and solutions in media, CXM, and creative. www.dentsu.com

Working with us

Joining dentsu international, you’ll join a team of 48,000 people. It’s an opportunity to produce career-defining work. Along the way, you’ll team up with inspiring colleagues and encounter a richness of clients, cultures and experiences. We offer exciting challenges, memorable experiences and opportunities to shape your future.

Inclusion and Diversity

We’re proud to be different and that starts with our people. We believe in equal opportunities for everyone. We won’t define people by their race, gender, sexual-orientation, age or disability. Individuality is what makes us great, we want everyone to bring their full self to work and create something amazing. That’s what we care about. So, whether you’re joining us, or looking to move to a different part of the business, we work hard to make sure we create equal opportunities for everyone.

We are happy to discuss flexible and agile approaches to working for all our roles – we can’t promise we will be able to offer you everything you want or need but we do promise to discuss it with you openly and honestly. If you have any reasonable adjustment needs arising from a disability or medical condition to fully participate in the recruitment process, please discuss this with our recruitment teams.




Dentsu Aegis Network Emea

Time Type:

Full time

Contract Type:

Fixed Term Contract (Fixed Term)

*** Mention DataYoshi when applying ***