Ad Ops Reporting Analyst
IPG Mediabrands
London, United Kingdom
6d ago

ABOUT US

Mediabrands UK was founded by Interpublic Group in 2007 to manage all of its global media-related assets. Today we manage and invest $36 billion in global media on behalf of our clients, employ over 7,500 diverse and daring communication specialists worldwide and operate our company businesses in over 130 countries.

A proven entity in maximising media investments and business results, the IPG Mediabrands UK umbrella includes local agencies UM London and Initiative UK, and its roster of speciality services including Orion, Rapport, Magna Global and Mediabrands Digital (Cadreon, Reprise Media, Ansible and Mediabrands Social).

In the UK we manage and invest over £1 billion for some of the country’s largest companies and employ over 450 people in our St.

John’s Square headquarters in Clerkenwell, the creative heart of London.

ABOUT THE ROLE

We are seeking an experienced Reporting Analyst to work alongside the Ad Ops Reporting Team Lead to run campaign reports across our clients.

The successful candidate will be an integral part of a data lead team and would come from a data driven campaign background.

We build client dashboards in Tableau (plus tools such as Datorama and Adverity), modelling a wide variety of media marketing data from ad servers, to ad tech, audience verification and client site analytics (and more!).

We work with account teams and client teams across the three IPG agencies here : UM, Initiative and Reprise. Clients include : The Economist, UPS, GoPro, Fitbit, Rockstar Games, Carlsberg and Lego plus more.

Currently a team of four and collaborating closely with the Digital Tech Team within AdOps and Cadreon, our programmatic team.

KEY TASKS AND RESPONSIBILITIES

  • The role is to support the digital team with all aspects of day to day reporting and analytics
  • Create and update client weekly and monthly reports based on existing templates or building new to a brief.
  • Working with large consumer data sets, focused on quality and compliance, with an ability to match and make sense of information from disparate sources
  • Understand valuable metrics and report structure, establish report processes, and identify data discrepancies and errors
  • Test and evaluate data accuracy for different datasets both within DCM and in external data sources
  • Data analysis (ability to spot trends, garner insights and use the data to make forecasts or predictions for campaign activity to help us provide the best service for our clients)
  • You will use ETL tools, spreadsheets and database tools to manipulate large quantities of data to create and combine insightful and automated reports to identify trends, relationships, and discover root causes of business outcomes
  • Use BI tools to design and build dashboards, along with visualizations, to show trends, patterns, relationships and analyses with clarity to deliver impactful insight
  • You will need to be an advanced Excel user, confident with most common formulas and know your way around Pivot Tables
  • Use verbal and written interpersonal skills to deliver analytical observations and recommendations to business owners and leadership.
  • You will communicate your findings in a concise, yet informative manner, to provide a strong data-centric basis for strategic decision-making

    ABOUT YOU

    We are seeking a personable, well organised candidate who is looking to develop their reporting skills and career. You will have an obsessive eye for detail and desire to optimise and automate where possible.

  • Entry level experience / or knowledge of marketing campaign reporting; understanding of terms such as, Impressions, Clicks, CTR, Spend, Visits, Viewablity, Conversions;
  • High level of numeracy with a particular ability to analyse and interrogate numbers;
  • Knowledge of Power Pivot, SQL, DAX, R, Atleryx and Tableau would be an advantage;
  • Joining multiple data sources;
  • Take pride in flawless execution, accuracy and attention to detail;
  • Strong relationship builder with team and other departments;
  • Ability to think on their feet, be proactive and take ownership of projects;
  • Ability to balance the need for strategic thinking with the need to deliver and get things done;
  • Flexible and open minded;
  • Ability to multi-task;
  • Strong desire to learn & to develop your media skills;
  • Excellent verbal and written skills;
  • Understanding of overall marketing functions, integrated communications and communication channels;
  • Strong desire to grow their knowledge base and skill set and take on new challenges
  • Competent in Excel, PPT, Word and Outlook. Knowledge of all relevant media research / tools available desirable (e.g. Viewability IAS / MOAT, Nielsen, comScore etc.);
  • THE PERKS

    We guarantee that your career with us will be varied and exciting. Every day in this fast-paced environment presents a different challenge and if you work smart and are the best at what you do, your time here will produce endless possibilities for your future.

    You will get our support in developing your skills at every step of your career journey with us. Your manager will help you create a tailored career path and through our in-

    house experts, and online performance management and learning and development tool, you will have access to a wide range of internal and external courses.

    In addition to this, there are always plenty of internal sessions on the latest developments in the industry, e-learning courses, bite-

    size learning sessions and on the job training and development.

    We aim to provide all of our people with a supportive and fun work environment where you can develop your full potential and benefit from the broad range of opportunities within the agency both in the UK and globally.

    When you join us, we want to make sure you feel valued and that you are rewarded for your fantastic work. So we also offer a range of benefits :

  • 25 days annual leave
  • In addition to your annual holiday entitlement, the office closes between Christmas & New Year
  • 3 days off per year for charity work
  • Subsidised monthly massages
  • Group Income Protection after 2 years
  • Life Assurance
  • Enhanced family friendly policies
  • Group Personal Pension Plan with matched contributions from 2% to 6%
  • Free breakfast
  • Early finish Fridays (4.00pm)
  • Independent mortgage advice
  • Free eye tests
  • Regular Bar Night
  • Retail discounts
  • Employee Assistance Programme
  • Interest-free season ticket loan
  • Wellbeing programme
  • Plus a huge number of flexible salary sacrifice benefits including private medical Insurance, health screening, childcare vouchers, cycle to work scheme, GymFlex, and many more!
  • www.ipgmediabrands.co.uk /

    Apply
    Add to favorites
    Remove from favorites
    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form