Data Management and BI Manager, GOC

WPP Media; Bogotá ciudad; Híbrido; COP 133.920.000 - 267.840.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Remote work option

Hybrid work model

Competitive compensation

Descripción de la vacante

WPP Media is seeking a Manager of Business Intelligence to partner with BI, Investment, Planning, Media and Data Operations teams. You will lead reporting product development, dashboards, and campaign measurement, ensuring accuracy and timely delivery across Excel, PowerPoint, and web dashboards.

Ideal candidates bring 5+ years in analytics/BI within marketing/agency settings, strong SQL, and experience with Power BI; Tableau/Looker are a plus.

Formación

• Approximately 5+ years of analytics or BI experience with large datasets.
• Experience in marketing/media agency environment preferred.
• Strong proficiency in Power BI; Tableau or Looker valued.

Responsabilidades

• Lead development and deployment of reporting products across Excel, PowerPoint, and dashboards.
• Coordinate data extraction, cleaning, validation, and quality control with Data Operations.
• Develop campaign measurement frameworks and KPI benchmarks.
• Own dashboards and data visualizations for timely, accurate reporting.
• Perform daily/weekly data QA and resolve discrepancies.
• Create recurring monthly/quarterly campaign wrap reports and ensure data quality.

Conocimientos

Power BI

Tableau

Looker

SQL

Python

Data warehousing

ETL

Data governance

Agile/Scrum

Stakeholder mgmt

Educación

Bachelor's degree in Marketing, Advertising, Economics, CS, or related

Herramientas

Excel

PowerPoint

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.

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.