Data Management and BI Manager, GOC

WPP Media; Medellín; Presencial; COP 90.000.000 - 160.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Medical insurance

Retirement plans

Vision and dental insurance

Paid time off

Employee discounts

Mental health days

Hybrid work model

Descripción de la vacante

WPP Media in Colombia/remote-friendly setup seeks a Manager, Business Intelligence to partner with BI, Investment, Planning, and Data Operations teams. You will lead development of reporting products, measure campaigns, and deliver dashboards with data-driven insights.

The role is an individual contributor with cross-functional leadership, coordinating workstreams, prioritizing QA, and guiding analysts. Hybrid work is available, with a mix of remote and in-office collaboration across regions.

Formación

• 5+ years of professional experience in analytics or BI with large datasets.
• Experience in marketing or media agency environments and familiarity with agency tools and reporting.
• Hands-on experience with Power BI; Tableau/Looker knowledge is highly valued.
• Familiarity with digital media, advertising tech, and web analytics tools.
• Strong data architecture, warehousing, modeling, ETL, and data-quality concepts.
• Experience using SQL for data analysis, validation, or automation.
• Python and/or R skills are a plus; ability to build dataflows with SQL/Python is valued.
• Exposure to cloud platforms (Azure, GCP, AWS) and BigQuery/Dataflow is a plus.
• Experience supporting AI/ML data processing and prompt architectures for generative AI is a plus.
• Familiarity with Agile/Scrum and project management tools is a plus.
• Excellent written and verbal communication; able to collaborate across BI, Media, Investment, Planning, and Data Operations teams.
• Experience working in offshore/onshore models and strong stakeholder management.
• Bachelor-level or equivalent experience in relevant fields.

Responsabilidades

• Lead development and deployment of reporting products across Excel, PowerPoint, and web dashboards.
• Extract data from multiple media platforms; perform data hygiene and validation with BI tools.
• Develop and maintain campaign measurement frameworks and KPI alignment.
• Own dashboards and data visualizations with accurate, timely delivery.
• Perform daily/weekly data QA and investigate discrepancies.
• Create recurring monthly/quarterly/campaign wrap reports and fix data-quality issues.
• Ensure reported data accurately reflects digital media performance.
• Manage reporting playbooks, calendars, milestones, risks, and dependencies.
• Collaborate to integrate new data sources and reporting requirements.
• Troubleshoot, conduct root-cause analysis, and implement fixes.
• Support collection/validation of partner-provided performance data.
• Maintain documentation of data processes and logic.
• Research platform capabilities and propose data quality improvements.
• Facilitate data/reporting architecture discussions for reliability and availability.
• Support ETL/data management processes and reporting automation.

Conocimientos

Power BI

SQL

Python

Tableau

Looker

Data Modeling

Data Governance

Communication

Educación

Bachelor's degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics, or related field

Herramientas

Excel

PowerPoint

Power BI

Tableau

Looker

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.

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.

• 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

• 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.