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 115,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, 307 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 20th in the FTSE 100 rankings for Women on Boards.

Why we’re hiring:

• The primary focus of the data analyst is to support the data and insights team with the continued development of WPP’s spend analysis data structure, business intelligence tools and visualisations for WPP HQ and the wider WPP network.  
• The role offers the successful candidate the opportunity to work with stakeholders across several departments developing our team’s analysis and reporting capabilities via our spend analysis tool. 

What you’ll be doing:

• Interpret stakeholder reporting requirements, analyse data and provide outgoing reports 
• Identify and interpret trends/patterns in large datasets 
• Develop and maintain robust data pipelines using Python, SQL 
• Utilize Azure native services, including but not limited to Azure Data Factory, Azure SQL Database, and Azure Databricks, to build and optimize data workflows 
• Filter and “clean” data by reviewing validation reports and performance indicators to locate and correct code & data process problems 
• Produce and track key performance indicators  
• Contribute to the ongoing development of the spend analysis tool’s reporting capabilities 
• Assist with system administration and issue resolution 
• Document end to end reporting process
• Be available to train and support end users on the use of the WPP spend analysis tool
• Assist with communications process with different business levels internally 
• Be prepared to work on other complimentary spend reporting projects  
• Assist in opportunity analysis through further data investigation 

What you’ll need:

• Strong analytical, quantitative, and problem-solving skills 
• Strong proficiency in Python and SQL for data manipulation and analysis 
• Hands-on experience with Azure native services, particularly Azure Data Factory, Azure SQL Database (Synapse), and Databricks 
• Experience of ETL such as Alteryx tools a plus 
• Competence in MS Office 
• Willingness to learn new tools and systems 
• Technology experience or interest 
• Good attention to detail 
• Good organisational skills 
• Excellent verbal, written and interpersonal skills  
• Comfortable in dealing with all levels of company executives  
• Team player but also able to determine workload and be self-motivated 
• General enthusiasm for growth and a willingness to be hands on 

Who you are:

You’re open: We are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are accepting: of new ideas, new partnerships, new ways of working.

You’re optimistic: We believe in the power of creativity, technology and talent to create brighter futures or our people, our clients and our communities. We approach all that we do with conviction: to try the new and to seek the unexpected.

You’re extraordinary: we are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.

What we’ll give you:

Passionate, inspired people – We promote a culture of people that do extraordinary work.

Scale and opportunity – We offer the opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.

Challenging and stimulating work – Unique work and the opportunity to join a group of creative problem solvers. Are you up for the challenge?

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 (https://www.wpp.com/people/wpp-privacy-policy-for-recruitment) for more information on how we process the information you provide.