Junior Business Intellegence Analyst

About WPP Media

WPP is the trusted growth partner for the worlds leading brands. With exceptional talent trusted data and intelligence and world-class partnerships all united by ourpioneeringagentic marketing platform WPP Open we help clients navigate change capture opportunity and deliver transformational growth.

WPP Media is WPPs AI-driven media operating unit bringing together media data and partnerships to deliver creative personalisation at scale. Connected through WPP Open and powered by Open Intelligence clients see exactly where how and why their media investment is working.

For more information visit .

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 youll 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. Youll tackle issues that matter alongside talented colleagues who care deeply about what they do. Its 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 youwill be joining theWPP 650division of WPP Medias 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 includingAdverity GCP andPowerBI. 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 for shaping the next era of media is powered by our commitment toBe Extraordinary investing in our employees to inspire transformational creativity. We alsoLead Optimisticallyfirmly believingin andChampioning Growth and Developmentfor every individual. This commitment allows WPP Media employees toleveragethe extensive global WPP Media & WPP networks to pursue their passions build vital professional connections and learn at thecutting edgeof marketing and advertising.

WeCreate an Open environmentbuilt on trust and respect where everyone feels they belong and has opportunities to progress. This inclusive culture is fostered through a variety of employee resource groups and frequent in-office eventsshowcasingteam wins sharing thought leadership and celebrating holidays and milestone events. Our comprehensive benefits package reflects this commitment including competitive medical group retirement plans vision and dental insurance significant paid time off preferential partner discounts and employee mental health awareness days.

WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to characteristics. We believe the best work happens whenweretogether fostering creativity collaboration and connection in this open and supportive a hybrid approach with teams in the office around four days a week. If yourequireaccommodations or flexibility please discuss this with the hiring team during the interview process.

Please note this is a UK based role and requires individuals to have the right to work in this location

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

While we appreciate all applications received only those candidates selected for an interview will be contacted.

#LI-Promoted

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