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:
- Manage monthly data feeds for spend/accounts payable – data collection, follow ups, cleansing, ETL operations, quality checks etc.
- Moving existing quarterly data feeds to monthly
- Data maintenance and governance – company code master, operating Company hierarchy master etc.
- Assist in continuous improvement plan – tweaks/modifications in data templates, process optimization.
- Designing and building data workflow/pipelines.
- Identify and interpret trends/patterns in large datasets.
- Interpret stakeholder requirements, analyse data and provide outgoing reports.
- 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
- Spend data management – supplier category understanding, leveraging AI/ML output, rule building, data repository maintenance, supplier grouping, taxonomy building.
- Strong proficiency in SQL for data manipulation and analysis, Python is a plus.
- Experience of ETL tools such as Alteryx, Databricks is a plus.
- Strong fundamentals in Data Visualization and KPI generation
- Competence in MS Office – Advanced excel is a plus.
- 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.
Apply for this job
*
indicates a required field