Reporting and Dashboards Analyst

Data, Analytics & Insight Leeds, Leeds


Description

Position at MediaCom

Hello. We are MediaCom.

We believe in People First, Better Results.

MediaCom unleashes brands’ growth by helping them See the Bigger Picture. This means that we apply our unique ‘Systems Thinking’ philosophy and technology to all marketing levers: media, message and data. As a result, we design communication strategies that deliver short term results and help brands build for the future.

As part of WPP, the world's largest marketing communications services group, and GroupM, WPP’s consolidated media investment management arm, we have access to the richest data, most robust benchmarks and most advanced capabilities in the market. This helps us provide comprehensive solutions to all marketing challenges.

Our success is underpinned by our long-standing ‘People First, Better Results’ belief. We know that by investing in our people’s whole-person wellbeing, careers and capabilities, we will help grow our clients’ businesses.

In 2020 this approach led MediaCom to be crowned Global Media Network of the Year by Eurobest and Festival of Media Global, in addition to being the most awarded agency at the WARC Media Awards.

MediaCom is one of the world’s leading media communications specialists, with billings of US$17.6 billion (Source: COMvergence, 2020), employing 8,000 people in 125 offices across 100 countries. Its global client roster includes adidas, Coca-Cola (TCCC), Dell, Groupe PSA, Hasbro, Mars, NBC Universal, P&G, Richemont, Shell, Sony, Uber and Walgreens Boots Alliance.

To find out more about MediaCom visit us here:  www.mediacom.com

Role Description

As a dashboard analyst in MediaCom Systems Technology, you will be working with Tableau, Google Data Studio and Google Cloud to build engaging, high quality dashboards that support our planning and investment teams.

Don’t be put off if you can’t use these tools yet. We will teach you.

Our dashboard analysts are responsible for designing, building and maintaining a wide variety of reports, from daily campaign tracking, to one-off custom builds for our clients. Dashboard analysts lead on data visualisation best practices and help to select and present appropriate metrics to ensure that MediaCom’s marketing campaigns are effective.

Initially, this role will focus on maintaining and running existing reports, before expanding with experience into report design and building new interactive dashboards, particularly in Tableau.

You will work closely with our data engineers to visualise the data sources that they supply, but the ability to work on raw data pipelines and to manipulate data in databses is also very useful.

You have an analytical mindset, a good level of mathematical and data handling ability and a passion for solving problems. Previous experience with Tableau is an advantage but we would invite applications from users of other dashboard software and from advanced Excel users. MediaCom will train you in transferring your skills into being able to produce web-based Tableau dashboards that display high quality, interactive data visualisations.

Key responsibilities

  • Maintaining existing dashboards and ensuring robust output
  • Working with dashboard users to ensure that reports are used and to expand our range of reports
  • Visualising large datasets for understanding by a non-technical audience
  • Recommending best-practices for data visualisation
  • Designing interactive Tableau dashboards
  • Progressing towards building custom dashboard solutions for MediaCom clients

Experience

Essential

  • 1-2 years in a reporting or dashboard building role
  • Advanced Excel user and/or experience building with a web-based dashboard platform
  • Logical, problem solving mindset

Desirable

  • Tableau
  • Google Data Studio
  • Experience with SQL
  • Building data processing scripts in R or Python
  • Experience of working with cloud databases, particularly BigQuery
  • Experience working with marketing and/or web analytics data
This is a rare and exciting opportunity to become part of one of the most innovative and progressive Media agencies in the world! As a core member of the team you will have opportunity to help define our product, work with, our industry-leading clients and the chance to build your career & your future the way you want it!

If you feel you have the skills and experience for this exciting and challenging role, we would love to hear from you!

Mediacom is proud to be an equal opportunity employer. We want applicants of diverse background and hire without regard to race, colour, gender, religion, national origin, ancestry, citizenship, disability, age, sexual orientation, or any other characteristic protected by law.