BI Developer, London

2 weeks ago

Wells, Somerset, United Kingdom Zenith Full time
BI DeveloperWood Lane, London, W12Company 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
Qualifications

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.

#LI-Hybrid

  • Analytics Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Zenith Full time

    Analytics ManagerWood Lane, London, W12Company DescriptionWe 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...

  • Strategy Director, London

    2 weeks ago

    Wells, Somerset, United Kingdom Spark Foundry Full time

    Strategy DirectorWood Lane, London, W12Company DescriptionSpark Foundry make up part of a thriving global media network and are part of the Publicis Groupe, one of the world's leading communications groups. We are globally connected with over 8,000 employees in 110 offices across 70 countries.Who We Are in the UK? Spark Foundry, the Acceleration Agency.We...

  • Commercial Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Commercial ManagerWood Lane, London, W12Company DescriptionPublicis Media is the world's second largest media agency network and part of the French communications group Publicis Groupe. As a global holding company, Publicis Media lives through its global agency brands Zenith, Starcom and Spark, which manage and continuously develop customer business in...

  • Global Business Development Manager, Operations, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Global Business Development Manager, OperationsWood Lane, London, W12Company DescriptionPublicis Groupe, known for its world-renowned creativity, best in class technology and data assets, and digital and consulting expertise, is one of the world's largest communications group in the world. With more than 100,000 people in over 100 countries, the Groupe has...

  • Motion Designer, London

    2 weeks ago

    Wells, Somerset, United Kingdom PGOne Full time

    Motion DesignerChancery Lane, London, Company DescriptionWe are PG ONE.We are the ideas, production and media for over 30 of the world's most known and loved brands from the world's biggest advertiser, P&G (Procter & Gamble).When you see Pampers, Gillette, Head & Shoulders, Fairy, Ariel, Always & Braun to name a few, that's us.We are made differently to...

  • Programmatic Account Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Zenith Full time

    Programmatic Account ManagerWood Lane, London, W12Company DescriptionWe 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...

  • Data Engineer, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Data EngineerWood Lane, London, W12Company DescriptionPublicis Groupe is a global leader in communication. The Groupe is positioned at every step of the value chain, from consulting to execution, combining marketing transformation and digital business transformation. Publicis Groupe is a privileged partner in its clients' transformation to enhance...

  • Project Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Project Manager101 Wood Lane, London, W12 7FWCompany DescriptionPublicis Groupe is one of the largest advertising agencies holding companies in the world and a global marketing, communications, and digital transformation leader. We utilise the Power of One operating model to integrate and develop competencies to increase business value for existing and...

  • Paid Social Director, London

    2 weeks ago

    Wells, Somerset, United Kingdom Zenith Full time

    Paid Social DirectorWood Lane, London, W12Company DescriptionWe 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...

  • Senior International Investment Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Senior International Investment ManagerWood Lane, London, W12Company DescriptionThe newly rebranded Investment & Accountability team sits as a key pillar within Publicis Media Exchange (PMX) and overall Commercial structure. We are growing with an exciting shift in both mission and culture.The team's holistic approach to Investment & Accountability feeds...

  • Campaign Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Digitas UK Full time

    Campaign ManagerChancery Lane, London, Company DescriptionAt Digitas, we harness the power of connection to make positive impact everyday. We have a relentless focus on creating connections to help our clients' businesses grow, connecting diverse people, ideas and expertise in innovative and exciting ways.We are making positive impact with our amazing...

  • Senior HR Advisor, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Senior HR AdvisorWood Lane, London, W12Company DescriptionPublicis Media helps clients drive sustainable business growth by harnessing the modern media landscape to drive one-to-one consumer connections at scale. Led by Niel Bornman, CEO, Publicis Media UK is made up of 2000 people working across market-leading media agencies including Zenith, Starcom and...

  • Client Solutions Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Client Solutions Manager101 Wood Lane, London, W12 7FWCompany DescriptionPublicis Media is the world's second largest media agency network and part of the French communications group Publicis Groupe. As a global holding Publicis Media lives through its three global agency brands Zenith, Starcom, Spark who manage and continuously develop their customer...

  • Reporting and Insights Manager, London

    2 weeks ago

    Wells, Somerset, United Kingdom PlatformGSK Full time

    Reporting and Insights ManagerWood Lane, London, W12Company DescriptionPublicis Media is one of the four solutions hubs of Publicis Groupe [Euronext Paris FR , CAC 40], alongside Publicis Communications, Publicis.Sapient and Publicis Healthcare. Led by Steve King, CEO, Publicis Media is comprised of five global brands, Starcom, Zenith, Spark Foundry, Blue...

  • Solutions Marketing Director, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    Solutions Marketing DirectorWood Lane, London, W12Company DescriptionPublicis Groupe is a global leader in communication. The Groupe is positioned at every step of the value chain, from consulting to execution, combining marketing transformation and digital business transformation. Publicis Groupe is a privileged partner in its clients' transformation to...

  • Lead QA Engineer, London

    2 weeks ago

    Wells, Somerset, United Kingdom Digitas UK Full time

    Lead QA EngineerChancery Lane, London, Company DescriptionAt Digitas, we harness the power of connection to make positive impact everyday. We have a relentless focus on creating connections to help our clients' businesses grow, connecting diverse people, ideas and expertise in innovative and exciting ways.We are making positive impact with our amazing...

  • AV Investment Director, London

    2 weeks ago

    Wells, Somerset, United Kingdom Zenith Full time

    AV Investment DirectorWood Lane, London, W12Company DescriptionZenith, we help brands make BOLD MOVES.Bold moves are big, brave changes to media strategy, delivering more impact for brands and more value for consumers.Bold moves are backed up with a solid forecast – they are a better path to growth.Bold moves build a partnership – we believe in this...

  • Account Director, Retail, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Media Full time

    Account Director, RetailWood Lane, London, W12Company DescriptionPublicis Media is currently leading the field and winning AMAZING clients (have you heard about us winning L'Oréal yet?)—there's never been a better time to join us We're fuelling business growth by harnessing the modern media landscape to create personalized consumer connections on a HUGE...

  • WIP Controller/Client Accountant, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Groupe Full time

    WIP Controller/Client AccountantWood Lane, London, W12Company DescriptionPublicis Groupe UK is a marketing and digital transformation business made up of 5,000 talented and versatile people with expertise in media, creative, influence, technology and data, working across 21 agencies.Publicis Groupe UK creative agencies include Saatchi & Saatchi, BBH,...

  • Account Director, TV, London

    2 weeks ago

    Wells, Somerset, United Kingdom Publicis Media Full time

    Account Director, TVWood Lane, London, W12Company DescriptionPublicis Media is currently leading the field and winning AMAZING clients (have you heard about us winning L'Oréal yet?)—there's never been a better time to join us We're fuelling business growth by harnessing the modern media landscape to create personalised consumer connections on a HUGE scale...