Data Management and BI Manager, GOC

WPP Media; Medellín; Híbrido; COP 144.000.000 - 228.000.000; Jornada completa

Descripción de la vacante

WPP Media is seeking a BI Manager to lead data engineering and analytics efforts. You will design data architectures, develop automated ETL pipelines, and maintain dashboards across environments to support performance insights.

The role emphasizes collaboration with onshore and offshore teams, strong SQL/Python skills, and experience with Power BI and ad-tech platforms. A global, multidisciplinary team awaits.

Formación

• Bachelor's degree in Computer Science, Information Technology, Engineering, Business Analytics, Data Science, or a related field.
• 5+ years of experience in Data Engineering or Business Intelligence, preferably in a digital marketing/media environment.
• Hands-on expertise in Power BI; experience with Datorama/Tableau/Looker is valued.
• Strong SQL and Python (or R) for ETL scripting and data manipulation; advanced Excel skills.
• Familiarity with QA methodologies and automated testing for data pipelines.
• Knowledge of ad-tech and digital platforms and web analytics tools.
• Exposure to Google Cloud Platform or AWS/Azure is a plus.
• Excellent written and verbal English communication; ability to collaborate across onshore/offshore teams.

Responsabilidades

• Define business requirements to build and maintain stable data architecture.
• Design, build, and deploy automated ETL processes and scripts (SQL/Python) to streamline data extraction, quality checks, and reporting delivery.
• Extract datasets from multiple media platforms and assist with intake and QA of partner-provided performance data.
• Develop, update, and maintain highly interactive dashboards and visualizations across environments.
• Design, write, and execute robust test plans, test cases, and automated validation scripts to ensure zero-defect reporting.
• Perform rigorous data validation and reconciliation between visualization platforms (Power BI, Datorama, Tableau, etc.) and underlying raw data sources/warehouses.
• Perform data hygiene, mapping, and parsing; troubleshoot and implement fixes for data discrepancies.
• Ensure all data governance and taxonomy requirements are adhered to.
• Support project timelines and deliverable schedules, proactively communicating progress, risks, and dependencies.
• Maintain a flexible, agile mindset to support different onshore agency teams as needed.
• Maintain comprehensive, up-to-date documentation of workflows, data schemas, QA testing processes, and change logs.

Conocimientos

Power BI

Datorama

Tableau

Looker

SQL

Python

QA testing

Ad-tech

Cloud platforms

English

Educación

Bachelor's degree in CS/IT/Eng/Analytics

Herramientas

Google Cloud Platform

BigQuery

Dataflow

Descripción del empleo

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 ourpioneeringagentic marketing platform, WPP Open – we help clients navigate change, capture opportunity, and deliver transformational growth.

Core Values

• Be Extraordinary by Leading Collectively to Inspire transformational Creativity.
• Create an Open environment by Balancing People and Client Experiences by Cultivating Trust.
• Lead Optimistically by Championing Growth and Development to Mobilize the Enterprise.

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 BI Manager who will:

Responsibilities

• Define business requirements to build and maintain stable data architecture.
• Design, build, and deploy automated ETL processes and scripts (SQL/Python) to streamline data extraction, quality checks, and reporting delivery.
• Extract datasets from multiple media platforms and assist with intake and QA of partner‑provided performance data.
• Develop, update, and maintain highly interactive dashboards and visualizations across environments.
• Design, write, and execute robust test plans, test cases, and automated validation scripts to ensure zero‑defect reporting.
• Perform rigorous data validation and reconciliation between visualization platforms (Power BI, Datorama, Tableau, etc.) and underlying raw data sources/warehouses.
• Perform data hygiene, mapping, and parsing; troubleshoot and implement fixes for data discrepancies.
• Ensure all data governance and taxonomy requirements are adhered to.
• Support project timelines and deliverable schedules, proactively communicating progress, risks, and dependencies.
• Maintain a flexible, agile mindset to support different onshore agency teams as dynamic business needs arise.
• Maintain comprehensive, up‑to‑date documentation of workflows, data schemas, QA testing processes, and change logs.

Skills and Experience

• Bachelor's degree in Computer Science, Information Technology, Engineering, Business Analytics, Data Science, or a related field.
• 5+ years of experience in Data Engineering or Business Intelligence, preferably within a digital marketing agency, media agency, or commerce media environment.
• Hands‑on, advanced expertise in Power BI; experience with Datorama, Tableau, or Looker is highly valued.
• Strong proficiency in SQL and Python (or R) for test automation, ETL scripting, and data manipulation; advanced Excel skills.
• Proven understanding of software QA methodologies, test‑case planning, and automated testing frameworks applied to data pipelines.
• Deep familiarity with ad‑tech and digital platforms (e.g., Google Campaign Manager, social platforms, DSPs) and web analytics tools.
• Exposure to cloud infrastructure (Google Cloud Platform preferred—BigQuery, Cloud Storage, Dataflow—or AWS/Azure equivalent) is a plus.
• Exceptional written and verbal English communication skills, with a proven ability to collaborate seamlessly in an onshore/offshore model.

Life at WPP Media & Benefits

Our passion for shaping the next era of media includes investing in our employees to help them do their best work, and we’re just as committed to employee growth as we are to responsible media investment. WPP Media employees can tap into the global WPP Media & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in‑office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include access to internal learning platforms, certifications, and training sessions, life insurance, wellness programs, significant paid time off, preferential partner discounts, employee mental health awareness day, and more.

Equal‑Opportunity Mandate

WPP Media is an equal‑opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.

Mandatory Residency Notice

This position is available in a Remote or Hybrid Work Modality and is open only to candidates residing in Mexico or Colombia. The candidate must perform their work from within Mexico or Colombia. Only Mexican or Colombian nationals residing in their respective country, or foreign nationals with a valid work permit in Mexico or Colombia, may apply. Remote work from abroad (outside of Mexico or Colombia) is not permitted under any circumstances. Remote work contracts do not allow employment or relocation abroad.

Legal Notices

Please read our Privacy Notice (https://www.wppmedia.com/pages/privacy-policy) for more information on how we process the information you provide.