HirePortal

Data Management and BI Manager, GOC

  • WPP Media
  • Mexico City, Bogotá +3 more
  • COP 80,000,000 – COP 120,000,000

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 a Manager, Business Intelligence, you will be a key partner to the Business Intelligence, Investment, Planning, Media, and Data Operations teams. You will help improve marketing efficiency by leading the development, maintenance, and delivery of accurate reporting products, dashboards, campaign measurement frameworks, and data-driven insights.

This is an individual contributor role with cross-functional leadership responsibilities and no direct reports. You will coordinate reporting workstreams, promote accountability across teams, and provide guidance to junior, senior, and offshore analysts when needed.

Key responsibilities include:

  • Lead the development and deployment of WPP Media reporting products and services across Excel, PowerPoint, and web-based dashboard environments.
  • Extract data from multiple media platforms and perform data hygiene, validation, and quality control using tools such as Power BI, Tableau, and Looker, in partnership with Data Operations.
  • Develop and maintain campaign measurement frameworks, including KPI alignment and performance benchmarks.
  • Own the development, maintenance, and enhancement of dashboards and data visualizations, ensuring their accuracy, functionality, and timely delivery.
  • Perform rigorous daily and weekly data QA, investigating discrepancies and protecting the integrity of reporting deliverables.
  • Create, populate, and format recurring monthly, quarterly, and campaign wrap reports, identifying and correcting naming, mapping, and data-quality issues.
  • Ensure that reported data and insights accurately represent digital media campaign performance.
  • Manage reporting playbooks, operational calendars, milestones, risks, and dependencies across participating teams.
  • Collaborate with Business Intelligence, Investment, and Data Operations teams to integrate new data sources and reporting requirements, including parsing, benchmarking, and mapping.
  • Conduct troubleshooting and root-cause analysis and coordinate the implementation of effective data and reporting fixes.
  • Support the collection and validation of partner-provided performance data.
  • Maintain complete and current documentation of data processes, procedures, business logic, and workflow changes.
  • Research platform capabilities and recommend improvements to data quality, operational efficiency, and reporting feasibility.
  • Facilitate data and reporting architecture discussions to support the reliable deployment and availability of reporting products.
  • When required, support the design, deployment, and maintenance of ETL and data management processes, including exception handling, rollback procedures, production data loads, and reporting automation using SQL or Python.
  • Evaluate new vendors, technologies, and advertising opportunities relevant to reporting and analytics.

Skills and Experience

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

  • Approximately 5+ years of professional experience in analytics or Business Intelligence working with large datasets. Equivalent relevant experience will be considered, and the number of years may be flexible for candidates with strong technical and industry alignment.
  • Professional experience working within a marketing or media agency environment, including familiarity with agency tools, processes, and reporting requirements.
  • Hands-on experience using Power BI; experience with Tableau or Looker is highly valued.
  • Familiarity with digital media and advertising technologies, including Google Campaign Manager, digital and social platforms, and web analytics tools.
  • Strong understanding of data architecture, data warehousing, data modeling, database design, ETL processes, data governance, and data-quality concepts.
  • Experience using SQL for data analysis, validation, reporting, or automation.
  • Experience using Python and/or R is a plus.
  • The ability to build dataflows or automate reporting processes using SQL or Python is highly valued.
  • Basic familiarity with cloud and data platforms, including Azure, Google Cloud Platform, or AWS.
  • Exposure to GCP services such as Cloud Storage, Dataproc, Dataflow, Cloud SQL, or BigQuery is a plus.
  • Experience processing and cleansing data for AI or machine-learning applications is a plus.
  • Experience designing, testing, or refining prompt architectures for generative AI models is a plus.
  • Familiarity with Agile or Scrum methodologies and project management tools is a plus.
  • Excellent written and verbal communication skills, with the ability to collaborate across Business Intelligence, Media, Investment, Planning, and Data Operations teams.
  • Experience collaborating within an offshore/onshore operating model.
  • Strong organizational, problem-solving, and stakeholder-management skills.
  • Experience with tag management or application coding is a plus.
  • A bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or a related field, or equivalent professional experience.

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 (https://www.wppmedia.com/pages/privacy-policy) 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.

Please read our Privacy Notice for more information on how we process the information you provide.

Skills

  • SQL
  • Data Visualization
  • Dashboard Development
  • Excel
  • PowerPoint
  • Business Intelligence
  • Campaign Measurement

Related jobs

WPP MediaApply for this job