Manager, Data Analytics & Business Intelligence (BI), GOC

WPP; Perímetro Urbano Medellín; Hybrid; COP 9,000,000 - 18,000,000; Full time

Benefits offered by this job

Hybrid work model

Remote/flexible arrangements

Job summary

WPP Media is seeking a Manager, Business Intelligence (Data Engineering and Reporting) to architect data flows, automate ETL, and deliver dashboards across Power BI, Datorama, and Tableau. You’ll work with onshore and offshore teams, ensure data governance, and enable reliable marketing reporting for global clients.

The role requires 5+ years in BI/DE, strong SQL, Python or R, and advanced Excel. Hybrid/hub opportunities span Mexico or Colombia, with a global operations context.

Qualifications

• 5+ years in Data Engineering or BI, preferably in marketing or media.
• Advanced Power BI; knowledge of Datorama/Tableau/Looker valued.
• Strong SQL proficiency; Python or R for ETL and testing.
• Advanced Excel; QA methodologies and automated testing for data pipelines.
• Familiarity with ad-tech platforms and web analytics tools.
• Experience with cloud infra (GCP preferred) and BigQuery/Dataflow.
• Excellent written and verbal English; onshore/offshore collaboration.
• Bachelor’s degree or equivalent professional experience.

Responsibilities

• Define business requirements to build stable data architecture.
• Design and deploy ETL processes and SQL/Python scripts for data pipelines.
• Extract datasets from multiple media platforms and QA partner data.
• Develop interactive dashboards and visualizations that are accurate and scalable.
• Support report generation and testing plans to ensure accuracy.
• Validate data across Power BI, Datorama, Tableau and raw sources.
• Maintain data hygiene, mapping, and change logs with governance.
• Collaborate with onshore/offshore teams and manage timelines.

Skills

Data Engineering

Business Intelligence

Power BI

SQL

Python

R

Excel

QA methodologies

Ad-tech platforms

English communication

Cloud platforms

Education

Bachelor's degree in Computer Science / IT / Engineering / Business Analytics / Data Science

Tools

Google Cloud Platform

BigQuery

Cloud Storage

Dataflow

Tableau

Datorama

Looker

SQL

Job description

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.

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 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 (Data Engineering and Reporting) who will:

• Define business requirements to build and maintain stable data architecture that supports marketing efficiency and reliable reporting.

• Design, build, and deploy automated ETL processes and SQL/Python scripts to streamline data extraction, quality checks, and reporting delivery.

• Extract datasets from multiple media platforms and support the intake and quality assurance of partner-provided performance data.

• Develop, update, and maintain highly interactive dashboards and visualizations , ensuring they are accurate, visually impactful, and architecturally sound.

• Support report generation as needed.

• Design, write, and execute test plans, test cases, and automated validation scripts using Python and SQL to ensure reporting accuracy.

• Perform rigorous data validation and reconciliation between visualization platforms, including Power BI, Datorama, and Tableau , and underlying raw data sources or warehouses.

• Perform data hygiene, mapping, and parsing , investigate discrepancies through root-cause analysis, and implement effective fixes.

• Ensure adherence to data governance and taxonomy requirements.

• Support project timelines and deliverable schedules , proactively communicating progress, risks, and dependencies.

• Adapt to changing business needs by supporting different onshore agency teams and coordinating team support when needed.

• Identify and optimize repetitive tasks to improve operational efficiency.

• Maintain comprehensive, up-to-date documentation of workflows, data schemas, QA testing processes, and change logs.

Skills and Experience

• 5+ years of experience in Data Engineering or Business Intelligence , preferably within a digital marketing agency, media agency, or commerce media environment.

• Advanced, hands-on Power BI expertise is required ; experience with Datorama, Tableau, or Looker is highly valued.

• Strong proficiency in SQL.

• Proficiency in 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 , such as Google Campaign Manager, social platforms, and DSPs , as well as web analytics tools.

• Exposure to cloud infrastructure is a plus, preferably Google Cloud Platform , including BigQuery, Cloud Storage, and Dataflow , or equivalent AWS/Azure services.

• Exceptional written and verbal English communication skills , with a proven ability to collaborate effectively within an onshore/offshore operating model.

• A bachelor’s degree in Computer Science, Information Technology, Engineering, Business Analytics, Data Science , 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.

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.

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