Manager, Data Analytics & BI, GOC

The role

You will own the monthly client reporting cycle and manage Power BI dashboards and data quality for assigned brands. You will lead offshore analysts and support Marketing Mix Modeling (MMM) work with external partners.

What you will do

• Own the monthly reporting cycle with Investment teams on scope, KPIs, deliverables, timelines and approvals
• Validate reporting data and AI-assisted performance insights before client distribution
• Maintain campaign measurement frameworks, benchmarks and performance tracking
• Manage client questions, reporting requests and ad hoc performance analyses
• Direct and support offshore senior analysts and oversee report and dashboard quality
• Build, maintain and troubleshoot Power BI dashboards, semantic models and permissions
• Define business and technical requirements for Data Operations
• Use SQL to extract, validate and reconcile data across databases and media platforms
• Maintain paid media taxonomies, naming conventions and data governance standards
• Support MMM data collection, reconciliation and submissions with external partners

Required qualifications

• 5+ years of professional experience in Business Intelligence, Reporting or Data Analytics
• Advanced, hands-on Power BI expertise, including DAX, Power Query, RLS and workspace and app permissions
• Strong SQL skills for data extraction, validation and reconciliation
• Knowledge of digital advertising and media planning platforms such as Meta, TikTok, Google Campaign Manager, DV360, SA360 and Prisma/Mediaocean
• Understanding of traditional media data and campaign performance KPIs
• Experience with data validation, reconciliation, taxonomy, data mapping and governance standards
• Team leadership and project management experience
• Excellent written and verbal English communication skills
• Advanced Excel and PowerPoint skills
• Practical experience using AI tools to improve reporting and efficiency
• Bachelor's degree in Computer Science, IT, Engineering, Business Analytics, Data Science, Marketing or related field, or equivalent professional experience
• Understanding of API-based data integrations

Nice to have

• Experience developing AI agents to automate data QA, insight generation or report preparation
• Knowledge of Python, Microsoft Copilot, Google Colab or Alteryx
• Understanding of API-based data integration discrepancies between platform interfaces and database extracts
• Previous experience supporting MMM data collection and coordination with external partners

Benefits

• Competitive medical insurance
• Group retirement plans
• Vision and dental insurance
• Significant paid time off
• Preferential partner discounts
• Employee mental health awareness days
• Employee resource groups and in-office events

Before you apply

• Only candidates residing in Mexico or Colombia who are legally authorized to work there may apply
• Remote work from outside Mexico or Colombia, including relocation abroad, is not permitted

About the company

WPP Media is WPP's AI-driven media operating unit, bringing together media, data and partnerships to deliver creative personalisation at scale. It is an equal opportunity employer.