Wppmedia

Senior Manager, Insights & Analytics, GOC

Barranquilla, Colombia; Bogota, Colombia; Medellin, Colombia; Mexico City, Mexico. Posted a month ago

The role

You will report to the VP of Investment & Partnerships and own the end-to-end data workflow for partner spend forecasting, tracking and performance validation. You will build reporting models, produce spend pacing reports and validate forecasts against vendor delivery data.

What you will do

  • Extract, analyze and validate spend forecasts from CoreM
  • Gather and consolidate forecasts across agency, Solutions and Activation teams
  • Build and maintain unified reporting models across deal and non-deal partners
  • Produce recurring deal-partner spend pacing reports
  • Extract pacing data from MediaOcean and reconcile it with vendor delivery data
  • Investigate and resolve discrepancies between forecasted spend and actual delivery
  • Use Canadian market intelligence sources to validate investment decisions
  • Develop data-backed presentations for publisher negotiations and partnership reviews
  • Identify opportunities to automate data collection and reporting
  • Collaborate with agency teams, specialists and external media partners

Required qualifications

  • Bachelor's degree in Business, Marketing, Business Analytics, Project Management or a related field
  • 3-5 years of professional experience in media planning, media buying, investment or analytics
  • Deep understanding of the Canadian media landscape, including regulators, publishers and vendor ecosystems
  • Experience with media investment and measurement tools such as MediaOcean/Prisma, nLogic Lens and FT, Comscore and Airware
  • Advanced Excel proficiency, including nested formulas, pivot tables, Power Query and data modeling
  • Experience using Tableau and/or Power BI to build dashboards
  • Proficiency in PowerPoint, Word and Outlook
  • Strong analytical and problem-solving skills
  • Excellent attention to detail and data quality assurance skills
  • Strong project and time management skills
  • Effective communication and relationship-building skills
  • A proactive approach to identifying anomalies and improving reporting processes

Nice to have

  • Basic knowledge of SQL

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
  • Only candidates selected for an interview will be contacted

About the company

WPP Media is WPP's AI-driven media operating unit, bringing together media, data and partnerships. It is an equal opportunity employer.

Senior Manager, Insights & Analytics, GOC at Wppmedia | JobZoey