Data Management and BI Senior Executive, GOC

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 our pioneering agentic 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, visitwppmedia.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 aSenior BI Analystwho will:

• Manage thepartner data update process, from file reception and validation through quality assurance, pipeline execution, and final dashboard verification, ensuring accurate and complete data for campaign reporting and decision-making.

• Receive, review, and consolidatePartner Data filesprovided throughExcel, Google Sheets, email, or Google Drive.

• Validate key data fields, includingplacement codes and placement names, against master and reference tables.

• Consolidate validated information into the historicalfirst-party data repository, ensuring that previous records remain accurate and unchanged.

• Execute establishedAlteryx 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 usingFileZilla or FTP tools.

• Execute and monitorAzure Data Factory pipelinesthat load validated information intoSQL tablesfor reporting consumption.

• Create and adaptSQL queriesto validate partner information, retrieve reference data, and reduce errors before completing the full QA process.

• ReviewTableau dashboardsto confirm that newly loaded information is displaying accurately and report any inconsistencies for resolution.

• UseAdverityto retrieve missing campaign data and configure new campaign data connections when necessary.

• Conduct recurringdata quality checksby comparing information fromFacebook Ads and Reddit Adsagainst internal tables.

• AdjustQA frequencyaccording to client needs, including weekly, quarterly, semiannual, or annual validation cycles.

• Monitor existingAlteryx workflowsand update internal calculation formulas when required.

• Collaborate withpartner teams and internal stakeholdersto investigate file discrepancies and resolve reporting issues.

Skills and Experience

• Professional experience inBusiness Intelligence, data operations, marketing analytics, data quality assurance, or reporting.

• Strong proficiency inExcel and Google Sheets, including experience reviewing and consolidating large datasets.

• Hands-on experience executing and troubleshootingAlteryx workflows.

• Experience usingSQLto query, validate, and reconcile data across historical and reference tables.

• Experience executing or monitoring data pipelines inAzure Data Factory.

• Experience reviewing and validating reporting dashboards inTableau.

• Familiarity withAdverityor comparable marketing data integration platforms.

• Experience working withFileZilla, FTP tools, or similar file-transfer solutions.

• Familiarity with campaign data from digital advertising platforms, particularlyFacebook Ads and Reddit Ads.

• Strong understanding ofdata validation, reconciliation, and quality-assurance processes.

• Excellentattention to detailand the ability to identify, investigate, and resolve data discrepancies.

• Strong organizational skills and the ability to managerecurring reporting and QA deadlines.

• Effectivecommunication and collaboration skillsfor working with partners, client teams, and internal stakeholders.

• Professional English proficiencyfor 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 toBe Extraordinary, investing in our employees to inspire transformational creativity. We alsoLead Optimistically, firmly believing in andChampioning Growth and Developmentfor 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.

WeCreate an Open environmentbuilt 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 aRemote or Hybrid Work Modalityand must be performed from any location withinMexico or Colombia. Only candidates residing in either country who arelegally authorized to work theremay apply. Remote work from outsideMexico or Colombia, including relocation abroad under a remote work contract, isnot permitted under any circumstances.

Please read ourPrivacy Noticefor 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 ourPrivacy Noticefor more information on how we process the information you provide.