About WPP Media

WPP is the trusted growth partner for the world’s leading brands. With exceptional talent, trusted data and intelligence, and world-class partnerships – all united by our pioneering agentic marketing platform, WPP Open – we help clients navigate change, capture opportunity, and deliver transformational growth.

WPP Media is WPP's 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 wppmedia.com.

Role Summary and Impact

As part of the Global Operations Centre (GOC), you will work closely with teams across the United States, Europe, and Asia to deliver high-impact solutions in a collaborative, multicultural environment. We are looking for a Manager, Business Intelligence who will oversee client reporting, performance measurement, and data quality for assigned brands.

This client-facing role combines advanced Power BI and SQL expertise with team leadership, project management, and stakeholder communication. You will partner with Investment and Data Operations teams, guide offshore analysts, and support AI-assisted reporting improvements and Marketing Mix Modeling (MMM) initiatives.

Key responsibilities include:

Own the monthly reporting cycle, aligning with Investment teams on scope, KPIs, deliverables, timelines, reviews, and approvals.
Validate reporting data and AI-assisted performance insights, ensuring accuracy, relevance, and consistency before client distribution.
Maintain campaign measurement frameworks, including platform-specific KPIs, benchmarks, measurement studies, and performance tracking requirements.
Manage client questions, reporting requests, and ad hoc performance analyses.
Provide direction and operational support to offshore senior analysts, setting priorities and overseeing the quality of reports and dashboards.
Build, maintain, and troubleshoot Power BI dashboards, including semantic models, data modeling, DAX, Power Query, Row-Level Security (RLS), workspace permissions, and Power BI apps.
Define business and technical requirements for Data Operations, covering data sources, metrics, dimensions, granularity, refresh frequency, mapping, and transformation logic.
Use SQL to extract, validate, and reconcile data across databases, reporting environments, and media platforms.
Partner with Data Operations to investigate and resolve data discrepancies, classification issues, and transformation requirements.
Maintain paid media taxonomies, naming conventions, and data governance standards across advertising and media planning platforms.
Document reporting workflows, data schemas, QA procedures, templates, and process changes.
Identify opportunities to improve reporting efficiency and data quality through automation and AI tools.
Support measurement studies, including Brand Lift studies, and provide analytical support across brands as business needs evolve.
Support the Associate Director with MMM data collection, transformation, and quality assurance, coordinating digital and traditional media inputs, including linear TV, out-of-home, and print.
Reconcile platform data, database and API extracts, and budget information for MMM submissions, investigating discrepancies and coordinating resolutions.
Manage data reviews, stakeholder sign-offs, and submission deadlines with external MMM partners.

Skills and Experience

If this opportunity looks right for you, we are looking for candidates who have:

5+ years of professional experience in Business Intelligence, Reporting, or Data Analytics, preferably within a media agency, digital marketing, or commerce media environment.
Advanced, hands-on Power BI expertise, including dashboard development, semantic models, data modeling, DAX, Power Query, RLS, and workspace and app permissions.
Strong SQL skills for data extraction, validation, and reconciliation, with an understanding of data transformation, staging tables, views, and reporting pipelines.