Description Position at Mindshare Worldwide Job title: Data Management and Reporting Executive Group: Mindshare Worldwide Client: Unilever Mindshare is a media services company that accelerates Good Growth for its clients. Our company values of energy, empathy and impact bind together our diverse global family of 10,000 people from every culture and with every specialist skill you can imagine. People at Mindshare create ideas and solutions that help not only our clients, but also the industry and the world. You can check out some of our people stories and client work and awards on LinkedIn or Instagram or hear about the company in the words of our own people 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, t here’s a wide range of options to suit everyone at all levels of your career. Our Values & Behaviours Our new values, of Energy, Empathy and Impact not only align with our Good Growth ambition but represent our commitment and dedication to our people, help ing them grow their careers, fostering creativity, embracing humanity, and changing the world. At Mindshare we are open to differe nce. We believe in being open and supportive of our people and all their differences to help them succeed. Be different at Mindshare and use your difference to shape the world through media. 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). The Ideal Candidate 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 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: 1. Data Management responsibility: 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’ 2. Reporting responsibility includes (but is not limited to) the following: • 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