Analyst - Agency Reporting
Core
Translate complex business questions into robust analytical solutions and deliver actionable intelligence for client reporting and analytics initiatives within the WPP Open platform.
Role type
Senior hands-on data analyst (agency reporting)
Builds
Actionable dashboards, reports, and predictive insights for client usage data
Domain
Advertising, marketing, and media agency analytics
Deliverable
dashboards & analysis
Required skills
Advanced SQL, Product analytics platforms (GA4, Adobe Analytics, Mixpanel, Pendo, Amplitude), Data visualization (Power BI), Statistical analysis, Predictive modeling, ETL/ELT processes
Preferred skills
Python or R scripting, Cloud certifications (Google Cloud, AWS, Databricks), Agency environment experience
Technologies
Google BigQuery, Databricks, AWS (Redshift, S3, Glue, Athena), Power BI, Google Analytics 4, Adobe Analytics, Mixpanel, Pendo, Amplitude
Responsibilities
Perform complex data analysis to identify trends and anomalies in client usage data; Design, develop, and maintain high-quality dashboards and reports; Collaborate with Data Engineers to ensure data quality and pipeline efficiency; Communicate analytical findings and recommendations to technical and non-technical stakeholders
Seniority
Senior, hands-on IC
