Associate, Data Analytics & BI, GOC

About the role

WPP Media is looking for an Associate, Data Analytics & BI for its Global Operations Centre (GOC). Working with teams across the United States, Europe and Asia, you will support the measurement and reporting of B2B advertising campaigns for a global professional services client, using T-SQL, Power BI and Excel to extract, organize, analyze and visualize campaign data.

Key responsibilities

• Extract, organize and format campaign data from advertising management platforms, retrieving and preparing it with T-SQL and Excel.
• Maintain, update and run quality assurance checks on dashboards and recurring reports in Power BI and Tableau.
• Produce campaign performance and spend pacing reports across multiple campaigns and client service lines.
• Perform recurring tracking tag QA checks to verify correct functionality and data flows.
• Help senior analytics colleagues turn media metrics into clear visualizations and presentations.
• Review campaign objectives and performance data with the team to find optimization opportunities and measurement solutions.
• Collaborate with Investment and Planning teams to gather campaign information and ensure complete reporting coverage.
• Identify and help resolve data gaps, discrepancies and reporting issues.

Required profile

• 1-2 years of professional experience in data analytics, reporting, business intelligence or digital media analytics.
• Hands-on experience extracting, organizing and analyzing data.
• Strong attention to detail and good communication skills, with organizational skills for multiple campaigns and recurring deadlines.
• Experience with Databricks is a plus.

Required skills

• T-SQL for retrieving and analyzing data
• Power BI for dashboards and reporting
• Excel for preparing and analyzing datasets
• Tableau (mentioned alongside Power BI)

What we offer

• Hybrid work, with teams in the office around four days a week.
• Medical, group retirement, vision and dental insurance, significant paid time off, partner discounts and mental health awareness days.
• Access to the global WPP Media and WPP networks.

The position is remote or hybrid and must be performed from anywhere in Mexico or Colombia; only candidates legally authorized to work in one of those countries may apply.