EMX | Business Intelligence Manager

IT & Technology London, England


Description

Position at EssenceMediacom

About EssenceMediacomX

EssenceMediacomX, part of GroupM, is a global data and measurement-driven media agency whose mission is to make advertising more valuable to the world. Our office sits within the legacy Essence building on Oxford Street. We still have all our wonderful essentials looking after our amazing clients! Our clients include many exciting brands such as Google, ITV, Airbnb, BT/EE, NBCUniversal and L’Oréal to name a few.

Visit www.essencemediacom.com for more information!

About the role

This role forms part of a globally distributed business intelligence team, whose objective is to ensure that our clients and internal teams have access to the right data and insights to inform their marketing decisions.

The team’s primary responsibility is to maintain a global reporting solution, which automates the collection and transformation of disparate marketing data into a single source of truth.  Not only does that mean running and maintaining the platform that already exists, but also continually improving it to incorporate new data sources, and to derive new insights, to support ever-evolving business demands.

As a BI Developer your primary responsibility will be to create and maintain data models and views and reporting templates, to help teams make sense of the underlying data, and to understand the true performance of their media campaigns. You will also act as the primary point of contact for a subset of users, gathering their evolving needs and supporting them in the use of the solution.

Some of the things we’d like you to do:

  • Help document user requirements, and support their incorporation into a central development backlog for prioritization
  • Within development sprints, be responsible for planning and developing solutions for prioritized requirements to deliver ongoing improvements within the Data visualization layer
  • Work with account leadership to understand and track the reporting needs for upcoming campaigns and marketing programs
  • Lead the creation and weekly refresh of campaign-specific instances within the reporting solution, often requiring coordination of dependent tasks across disciplines and/or geographies
  • Support members of the team tasked with maintaining the underlying data infrastructure by troubleshooting data issues and running scheduled tasks
  • Ensure users have the necessary skills & knowledge to use the reporting solution, including helping maintain training materials and knowledge base
  • Be the first-line of support for users, triaging queries as they come in, providing them with hands-on support where possible, and connecting them with other disciplines and experts when necessary
  • Identify opportunities to improve supporting cross-discipline processes, and work with others to make them a reality
  • Work with the data platform engineering team to enhance the product capabilities

A bit about yourself:

Required

  • 1-2 years experience in a data or technically-oriented marketing role, preferably at a media agency or related company (e.g. publisher, ad tech, client marketing org)
  • Familiarity with digital marketing platforms and the data they generate, in particular Google Marketing Platform (DV360, SA360, Google Ads), Meta, Snap, etc.  Knowledge of their API’s a plus
  • An understanding of how data is tracked and exchanged in the process of digital advertising (e.g. role of ad servers and other third-party tech vendors)
  • An understanding of how media performance should be measured, and experience using different methods to visualize performance and to tell stories with data
  • Track record of querying data and developing effective reporting solutions using SQL
  • Some experience using or building reports with business intelligence software, ideally Google Data Studio and Looker
  • Analytically minded, enabling you to understand and overcome technically complex challenges
  • Strong organizational skills and attention to detail, allowing you to bring structure to otherwise unstructured situation
  • Strong spoken and written communication skills, ensuring your thoughts and needs are heard and understood
  • Can-do attitude, with an ability to multi-task and remain calm and composed under pressure
  • Exude positivity and energy, and you can thrive in a fast-paced and dynamic working environment
  • Work best in team environments, and you are a beacon of collaboration

Desirable

  • Experience project managing the delivery of technical solutions, including exposure to agile product development methodologies
  • Experience building underlying data pipelines and ETL, particularly useful if done using Google Cloud Platform, Airflow, DBT etc.
  • Knowledge and experience using other programming and/or statistical languages (e.g. Python, R, etc.) 

What you can expect from EssenceMediacomX

EssenceMediacomX’s mission is to make advertising more valuable to the world. We do this by employing the world’s very best talent to solve some of the toughest challenges of today’s digital marketing landscape. It’s important that we hire people whose values reflect those of our own: genuine, results-focused, daring and insightful. As an EssenceMediacomX employee, we promise you a workplace that invests in your career, cares for you and is fun and engaging. We believe these factors create a workplace where you can be yourself and do amazing work.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, colour, national origin, gender, sexual orientation, age, or marital status.