BI Analyst

Data, Analytics & Insight
London, England



DiagramDescription automatically generated with medium confidenceLogoDescription automatically generated    






BI Analyst (Sky & Boots)     


If you require any adjustments or additional support during the recruitment process, for any reason whatsoever, please let us know at [email protected]     


At EssenceMediacom we want to eradicate inequity. We don't tolerate it and when we see it, we act. We attract, support and develop our talent without bias and strive to foster the empathy, creativity and diversity of thought needed to drive meaningful change for our people, our clients, our industry and our society. WPP and GroupM have already made strong commitments to combat racial injustice. While we are part of this group, we know we have an individual responsibility as an employer and an industry leader to fight against racism. That’s why we have pledged the following seven commitments.    


Even if you don’t meet all the requirements, that’s okay, and we encourage you to apply anyway to find out more about whether this is the right match for you.    


Did you know that marginalised groups including women, people of colour and people with a disability are more likely to discount themself for a role if they don't feel they meet every requirement or understand the reasonable adjustment that can be made? This is why we encourage connection and conversation to ensure that everyone has the opportunity and information needed to find the right role, for them. If this role isn’t quite right, you may be the perfect fit for another – so go ahead, apply and find out!    




The Client     




Sky are one of the biggest advertisers in the UK and as a business span Entertainment, Sport, Cinema, Home Insurance, Broadband, Mobile and B2B services to mention a few verticals. We work closely with them across their digital strategy and manage the planning and buying across Display, Paid Social and Programmatic.     


Working on Sky is a challenging, fast-paced and innovative environment where standing still can be moving backwards! We’re here to help Sky navigate a constantly changing digital ecosystem and to create award winning work that grows their business.     




Boots are one of the biggest retail clients in the UK. Their divisions span across Retail. No7 Company, Opticians and Hearingcare.     

Boots are an award-winning data-driven organisation. Working on Boots is a challenging and fast-paced environment, where you will be exposed from day 1 to leading technologies and data-driven strategies, delivered across a wide range of media implementations.     



The Role    


As a lead consultant within the data tech and analytics team, dedicated to two of our biggest clients, you will be expected to drive and lead the BI/engineering capability within that team, in development and automation of data solutions for clients. This is a hands-on role and you will be responsible for developing pipelines to helping us aggregate many data sources into a single view for the two clients. You will sit in a data/tech and analytics team, which is dedicated to our two largest clients, however you will also be part of the BI/engineering central community.      


Marketing industry data is often incomplete, inconsistent and stored in silos with access primarily through APIs and FTPs. It is therefore our responsibility to help create custom solutions for these two clients, who each have their own requirements for reporting. We need a creative, experienced and motivated individual to help lead this area within the team, building solutions for integrating data in to the GCP & BigQuery environments.    



What we think are 3 best things about the job..    


  1. You’ll have access to the latest and greatest in cloud and dashboarding technologies.
  2. Continuous learning, autonomy & room for development with the best in the industry.
  3. You’ll be working in a close knit, friendly team who are there to support you at every stage of your career.



Who are you?    


You have extensive experience of working directly with clients and managing stakeholder expectations, having already been in a client-facing role previously, and are able to effectively engage with clients both from technical and non-technical disciplines.     


You have Cloud platform knowledge, hopefully with a GCP certification, or alternatively other Cloud platform knowledge would be considered. You have significant experience working with Python (R desirable).    


Experience in:    

-          Building pipelines from various data sources and especially APIs    

-          Experience querying databases using SQL    

-          Line management    

-          DevOps tools: Github/Gitlab    

-           Working with digital marketing and/or web analytics data    


What we can offer you.    


-          Company pension scheme     

-          Private medical insurance     

-          25 days holiday (increases with length of service)    

-          Life assurance    

-          Permanent health insurance     

-          WPP share options scheme     

-          Discretionary bonus scheme     

-          Free eyecare vouchers and money off glasses    

-          Extensive training and development     

-          Corporate gym memberships    

-          Cycle to work scheme    

-          Interest free travel loan    

-          Free breakfast (cereal and fruit)    

-          Smart shopper (online discount on a variety of products)    


Sounds good? We’d love to hear from you!    



About EssenceMediacom    

We are a global communications agency leading with breakthrough thinking, building explosive growth for brands, and helping our clients see the bigger picture. Our daring global network of 10,000 influencers help our clients breach traditional boundaries in media, uncover novel ideas, and unleash exponential growth. EssenceMediacom challenges conventional thinking to build, propel, and supercharge our clients’ businesses at scale and lead our industry in critical areas such as diversity, equity, inclusion, and sustainability.      

EssenceMediacom understands that our people are tasked with big goals: building breakthrough growth for brands and leading with breakthrough thinking in our industry. Our people are at the heart of this work because their ideas will enable us to decode the intersections of people, content, and technology to bring our aspirations to life. Our success is down to our eclectic, diverse, and talented people. EssenceMediacom is a place for us to grow our careers and expand our horizons. EssenceMediacom is committed to building an agency culture that supports our people, puts diversity at the forefront of our operations, and creates opportunity for all. This collective culture will be our “new power” where ideas are freely exchanged, and collaboration is actively encouraged in a place where you can innovate in our hyperconnected world.      




Share This Job