Analyst - Agency Reporting

WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. We work with the world's most valuable brands and have global reach across 100+ markets, with deep local expertise. Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow. For more information, visit WPP.com. Why we're hiring: We are seeking a highly skilled and proactive  Data Analyst to be a critical hands-on contributor to our client reporting and analytics initiatives within WPP Open. Reporting directly to the Data Analytics Lead, you will be responsible for translating complex business questions into robust analytical solutions, going beyond descriptive reporting to identify patterns, drive predictive insights, and deliver actionable intelligence to our client teams. This role is for an expert practitioner who thrives on diving deep into data, possesses exceptional SQL skills, and has a proven track record of delivering impactful analytical products. You will play a key role in executing the data strategy defined by the Lead, ensuring data accuracy, and championing innovative analytical approaches. What you'll be doing: Advanced Data Analysis & Insight Generation: Perform complex, hands-on data analysis to identify key trends, patterns, and anomalies in client usage data from the WPP Open platform. Go beyond standard reporting by conducting in-depth investigations, root cause analysis, and 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 very strong SQL skills to query, transform, and analyze data efficiently from various data warehouses, ensuring data integrity and accuracy. Reporting & Dashboarding Delivery: Design, develop, and maintain high-quality, actionable dashboards and reports using various BI tools, serving as a primary delivery expert for monthly and ad-hoc client reporting. Ensure all reporting is accurate, consistent, and provides clear, concise narratives that drive understanding and action. Continuously optimize existing reports and build new ones based on evolving client needs and strategic direction from the Lead. Technical Execution & Collaboration: Work closely with the Lead to understand strategic objectives and translate them into concrete analytical and reporting deliverables. Collaborate…