Data Analyst

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients, and communities.

Working at WPP means being part of a global network of more than 109,000 accomplished people in 110 countries. WPP has headquarters in New York, London and Singapore and a corporate presence in major markets worldwide.

We create transformative ideas and outcomes for our clients through an integrated offer of communications, experience, commerce, and technology.

WPP and our award-winning agencies work with most of the world's biggest companies and organisations – from Ford, Unilever and P&G to Google, HSBC, and the UN. Our clients include 61 of the FTSE 100, 317 of the Fortune Global 500, all 30 of the Dow Jones 30 and 62 of the NASDAQ 100. WPP are the leader in the Bloomberg Gender Equality Index and 8th in the FTSE 100 rankings for Women on Boards.

What you'll be doing:

We are looking for a Data Analyst to support in the continued development of WPP’s client operations analytics team, using business intelligence tools and visualisations to share with WPP HQ and the wider WPP network.

Reporting into the Head of Finance Analytics, this role will work in several capacities including analysing data, creating technical solutions, assessing business issues, rolling out a software solution and building internal client relationships. In this role you will help to bring insights directly to the business, enabling senior stakeholders to make informed data driven decisions on a daily basis.

The role will be as follows:

• Run ETL (Extract, Transform & Load) process for Marketing & Growth worksteam to provide accurate reporting in a timely manner
• Work with all existing agencies data feeds to identify & resolve any validation concerns
• Support other EDG ETL process for all current & future data feeds
• Create and/or manage WPP’s master data tables
• Assist with new agency/country implementation programmes
• Filter and “clean” data by reviewing validation reports and performance indicators to locate and correct code & data process problems
• Provide ad hoc analysis to key client stakeholders

• Maintain and improve the existing workstream technical documentation.

What you'll need:

• Strong analytical, quantitative and problem-solving skills
• Experience in ETL tools like Informatica, Alteryx, KNIME etc
• Experience in handling different file formats like txt, csv etc
• Attention to detail and a willingness to learn new tools
• Competence in new data connections set up (incl. API)
• Competence in Tableau/PowerBI is an advantage
• Proactive attitude and desire to drive continuous improvements

Who you'll be working with:

You’ll be working closely with all of the Data & Insights team which currently consists of 13 people (8 based in UK, 2 based in Madrid & 3 based in India) who are nice group of individuals and are a close working team that all get on well, and who are looking forward to what this team could achieve in the future.

You will also be working closely with the Data Manager, Head of Finance Analytics, Marketing & Growth Operations Team and other stakeholders from WPP Operating Companies.

We've adopted a hybrid working approach to give more flexibility on where and how we work. Normally we work together in our amazing office twice a week.

This role reports to the Head of Finance Analytics within the Enterprise Data Group team.

WPP is an equal opportunity employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability. We believe in creating a dynamic work environment that values diversity and inclusion and strives to recruit a diverse slate of candidates to help us achieve that goal.

Please read our Privacy Notice for more information on how we process the information you provide.