Analytics & Reporting Manager

We are the ROI agency, a position we have proudly held true to since 2005. Our more than 6,000 specialists across 95 markets offer unparalleled capabilities in Media, Data, Technology, Commerce and Content. We put effectiveness at the heart of our work to solve complex challenges, drive successful business outcomes, and grow our clients’ businesses.

Over the years, we have evolved our definition of ROI, as it has changed with the ever-complicated communications landscape. ROI is no longer simply about the most efficient planning, buying and reporting of media.

Yes, ROI is about delivering Return on Investment; but it’s also about going beyond to deliver a Return on Imagination and more integrated experiences that inspire Growth. Top-line growth for our clients’ businesses, growth for our people and growth for our culture.

Powered by our best-in-class proprietary tools and data, our work spans the full spectrum of media communications, from analytics, data and technology to performance marketing, content and superior trading.

This breadth means we deliver Insight that lies at the intersection of consumer, category, and brand, attributing every budget to stronger business outcomes.

It means we deliver more creative media solutions that bring together best-in-class strategy, planning and the power of Publicis Groupe to ensure distinct and more personal brand experiences for our clients.

It means we adopt new data analytics and value optimisation techniques while building relationships with some of the world’s most exciting start-ups. We leverage over 30 years of media planning expertise to go beyond traditional media solutions and deliver a Return on Investment that is both forward-thinking and accountable to our clients.

At Zenith, we ultimately seek out a more meaningful kind of ROI. Our unique way of thinking inspires growth for some of the world’s leading brands, including Coty, Electrolux, Essity, Lactalis, Luxottica, Nestlé, Nomad Foods, Reckitt, Tik Tok and Verizon.

We are looking for a Looker Studio Analytics & Reporting Manager to create clear, compelling, and interactive reports that visualize media investment performance for a major global fashion retailer.

This is a highly autonomous role that will suit a data obsessive who can derive meaning and present it to a non-technical audience from often large and complex datasets.

Fundamentally, a love of data, curiosity and the desire to learn a lot in a short space of time will be what success in this role is measured on.

• Design and develop Looker Studio dashboards to visualize media investment, campaign performance, and marketing KPIs.
• Implement effective storytelling through data, ensuring dashboards are intuitive and aligned with business needs.
• Build custom calculations, filters, and blended visualizations within Looker Studio.
• Optimize dashboard performance, user experience, and accessibility.
• Collaborate with stakeholders to understand reporting needs and refine visualization outputs.
• Provide documentation and basic user training on dashboard functionality.
• On-going training and support of the account and wider agency network team in on-going ad-hoc analytics projects.
• Involvement in reporting on Data Governance and taxonomy compliance.
• To be the ‘Go-to’ resource on any data, analytics, visualization issues for the client and Zenith team.

To be successful in this role you will need:

• Advanced Excel user (advanced string functions for data manipulation, array formulas, Power Query for data cleansing/transforms, Power Pivot for basic data modeling).
• Previous experience working with large scale digital media campaign data at either agency or publisher. Will consider client experience if media spends are in excess of £10m per annum.
• Intermediate SQL and knowledge of Python for automation tasks.
• Familiarity with modern data stack – particularly pre-configured API tools such as Funnel/Five Tran/Adverity and exposure to a data warehouse product – Databricks/GBQ/Snowflake would be ideal.
• Certification or experience in Looker studio would be great but experience in mainstream BI tools such as Power
  
  BI or Tableau is essential.
• Exp…