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.

Please read our Privacy Notice 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.