Analyst - Agency Reporting

The role

You will do hands-on data analysis and build dashboards and reports on client usage data from the WPP Open platform. You will turn business questions into analytical solutions, go beyond standard reporting to find patterns and predictive insights, and explain findings to client teams.

What you will do

• Perform complex data analysis to find trends, patterns and anomalies in client usage data from WPP Open.
• Run in-depth investigations, root cause analysis and predictive insights.
• Develop analytical models and methods to extract insights from large, diverse datasets.
• Query, transform and analyze data from data warehouses using SQL, keeping data accurate.
• Design, build and maintain dashboards and reports in BI tools for monthly and ad-hoc client reporting.
• Keep reports accurate and optimize them as client needs change.
• Translate the Lead's strategic objectives into analytical and reporting deliverables.
• Work with Data Engineers and Architects on data availability, quality and pipelines.
• Communicate findings and recommendations to technical and non-technical stakeholders.
• Act as subject matter expert for client usage data on WPP Open.

Required qualifications

• Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, Economics, Information Systems or a closely related quantitative field.
• 5+ years of hands-on industry experience in data analytics, business intelligence or reporting.
• Proven experience delivering complex analytical projects from data extraction to insight presentation.
• Direct experience with product analytics platforms such as Google Analytics 4, Adobe Analytics, Mixpanel, Pendo or Amplitude.
• Very strong SQL skills, including advanced queries, performance tuning, data modeling and stored procedures.
• Proficiency with large-scale data platforms such as Google BigQuery, Databricks, and AWS data services (Redshift, S3, Glue, Athena).
• Advanced proficiency in Power BI for dashboards and interactive reporting.
• Demonstrated experience with statistical analysis and predictive modelling concepts.
• Familiarity with data governance, data quality practices, and ETL/ELT processes.
• Exceptional analytical and problem-solving skills.
• Strong attention to detail and commitment to data accuracy.
• Excellent written and verbal communication skills.

Nice to have

• Master's degree in a quantitative field.
• Experience in an advertising, marketing or media agency environment.
• Proficiency in Python or R for data analysis, statistical modelling or automation.
• Relevant professional certifications such as Google Cloud Certified, AWS Certified or Databricks Certified.

Benefits

• Passionate, inspired colleagues in a culture built for extraordinary work.
• Scale and opportunity to create, influence and complete projects at industry-leading scale.
• Challenging and stimulating work with a group of creative problem solvers.

Before you apply

• The posting lists Google Analytics 4, Adobe Analytics, Mixpanel, Pendo or Amplitude experience as a must.

About the company

WPP is a growth partner for major global brands, combining media intelligence, data, creativity, production, enterprise solutions and strategic counsel. It works across 100+ markets.