Analytics & Reporting Manager

BRAND: Zenith
Job Function: Technology
Location: London, United Kingdom
Experience Level: Intermediate
Workplace Type: Hybrid

Company description

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, TikTok and Verizon.

Overview

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.

Responsibilities

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

Qualifications

To be successful in this role you will need:

• Advanced Excel user (advanced string functions for data manipulation, array formulas, PowerQuery for data cleansing/transforms, PowerPivot 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/FiveTran/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 great but experience in mainstream BI tools such as PowerBI or Tableau is essential.
• Exposure to a form of Project Management methodology and PM Tools
• Previous experience in employing taxonomy for media investment reporting and assessing the consequential effects of non-compliance
• Understanding of Data visualisation principles
• Exposure to mainstream web analytics (Adobe Analytics, GA4) tools would be beneficial
• Comfortable presenting complex data analytics to a non-technical audience
• Strong knowledge of media investment metrics (e.g. CPM, CPA, ROAS, attribution, share of spend).
• Experience working with main digital media data sources (e.g., Google Ads, Meta, DV360, SA360, CM360, GA4).
• Excellent data visualisation and UX/UI skills to present complex data in a clear and engaging way.

Additional information

Zenith International has fantastic benefits on offer to all of our employees. In addition to the classics, Pension, Life Assurance, Private Medical and Income Protection Planswe also offer;

• WORK YOUR WORLD opportunity to work anywhere in the world, where there is a Publicis office, for up to 6 weeks a year.
• REFLECTION DAYS - Two additional days of paid leave to step away from your usual day-to-day work and create time to focus on your well-being and self-care.
• HELP@HAND BENEFITS 24/7 helpline to support you on a personal and professional level. Access to remote GPs, mental health support and CBT. Wellbeing content and lifestyle coaching.
• FAMILY FRIENDLY POLICIES We provide 26 weeks of full pay for the following family milestones: Maternity. Adoption, Surrogacy and Shared Parental Leave.
• FLEXIBLE WORKING, BANK HOLIDAY SWAP & BIRTHDAY DAY OFF You are entitled to an additional day off for your birthday, from your first day of employment.
• GREAT LOCAL DISCOUNTS This includes membership discounts with Soho Friends, local restaurants and retailers in Westfield White City and Television Centre.

Full details of our benefits will be shared when you join us!

Publicis Groupe operates a hybrid working pattern with full time employees being office-based three days during the working week.

We are supportive of all candidates and are committed to providing a fair assessment process. If you have any circumstances (such as neurodiversity, physical or mental impairments or a medical condition) that may affect your assessment, please inform your Talent Acquisition Partner. We will discuss possible adjustments to ensure fairness. Rest assured, disclosing this information will not impact your treatment in our process.

Please make sure you check out the Publicis Career Page which showcases our Inclusive Benefits and our EAG's (Employee Action Groups).