Analytics & Reporting Manager

UNAVAILABLE; City Of London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading global agency is seeking a Looker Studio Analytics & Reporting Manager to create interactive reports for media investment performance. This autonomous role requires expertise in data visualization, especially using Looker Studio and strong analytical skills to work with large datasets. The successful candidate will engage with global clients while being offered extensive benefits and a hybrid work environment.

Benefits

Flexible working

Reflection days

Private medical insurance

Family-friendly policies

Local discounts

Work anywhere for up to 6 weeks a year

Qualifications

• Previous experience with large scale digital media campaign data.
• Certification or experience in Looker Studio is advantageous.
• Experience presenting complex analytics to non-technical audiences.

Responsibilities

• Design and develop Looker Studio dashboards.
• Collaborate with stakeholders to understand reporting needs.
• Provide documentation and user training on dashboard functionality.

Skills

Advanced Excel

Intermediate SQL

Data visualization principles

Understanding of media investment metrics

Excellent data visualisation and UX/UI skills

Familiarity with modern data stack

Project Management methodology

Comfortable presenting complex data

Tools

Looker Studio

PowerBI

Tableau

Google Analytics

Databricks

Snowflake

Funnel

FiveTran

Adverity

Job description

Company Description

We are the ROI agency, apositionwe haveproudlyheld trueto since 2005. Our more than 6,000specialistsacross95marketsofferunparalleledcapabilitiesinMedia,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 definitionof ROI, as it has changed with the ever- complicatedcommunicationslandscape.ROI isnolongersimplyaboutthemost efficient planning, buying and reporting of media.

Yes,ROIisaboutdeliveringReturnonInvestment;butit’salsoaboutgoingbeyondtodelivera

ReturnonImaginationandmoreintegratedexperiencesthatinspireGrowth.Top-linegrowth

forourclients’businesses,growthforourpeopleandgrowthforourculture.

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

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

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

Itmeansweadoptnewdataanalyticsandvalueoptimisationtechniqueswhilebuilding

relationshipswithsomeoftheworld’smostexcitingstart-ups.Weleverageover30yearsof 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,weultimatelyseekoutamoremeaningfulkindofROI. Ouruniquewayofthinking inspiresgrowth for some of theworld’s leadingbrands,includingCoty,Electrolux,Essity, Lactalis, Luxottica, Nestlé, Nomad Foods, Reckitt,TikTok and Verizon.

Job Description

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 Internationalhas fantastic benefits on offer to all of our employees. In addition to the classics,Pension,Life Assurance, Private Medical and IncomeProtectionPlanswe also offer;

• WORK YOUR WORLDopportunity 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 BENEFITS24/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 POLICIESWe 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 OFFYou are entitled to an additional day off for your birthday, from your first day of employment.
• GREAT LOCAL DISCOUNTSThis includes membership discounts with Soho Friends, local restaurants and retailers in Westfield White City and Television Centre.

Full details of ourbenefits 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 Pagewhich showcases our Inclusive Benefits and our EAG’s (Employee Action Groups).