Applications for this job are now closed
Our attitude is reflected in our core values of Empathy, Energy and Impact, 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.
The Role
An increasingly fundamental and differentiating capability for any marketing led organisation is the ability to control data and analyse it to create knowledge. Repeatable knowledge needs to be actively cultivated and re-applied across the business to help interpret granular analytics.
This brief is for the recruitment of an existing role within the ‘Team Unilever’ Data Management & Reporting Team based at the Mindshare Worldwide office in London.
As our client, Unilever is investing considerably in this area in a bid to ensure its marketing is visible, rigorous, and measured, and Mindshare is a key partner, playing a key role in the collection, reporting, and analysis of media and marketing data from over 70 countries.
The roles will report directly to our DQ (Data Quality) and Reporting leads, and will also work with the broader Unilever worldwide client team at Mindshare, local media agencies, and the Mindshare Technology Team. The immediate team is made up of 6 people (including this position).
About you
Precision, accuracy, and efficient management of data and reporting is the priority for an executive. You must demonstrate execution of agreed working practices and expert data handling & reporting skills. You need to be a confident but friendly communicator – in person, on the phone, and via email. Most importantly, enthusiastic, and eager to learn about the world of media.
Essential Criteria
- Strong attention to detail
- Desire to work with data combined with a passion for media and marketing
- Demonstrates a high degree of accuracy even when under pressure
- Organised and efficient with the ability to meet deadlines and manage multiple tasks
- Proficient in using Microsoft office programs such as Excel, Outlook, Word
- Someone who’s not afraid to speak up and give his/her opinion, with the ability to use, monitor and question data to deliver the best outcome
- Desire to work within a team environment, able to take direction from various members of the team and action accordingly
- Inventive: Diagnoses problems by identifying and understanding the cause of the problems
- Build relationships: Builds rapport with others in order to develop productive and effective relationships at work
- Initiative and Drive: Effectively prioritises multiple tasks; takes appropriate actions to avoid/manage issues
Desirable Criteria
- Does this person have an eye for detail?
- Does this person have the type of personality that contributes positively to the spirit of the team?
- Does this person have a passion for data and numbers, and a desire to unlock insights?
- Does this person go beyond the day-to-day job to explore new techniques and approaches?
- Do they have ‘star potential’?
Responsibilities
The Data Management and Reporting Team is set up as a dedicated team to manage the data quality and reporting requirements from various proprietary Mindshare systems and data sets used for reporting to Unilever. There are two primary focus areas for the role.
Data Management
the role is to sit in-between the local agencies (which are the source of data inputs) and the Technology team at Mindshare, to quality control all data. The role’s scope is to work with the local agencies to correct any issues at the source. This spans 2 key data sources [media investment and media budget recommendation]. The responsibility includes (but is not limited to) the following:
- Validating the local country media plans and ensuring they have been correctly formulated (timing, product, brands, campaign, media channel, advertising format etc)
- Validating each budget file is in the correct template, with the mandatory fields populated
- Ensuring that the budget file inputs and budget setting levels are aligned with the media investment data
- Cross-checking investment against previous months by Country, Category, and Local Brand in a validation logbook
- Distributing monthly Validation/Acceptance reports to all Mindshare country teams to have data corrected at the source
- Ensuring Local Mindshare teams work with local Unilever marketing teams to confirm correct campaign names are being used in MAP (Mindshare’s global media reporting system). DQ team will add new campaigns to systems where necessary.
- Educating the local Mindshare countries with the benefits of the system and responsibilities – aka ‘single source of truth’
Reporting
- Managing monthly production of KPI reports – excel based
- Understanding the data inputs, how they are defined, how it fits with the various reports and the purpose and objective of the report for end users
- Adhoc client/market/team requests to source information and address local/global client data sourcing and reporting requirements – this might include but not be limited to competitive advertiser analysis reports, case studies and media plan information requests
- Become familiar with multiple Mindshare-managed Data sets/media planning tools etc in order to support the above requests
- Collect and collate best practices and case studies from our local teams and share these across our network
