Business Intelligence Analyst

Location: London, United Kingdom

Department: Technology & Data

1632 - Business Intelligence Analyst - DTA

About WPP Media

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities. For more information, visit wpp.com.

WPP Media is WPP’s global media collective. In a world where media is everywhere and in everything, we bring the best platform, people, and partners together to create limitless opportunities for growth. For more information, visit wppmedia.com

About Choreograph: A Leading WPP Media Brand

Choreograph is WPP’s global data products and technology company. We’re on a mission to transform marketing by building the fastest, most connected data platform that bridges marketing strategy to scaled activation.

We work with agencies and clients to transform the value of data by bringing together technology, data and analytics capabilities. We deliver this through the Open Media Studio, an AI-enabled media and data platform for the next era of advertising.

We’re endlessly curious. Our team of thinkers, builders, creators and problem solvers are over 1,000 strong, across 20 markets around the world.

Role Summary and Impact

As a specialist within the BI & Data Viz team, you will assist in the development and automation of data solutions for clients, specifically leveraging the Measure data platform, a single data connection, ingestion, transformation reporting system. This is a hands-on role where you will be responsible for helping to deliver various client projects that aggregate diverse data sources into a single, unified view which are delivered in custom visualisations.

The marketing industry often grapples with incomplete, inconsistent, and siloed data, with access primarily through APIs and FTPs. It is therefore our responsibility to help clients, both internal and external, who each have their own unique requirements for reporting and analysis. The Measure framework built on a robust technology stack based on Adverity, GCP and PowerBI, ensures we can adapt quickly to differing client needs and provide comprehensive insights.

We are seeking a creative, experienced, and motivated individual to help in the development of cutting-edge dashboards and solutions that are fit for purpose and utilise the latest technologies.

In this role you will:

• Contribute to the development of bespoke data solutions within the BI team, ensuring the highest standards in business intelligence and data visualisation delivery.
• Champion data engineering and BI excellence by translating complex data opportunities into clear business value, actively increasing revenue through BI product adoption, and continuously integrating new trends and technologies to deliver cutting-edge solutions
• Collaborate effectively with planning teams to translate business specifications into precise technical requirements for implementation.
• Design innovative data solutions and develop compelling proposals, presenting these effectively to clients and for new business opportunities.
• 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.
• Maintain an expert understanding of digital advertising and ad serving technology (e.g., ad serving, vendor ad servers, web analytics, attribution), pursuing advanced accreditation where relevant.

Skills and Experience

At WPP Media, we believe in the power of our culture and our people. It’s what elevates us to deliver exceptional experiences for both our clients and each other. In this role it will be critical to embrace WPP & WPP Media’s shared core values:

Essential

• Experience working with dashboarding tools (PowerBi preferred)
• Cloud platform knowledge: GCP (Certification advantageous), other cloud platform knowledge would be considered
• Experience using SQL
• Experience working with digital marketing and/or web analytics data.

Desirable:

• Experience with DBT
• Experiencing working with tools such as: Jira, 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 includes investing in our employees to help them do their best work, and we’re just as committed to employee growth as we are to responsible media investment. WPP Media employees can tap into the global WPP Media & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include 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 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.

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.

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

#LI-Promoted