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

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

As the BI Developer you 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).

·       Liasing with Data Engineering to build datastreams from client advertising platforms.

·       Design and build of internal analytics datamart for Luxury goods client

·       Act as a support to Senior BI Architect supporting Zenith WW’s existing BI projects

To be successful in this role you will need:

·       Advanced technical knowledge in PowerBI

o   aggregation tables/user-defined aggregations

o   incremental refresh

o   row level security

o   embedding

o   DAX

o   datamodel design

o   data extraction

o   power query

o   performance tuning

o   dataflow and data mart

·       Hands-on experience with enterprise business intelligence solution data modeling, data mart, and data warehouse architecture

·       Exposure to Snowflake: building stages, creating schemas and scheduling tasks would be a distinct advantate

·       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

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.