Own commercial analytics and incentive reporting by managing complex datasets, ensuring accurate compensation, building dashboards, automating workflows, and delivering actionable performance insights to commercial leaders.
Associate, Data Analytics & BI, GOC
📜 Description
- Extract, organize, and analyze campaign data from advertising platforms using T-SQL and Excel.
- Maintain and quality-check recurring dashboards and reports in Power BI and Tableau.
- Report on campaign performance and spend pacing across campaigns and client service lines.
- Check tracking tags and investigate data gaps, discrepancies, and reporting issues.
- Collaborate with Investment, Planning, and Analytics teams to ensure complete reporting and communicate findings through visualizations and presentations.
- Review campaign objectives and performance to identify optimization opportunities and measurement solutions.
🛠️ Requirements
- 1–2 years of relevant professional experience in data analytics, reporting, business intelligence, or digital media analytics.
- Hands-on experience with data extraction, organization, and analysis.
- Practical experience using T-SQL to retrieve and analyze data.
- Experience using Power BI to maintain dashboards, visualize information, and support reporting.
- Proficiency in Excel for preparing, organizing, and analyzing datasets.
- Strong attention to detail and the ability to validate data, identify discrepancies, and maintain reporting accuracy.
- Good communication skills, with the ability to explain findings clearly and coordinate with different stakeholders.
- A collaborative approach to working with Investment, Planning, and Analytics teams.
- Organizational skills to support multiple campaigns and recurring reporting deadlines.
- Experience with Databricks is a plus.
✨ Benefits
- Medical insurance
- Group retirement plans
- Vision insurance
- Dental insurance
- Significant paid time off
- Preferential partner discounts
- Employee mental health awareness days
Full job description
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, visit wppmedia.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 an Analyst, Digital Media Analytics who will support the measurement and reporting of B2B advertising campaigns for a global professional services client.
In this role, you will use T-SQL, Power BI, and Excel to extract, organize, analyze, and visualize campaign data. You will collaborate with Investment, Planning, and senior Analytics teams to ensure accurate reporting, monitor campaign performance and spend pacing, and identify gaps in the data.
Key responsibilities include:
-
Extract, organize, and format campaign data from advertising management platforms to support analysis and reporting.
-
Use T-SQL and Excel to retrieve, prepare, and analyze data, supporting accurate and consistent campaign reporting.
-
Maintain, update, and perform 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 support accurate data flows.
-
Help senior Analytics team members translate media metrics into clear visualizations and presentations that support decision-making.
-
Review campaign objectives and performance data with the team to identify optimization opportunities and potential 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, working with relevant teams to improve information quality.
Skills and Experience
If this opportunity looks right for you, we are looking for candidates who have:
-
1–2 years of relevant professional experience in data analytics, reporting, business intelligence, or digital media analytics.
-
Hands-on experience with data extraction, organization, and analysis.
-
Practical experience using T-SQL to retrieve and analyze data.
-
Experience using Power BI to maintain dashboards, visualize information, and support reporting.
-
Proficiency in Excel for preparing, organizing, and analyzing datasets.
-
Strong attention to detail and the ability to validate data, identify discrepancies, and maintain reporting accuracy.
-
Good communication skills, with the ability to explain findings clearly and coordinate with different stakeholders.
-
A collaborative approach to working with Investment, Planning, and Analytics teams.
-
Organizational skills to support multiple campaigns and recurring reporting deadlines.
-
Experience with Databricks is a plus.
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 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.
#LI-GOC
Please read our Privacy Notice for more information on how we process the information you provide.
Similar jobs
Search more Data Analyst jobsData Extraction and Operations Analyst (SQL)
Build and validate e-receipt data extractors, analyze large-scale U.S. retail data with SQL, investigate quality issues, and improve operational processes alongside technical and client-facing teams.
Analisa, explora e trata dados para identificar informações relevantes ao negócio, além de desenvolver dashboards, relatórios e KPIs e apoiar a qualidade e sustentação das soluções de dados.
Analyze commercial data across marketing, product, technology, and commercial teams, building dashboards and models that turn business questions into clear recommendations and support better decisions.
Develop and maintain automated web-scraping solutions that capture accurate, structured regulatory data from complex websites, while improving extraction reliability, performance, and team workflows.
