Junior Business Intellegence Analyst

1479 - Senior Associate, BI

Role Summary and Impact

Join an award-winning team at the heart of UK government, where your work will genuinely shape lives. As part of WPP 650 you’ll be part of a supportive, collaborative environment that values curiosity, kindness, and growth. Together, we use behaviour change principles to design smarter services, influence better decisions, and help millions of people across the country.

Named WPP 650, after the 650 UK parliamentary constituencies, the name is a reminder that our work must reflect the full breadth of the country, every community, every audience. No two days are the same. The challenges are complex, the problems worth solving, and the learning constant. You’ll tackle issues that matter, alongside talented colleagues who care deeply about what they do. It’s demanding – but always rewarding.

This is meaningful work with real-world impact – the kind you can point to with pride.  

As a Senior Associate, Business Intelligence you will be joining the WPP 650 division of WPP Media’s Data, Technology and Analytics team.

You will work extensively with the Measure data platform – a unified system for data connection, ingestion, transformation, and reporting – built on a robust technology stack including Adverity, GCP, and PowerBI. This role involves actively contributing to client projects that aggregate diverse data sources into a single, unified view, ensuring data integrity and consistency to enable comprehensive insights and custom visualisations. You will have a particular focus on understanding the specific and nuanced requirements of our clients and developing visualisations to deliver on them.

Skills and Experience

Key Responsibilities

• Contribute to the development of bespoke data solutions within the BI team, ensuring the highest standards in business intelligence and data visualisation delivery.
• Collaborate effectively with planning teams to translate business specifications into precise technical requirements for implementation.
• Ensure data integrity and consistency by developing and executing queries and validating the accuracy and completeness of data.
• Develop, and maintain robust dashboarding solutions using Power BI, including troubleshooting and optimizing performance.
• Develop and maintain an expert understanding of digital advertising and ad serving technology (e.g., ad serving, vendor ad servers, web analytics, attribution).

Essential:

• Experience of bringing disparate datasets together in data visualisations
• Experience working with Power BI
• Understanding of data modelling and data integrity challenges, best practices to address them

Desirable:

• Cloud platform knowledge: GCP (preferred), other cloud platform knowledge would be considered
• Experience using SQL to analyse and transform data
• Experience working with digital marketing and/or web analytics data.
• Experience with DBT
• Experiencing working with tools such as Jira or Confluence
• Has worked in a technical team that use Agile, Scrum methodologies
• Experience of DevOps tools: Github/Gitlab

Life at WPP Media & Benefits

Our passion fo