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 allows WPP Media employees to leverage the extensive global WPP Media & WPP networks to pursue their passions, build vital professional connections, and learn at the cutting edge of marketing and advertising.

We Create an Open environment built 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 events showcasing team 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 when we're together, fostering creativity, collaboration, and connection in this open and supportive environment. 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 that while our philosophy is the same across WPP, benefits may vary by office/country.

This position is available in a Remote or Hybrid Work Modality and must be performed from any location within Mexico or Colombia. Only candidates residing in either country who are legally authorized to work there may apply. Remote work from outside Mexico or Colombia, including relocation abroad under a remote work contract, is not permitted under any circumstances.

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-GOC