BI Developer
Wood Lane, London, W12

Company Description

We think big. And act bigger. Stay versatile and interconnected. We approach everything with an inventive spirit and rigorous mindset. Individually we’re great, but as a team we’re unstoppable. Together, we seek out opportunities, frame problems and solve complex challenges. Our collective brilliance exposes breakthroughs. Our capability unleashes creativity. We pursue a new perspective and deliver a new kind of ROI.

Zenith Global are the central team, primarily based in London, supporting our local Zenith markets, leading new business efforts, developing thought-leadership, and driving network development for our 250 offices across 95 countries with over 8,000 staff worldwide.

We house a large team of multi-faceted communications planners, digital and innovation specialists and client leadership teams. Our global client portfolio comprises a range of category leaders including Reckitt, TikTok, Edrington, Coty, Electrolux and Nestlé.

Our Commitment
At Zenith Global, we believe that fostering an inclusive culture where all talent can thrive makes our company stronger and help drive invention in the work we do for our clients better. We also believe it enables a greater idea exchange that fuels innovation and best reflects diverse consumer experiences.

We are committed to encouraging our talent to participate in Publicis Groupe’s wide variety of talent engagement and inclusion programming, which includes professional development experiences and participation in the company’s many business resource groups. These include VivaWomen!, Égalité, MOCA (Men Of Colour Alliance) and more than a dozen others that are thriving across our network.

Through advocacy, education and inclusion we foster greater collaboration among our people, which in turn inspires work that provides better experiences for our clients and their consumers.

Job Description

This is a key role that will elevate ZWW’s analytics capabilities to be truly agnostic of BI tool and will democratise data for all within the agency.

The BI Developer is a new and vital role that will escalate ZWW’s analytics capability in automating repetitive workflows for an existing team of analysts, building automated reporting solutions on a modern analytics stack, and supporting Publicis Enterprise Analytics platform.

The BI Developer role will be responsible, but not limited to the following:

  • Lead the development of the Open Titan model of BI/Automated reporting (stack based on Funnel, Azure, Snowflake, BI tools be determined by client needs budge).
  • Liaising with Data Engineering to build data streams from client advertising platforms.
  • Design and build of internal analytics datamart for Luxury goods client
  • Act as a support to Senior BI Developer supporting Zenith WW’s existing BI projects


To be successful in this role you will need:

  • Advanced technical knowledge in PowerBI
    • aggregation tables/user-defined aggregations
    • incremental refresh
    • row level security
    • embedding
    • DAX
    • data model design
    • data extraction
    • power query
    • performance tuning
    • dataflow and data mart
  • Hands-on experience with enterprise business intelligence solution data modelling, data mart, and data warehouse development
  • Exposure to Snowflake: building stages, creating schemas and scheduling tasks would be a distinct advantage
  • Understanding of ETL/ELT best practices
  • Exposure in some form of Project Management methodology, existing team work to a version of agile
  • Understanding of Data visualisation principles and exposure to common data visualisation tools would be useful (Tableau, Power BI, Looker)
  • Experience working with large scale media campaign data and familiarity with media language would be a distinct advantage


Additional Information

Publicis Groupe operates a hybrid working pattern with employees being office-based on Mondays and two other days during the working week.

If you have any adjustment needs arising from a disability or medical condition to fully participate in the recruitment process, please discuss this with the recruiter who contacts you.


Before you apply -
Register now and turn on alerts for jobs like this!

By registering you agree to our terms and conditions.

No thanks, continue to apply