Analytics & Reporting Manager

Company Description

We are the ROI agency, apositionwe haveproudlyheld trueto since 2005. Our more than 6,000specialistsacross
95marketsofferunparalleledcapabilitiesin

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- complicatedcommunicationslandscape.

ROI isnolongersimplyaboutthemost efficient planning, buying and reporting of media.

Yes,ROIisaboutdelivering Returnon Investment ;butit’salsoaboutgoingbeyondtodelivera

Returnon Imaginationandmoreintegratedexperiencesthatinspire Growth .Top-line growth

forourclients’businesses,growthforourpeopleandgrowthforourculture.

Poweredbyourbest-in-classproprietarytoolsanddata,ourworkspansthefullspectrumof media communications, from analytics, data and technology to performance marketing, content and superior trading.

Thisbreadthmeanswedeliver Insightthatliesattheintersectionofconsumer,category,and brand, attributing every budget to stronger business outcomes.

Itmeanswedelivermorecreativemediasolutionsthatbringtogetherbest-in-class strategy, planning and the power of Publicis Groupe to ensure distinct and more personal brand experiences for our clients.

Itmeansweadoptnewdataanalyticsandvalueoptimisationtechniqueswhilebuilding

relationshipswithsomeoftheworld’smostexcitingstart-ups.

Weleverageover
30yearsof 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.

AtZenith,weultimatelyseekoutamoremeaningfulkindof

ROI. Ouruniquewayofthinking inspires growth for some of theworld’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 visualise media investment performance for a major global fashion retailer.

This is a highly autonomous role that will suit a data obsessive that can derive meaning and present it to a non-technical 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 visualise 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 visualisations within Looker Studio.
• Optimise dashboard performance, user experience, and accessibility.
• Collaborate with stakeholders to understand reporting needs and refine visualisation 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, visualisation 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 modelling)
• 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. Not expecting hands on experience in engineering but familiarity with the processes of creating pipelines and data modelling would be hugely beneficial as the role will involve heavy collaboration with a Data engineer.
• Certification or experience in Looker studio would be…