Data Analyst

WPP is the trusted growth partner for the world’s leading brands. 

We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. 
 
We work with the world's most valuable brands and have global reach across 100+ markets, with deep local expertise.
 
Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow. 
 
For more information, visit WPP.com.
 

Why we're hiring:

The Data Analyst supports AUNZ reporting by maintaining ETL processes, validating data feeds, managing master data tables, and building foundational Power BI data models. The role works closely with the Head of Data & Analytics to refine requirements and ensure data feeding into reporting solutions is accurate, well-modelled, and fit for purpose.

What you'll be doing:

KRA 1 ETL & Data Management

• Support ETL processes for current and future AUNZ data feeds.
• Identify and resolve data validation concerns across data feeds.
• Create and manage master data tables.
• Filter and clean data by reviewing validation reports and performance indicators to locate and correct data process issues.

KRA 2 Power BI & Data Modelling

• Develop and maintain data models (relationships, DAX, Power Query) to support reporting built by the Business Intelligence Developer.
• Contribute to silver/gold layer modelling in Databricks in line with established patterns.

KRA 3 Requirements & Documentation

• Work with the Business Intelligence Manager to gather, refine, and document data requirements.
• Maintain documentation for assigned data models and processes, including sources, logic, and known issues.

Support data quality monitoring, escalating issues appropriately based on severity.

What you'll need:

• Strong analytical, quantitative, and problem-solving skills.
• Experience using the Databricks platform, including DLT, SQL and Python.
• Working knowledge of Power BI data modelling, DAX, and Power Query.
• Experience handling different file formats (txt, csv, etc.).
• Attention to detail and a willingness to learn new tools.
• Understanding of financial or operational data is desirable but not required.

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 open-minded: to new ideas, new partnerships, new ways of working.

You're optimistic: we approach all that we do with confidence: 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 champion a culture of people that do extraordinary work

Scale and opportunity – we offer the opportunity to create, influence and deliver 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. 

#LI-Hybrid 

We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we’ve adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process.

WPP is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

Please read our Privacy Notice (https://www.wpp.com/en/careers/wpp-privacy-policy-for-recruitment) for more information on how we process the information you provide.