BI Developer (Director)

  • Full-time

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

Job Description

This is an opportunity to work with one of the world's finest global technology firms in a freshly formed team dedicated to delivering the greatest digital marketing in the world. It is an interesting, dynamic, and diverse workplace in which to manage significant budgets and learn from the top practitioners.

We are looking for someone who can come in and immediately make an impact. You exude confidence and are able to motivate, educate and aid the development of other members of the team in London and India. Whilst the successful candidate will be well supported, it is expected that they should be able to ‘hit the ground running’, and for the most part be able to manage their team autonomously.

Key Roles & Responsibilities : 

  • Support the development of the Adobe.pub model of BI/Automated reporting (stack based on Funnel, Azure, Snowflake, BI tools to be determined by Publicis and Adobe) with Global CoE in the US
  • Liaising with Adobe.pub Data Engineering teams to build datastreams from advertising platforms which may need a bespoke or specific connection.
  • Design and build of internal analytics datamart for Adobe.pub team to democratise access to analytics data for team to be able to analyse media fast
  • Act as the lead Business Intelligent developer to capture, define and fulfil Adobe dashboard requirements
  • Together with Analytics director ensure the collection of clean and accurate data
  • Ensure clean data is piped from Adobe.pub into Adobe internal systems and tools working with the Global Adobe.pub CoE team
  • Be the day-to-day technical lead contact across a number of clients for internal account teams, to lead on any technical client questions/requirements.
  • Actively participate in weekly meetings with the client and internal team.
  • High level of time management to be able to work across variety of projects at the same time.

 

Qualifications

  • Advanced technical knowledge in PowerBI
    • aggregation tables/user-defined aggregations
    • incremental refresh
    • row level security
    • embedding
    • DAX
    • datamodel 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 architecture
  • 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
  • An 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

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.
 

#LI-Hybrid

Privacy Policy