Analyst - Agency Reporting

Overview

Hands-on Data Analyst role supporting client reporting and analytics within WPP Open, translating business questions into analytical solutions and dashboards, reporting to the Data Analytics Lead.

What you'll do

• Perform complex, hands-on data analysis to identify trends, patterns and anomalies in client usage data from the WPP Open platform.
• Conduct in-depth investigations and root cause analysis, contributing to predictive insights to proactively identify opportunities and risks.
• Develop and implement analytical models and methodologies to extract meaningful insights from large, diverse datasets.
• Utilize strong SQL skills to query, transform and analyze data from various data warehouses, ensuring data integrity and accuracy.
• Design, develop and maintain high-quality, actionable dashboards and reports using various BI tools, serving as primary delivery expert for monthly and ad-hoc client reporting.
• Continuously optimize existing reports and build new ones based on evolving client needs and strategic direction from the Lead.
• Work closely with the Lead to translate strategic objectives into concrete analytical and reporting deliverables.
• Collaborate with Data Engineers and Architects to ensure data availability, quality and efficient data pipelines.
• Provide technical expertise and contribute to the definition of data models and analytical frameworks.
• Communicate complex analytical findings, methodologies and recommendations to technical and non-technical stakeholders.
• Proactively identify data-related challenges and propose solutions to improve data quality, reporting efficiency and analytical capabilities.
• Act as subject matter expert for client usage data on WPP Open.

What you'll need

• Bachelor's degree in Computer Science, Data Science, Statistics, Mathematics, Economics, Information Systems, or a closely related quantitative field.
• 5+ years of overall industry experience of dedicated, hands-on experience in data analytics, business intelligence, or reporting roles.
• Proven experience delivering complex analytical projects from data extraction to insight presentation.
• Direct experience with product analytics platforms such as Google Analytics 4 (GA4), Adobe Analytics, Mixpanel, Pendo, Amplitude etc. (required).
• Very strong expertise in SQL (advanced queries, performance tuning, data modeling, stored procedures, etc.) is essential.
• Proficiency with large-scale data warehouses/platforms such as Google BigQuery, Databricks, and AWS data services (e.g., Redshift, S3, Glue, Athena).
• Advanced proficiency in Power BI for dashboard creation and interactive reporting.
• Demonstrated experience with statistical analysis techniques and concepts related to predictive modelling.
• Familiarity with data governance, data quality best practices, and ETL/ELT processes.
• Exceptional analytical and problem-solving skills, with the ability to identify patterns, draw conclusions and translate data into actionable business insights.
• Strong attention to detail and commitment to data accuracy and quality.
• Excellent written and verbal communication skills, able to articulate technical concepts clearly to diverse audiences.
• Self-motivated, able to work independently, manage multiple priorities and thrive in a fast-paced environment.

Nice to have

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

Details

• Location: India.
• Hybrid, with teams in the office around four days a week.
• Accommodations or flexibility can be discussed with the hiring team during the interview process.