Data Management and BI Senior Executive, GOC

WPP Media; Bogotá ciudad; Híbrido; COP 186.840.000 - 280.260.000; Jornada completa

Descripción de la vacante

WPP Media is hiring a Senior BI Analyst to ensure partner and campaign data is accurate, complete, and ready for business intelligence reporting. You will manage the partner data update process from receipt and validation through QA, pipeline execution, and final dashboard verification.

Your work will directly support reliable data for campaign reporting and decision-making. Responsibilities include consolidating partner data files, validating fields, executing Alteryx QA workflows, loading data

Formación

• Professional experience in Business Intelligence, data operations, marketing analytics, data quality assurance, or reporting.
• Strong proficiency in Excel and Google Sheets, including consolidating large datasets.
• Hands-on experience with Alteryx workflows.
• Experience using SQL to query, validate, and reconcile data.
• Experience executing or monitoring data pipelines in Azure Data Factory.
• Experience reviewing dashboards in Tableau and data integration tools like Adverity.

Responsabilidades

• Receive, review, and consolidate Partner Data files via Excel, Sheets, email, or Drive.
• Validate data fields against master and reference tables.
• Consolidate information into historical data repository while preserving history.
• Run QA workflows, investigate flags, and resolve inconsistencies.
• Prepare final files and upload to server via FTP tools.
• Monitor Azure Data Factory pipelines loading data into SQL tables.
• Create SQL queries to validate information and fetch reference data.
• Review Tableau dashboards for accuracy and report discrepancies.
• Set up data connections with Adverity as needed.
• Perform recurring data quality checks across Facebook Ads and Reddit Ads.
• Coordinate with partners and stakeholders to resolve reporting issues.
• Adapt QA frequency per client needs (weekly, quarterly, etc.).
• Maintain Alteryx workflows and update calculations as needed.

Conocimientos

BI analytics

Data operations

Marketing analytics

Data quality assurance

Reporting

Herramientas

Alteryx

SQL

Tableau

Azure Data Factory

FileZilla

Adverity

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 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 Senior BI Analyst, you will help ensure that partner and campaign data is accurate, complete, and available for business intelligence reporting.

You will manage the partner data update process from initial file reception and validation through quality assurance, pipeline execution, and final dashboard verification. Your work will directly support the reliability of the data used for campaign reporting and decision-making.

Key responsibilities include:

• Receive, review, and consolidate Partner Data files provided through Excel, Google Sheets, email, or Google Drive.
• Validate key data fields, including placement codes and placement names, against master and reference tables.
• Consolidate validated information into the historical first-party data repository, ensuring that previous records remain accurate and unchanged.
• Execute established Alteryx QA workflows, investigate identified flags, and resolve data inconsistencies before files continue through the reporting pipeline.
• Prepare approved files and upload them to the appropriate server using FileZilla or FTP tools.
• Execute and monitor Azure Data Factory pipelines that load validated information into SQL tables for reporting consumption.
• Create and adapt SQL queries to validate partner information, retrieve reference data, and reduce errors before completing the full QA process.
• Review Tableau dashboards to confirm that newly loaded information is displaying accurately and report any inconsistencies for resolution.
• Use Adverity to retrieve missing campaign data and configure new campaign data connections when necessary.
• Conduct recurring data quality checks by comparing information from Facebook Ads and Reddit Ads against internal tables.
• Adjust QA frequency according to client needs, including weekly, quarterly, semiannual, or annual validation cycles.
• Monitor existing Alteryx workflows and update internal calculation formulas when required.
• Collaborate with partner teams and internal stakeholders to investigate file discrepancies and resolve reporting issues.

Skills And Experience

If this opportunity looks right for you, we are looking for candidates who have:

• Professional experience in Business Intelligence, data operations, marketing analytics, data quality assurance, or reporting.
• Strong proficiency in Excel and Google Sheets, including experience reviewing and consolidating large datasets.
• Hands‑on experience executing and troubleshooting Alteryx workflows.
• Experience using SQL to query, validate, and reconcile data across historical and reference tables.
• Experience executing or monitoring data pipelines in Azure Data Factory.
• Experience reviewing and validating reporting dashboards in Tableau.
• Familiarity with Adverity or comparable marketing data integration platforms.
• Experience working with FileZilla, FTP tools, or similar file-transfer solutions.
• Familiarity with campaign data from digital advertising platforms, particularly Facebook Ads and Reddit Ads.
• Strong understanding of data validation, reconciliation, and quality‑assurance processes.
• Excellent attention to detail and the ability to identify, investigate, and resolve data discrepancies.
• Strong organizational skills and the ability to manage recurring reporting and QA deadlines.
• Effective communication and collaboration skills for working with partners, client teams, and internal stakeholders.
• Professional English proficiency for collaborating with international stakeholders is highly valued.

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.