Data and Tech Manager, Measurement & Reporting

IT & Technology London, England


Description

Position at Mindshare Worldwide

Data and Tech Manager, Measurement & Reporting

Job title: Data and Tech Manager, Measurement & Reporting

Group: Mindshare Worldwide

Client: Multiple

Reports to: Business Director

 

Mindshare is global media agency designed to make media exciting, fun and life changing. For the last 20 years our values of Speed, Teamwork and Provocation have guided our 10,000 people who work with some of the world’s best brands and companies. Located in 116 offices across 86 countries, we are the largest media agency in GroupM, WPP’s media investment management arm, which is the #1 media holding group globally. Mindshare Worldwide is the headquarters for Mindshare based in London. We are a team of 400+ people, co-ordinating media campaigns for our global clients. 

Learn about our culture and values and meet some of our people here.

Want to see some of our award-winning work? Click here

What We Can Offer You

At Mindshare Worldwide, we offer a competitive salary package, with 25 days holiday increasing with service to a maximum of 30 days, with the option to buy an extra 5 days per year. We also have an enhanced pension scheme, Bupa healthcare, a monthly wellbeing fund and early finishes on a Friday during summer. These are just some of the great benefits we offer.

Based ten minutes from London Bridge tube station, our office has a rooftop with 360 views of London – a great space to hang out with colleagues and friends!

We also offer an extensive training programme to help guide your career development whilst you’re with us. There’s a wide range of options to suit everyone at all levels of your career.

Our Values & Behaviours

Our attitude is reflected in our core values of Speed, Teamwork and Provocation, which drive our people and our business.

We want Mindshare Worldwide to be a place where everyone feels that they belong, everyone can be themselves and everyone has the same opportunities to develop their careers. Over the last 12 months we have made important steps in progressing on our journey to a truly inclusive organisation. We have launched The Collective and have seen the birth of a range of Employee Resource Groups who have shown some amazing and inspiring work.

Our Commitment

We are committed to making reasonable adjustments wherever necessary. If you require this document in another format, such as large print or audio, please contact Ellie Macdonald ([email protected]).

Mindshare Worldwide commit to providing assistance for candidates who have successfully secured an interview and may require reasonable adjustments. We will work with the interviewee to establish what additional support is required and where possible, ensure reasonable adjustments are implemented to support a successful interview.

The Role

We are looking for someone to champion media measurement within Mindshare Worldwide. Someone with experience in, and passion for digital media, measurement and reporting and big data, who wants to work with some of the biggest brands in the world.              

The role is a blend of consultancy, operational excellence, and technical ability with a solid understanding of the practical realities of what it takes to measure the right thing.

We are looking for someone who can work with people from different disciplines as and when required, to deliver best in class solutions for our clients.

Someone who has solid technical skills, who can understand how KPIs and metrics should be reported on, at both global and local level, as well as what insightful stories and trends can be told from readily available data.

The Ideal Candidate

Essential Criteria

  • Technical mindset, able to approach issues and challenges from a variety of angles.
  • Highly numerate, with strong mathematical acumen.
  • Advanced experience using Excel and the Microsoft Power BI suite. Including Power BI Desktop, Power BI Service, Dataflows, Power Query and DAX.
  • Build global reporting solutions to easily translate complex data points to digestible information by using visualisation tools such as PowerBI, Tableau, Looker or Google Data Studio.
  • An eye for visual representation of data via dashboards and excel builds.
  • Experience of managing Microsoft SQL Server databases, writing SQL queries, and Analysis Services, ideally with experience of SSIS
  • Experience with building and maintaining ETL/ELT pipelines (e.g. dbt) and cloud infrastructures (e.g. AWS, GCP), along with modern data warehousing technologies (e.g. BigQuery, Snowflake).
  • Ability to perform data transformations requirements and manipulate data in various ways.
  • Basic understanding of Python.
  • The ability to achieve high quality results by paying attention to detail.
  • The ability to work on multiple tasks/projects and meet agreed deadlines.
  • A natural desire to share knowledge and teach others.
  • Strong verbal and written communication skills.

 

Desirable Criteria

  • Understand of the latest digital media platforms, including, but not limited to YouTube, DSP, Google Ads, or Facebook
  • Understand onsite analytics such as, Google Analytics, Adobe Analytics

 

Responsibilities

Help set requirements and build globally scalable digital reporting solutions. Key tasks include:

  • Ensuring the data requirements are captured and continuously updated, to meet a fast pace changing environment.
  • Working to understand technical requirements and translating to a meaningful way back to the team/markets/clients.
  • Acquire, ingest, and process data from multiple sources and systems into required data warehouse platforms
  • Manage and monitor the data integrity across sources
  • Work on projects within the cloud ideally Snowflake, AWS & Azure
  • Build operational ETL data pipelines across several sources, and construct relational and dimensional data modelling
  • Set-up and management of data dictionary requirements.
  • Development and updating of any training material providing knowledge sharing of system usage and reporting requirements.
  • Keep up to date with tools and technology available for improving reporting requirements and communicate with the wider teams.
  • Provide hands-on support for all data related activities within the BI Team.
  • Resolve day-to-day issues autonomously, escalating where appropriate.
  • Ensure a high level of data compliance across all data sources.

 

 

Graphical user interface, textDescription automatically generated