Manager, Data Analytics & BI, GOC

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. • Knowledge of digital advertising and media planning platforms, including Meta, TikTok, Snapchat, Reddit, Google Campaign Manager, DV360, SA360, and Prisma/Mediaocean . • An understanding of traditional media data and campaign performance KPIs . • Experience with data validation, reconciliation, paid media taxonomy, naming conventions, data mapping, and governance standards . • Team leadership and project management experience , including cross-functional coordination, reporting cycles, timelines, and multiple deliverables. • Excellent written and verbal English communication skills , with the ability to explain complex data topics to technical and non-technical stakeholders. • Advanced Excel and PowerPoint skills . • Practical experience using AI tools to improve reporting, analysis, and operational efficiency. • A bachelor’s degree in Computer Science, Information Technology, Engineering, Business Analytics, Data Science, Marketing , or a related field, or equivalent professional experience. • Experience developing AI agents to automate data QA, insight generation, or report preparation is a plus. • Knowledge of Python, Microsoft Copilot, Google Colab, or Alteryx is a plus. • An understanding of API-based data integrations , including potential discrepancies between platform interfaces and database extracts, is desirable. • Previous experience supporting MMM data collection, validation, and coordination with external partners is a plus. Life at WPP Media & Benefits Our passion for shaping the next era of media is powered by our commitment to Be Extraordinary , investing in our employees to inspire transformational creativity. We also Lead Optimistically , firmly believing in and Championing Growth and Development for every individual. This commitment