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

WPP Media Limited; United States; Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Medical insurance

Retirement plans

Vision insurance

Dental insurance

Paid time off

Partner discounts

Mental health days

Job summary

WPP Media is seeking a Manager, Business Intelligence (Data Engineering and Reporting) to design and maintain data architecture, build ETL pipelines, and develop interactive dashboards across BI platforms such as Power BI, Tableau, and Looker.

You will collaborate with global teams, ensure data quality, and drive reporting accuracy while adapting to evolving business needs in a hybrid work environment.

Qualifications

• 5+ years of experience in Data Engineering or Business Intelligence.
• Advanced Power BI expertise; experience with Datorama/Tableau/Looker is valued.
• Strong SQL proficiency; Python or R for ETL/test automation.
• Advanced Excel skills; knowledge of QA methodologies and testing frameworks.
• Experience with ad-tech platforms and web analytics; cloud exposure (GCP/AWS/Azure).

Responsibilities

• Define business requirements to build and maintain data architecture supporting marketing efficiency and reporting.
• Design, build, and deploy ETL processes and SQL/Python scripts for data extraction and validation.
• Extract datasets from multiple media platforms and validate partner data quality.
• Develop interactive dashboards and visualizations across BI tools.
• Write and execute test plans and automated validation scripts.

Skills

Power BI

SQL

Python

Excel

QA testing

Ad-tech platforms

English communication

Education

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

Tools

Datorama

Tableau

Looker

BigQuery

Cloud Storage

Dataflow

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 .

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.

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