Data Quality Apprentice (a Creative Pioneers 2 apprenticeship)
This listing has expired
The Mindshare Unilever team is looking for a Data Quality (DQ) apprentice to join the team. The Data Executives will work as part of a new team and be responsible for coordinating data collection and harmonisation across a number of data sources, countries and templates for analysis and reporting.
Monday-Friday, 9am – 5pm
Total hours per week: 35.00
Possible start date
01 Feb 2018
14 Dec 2017
Higher Level Apprenticeship
The Data Quality Team is being set up as a dedicated team (separated from reporting) to improve the data accuracy of various systems and data sets used for reporting and delivery to Unilever. The inception of this group is in part due to the change of scope and structure within Unilever, and their strategic requirements for data, but also an appreciation of the role data plays in the planning, implementation and reporting of marketing activities. There are circa 30 countries across 3 data sources with circa 20+ fields to validate requiring a staff of 4 executives to manage on a day-to-day basis.
The main objective of this role is to sit in-between the local agencies and the Technology team at Mindshare’s data management process, to sign off on all data inputs. The role’s scope is to work with the local agencies to correct any issues at source. This spans 3 key data sources [media investment, budget recommendation and funding performance]. The role includes (but in not limited to) the following key roles & responsibilities:
Validating the media plans and ensuring they have been properly populated (flights, product, brands, campaign, media channel, unit length, etc.)
Validating each budget file is in the correct template, with the mandatory fields populated
Aligning the budget file inputs and budget setting levels are aligned with the media investment data
Cross checking investment against previous months by Country, Category, Local Brand in a validation logbook
Distributing monthly Validation/Acceptance reports to all Mindshare markets to have data corrected at source
Ensuring Local Mindshare work with local UL marketing teams to confirm correct campaign names are being used in CSI (Mindshare’s global media reporting system). DQ will add new campaigns to system where necessary.
Educating the local Mindshare countries with the benefits of system and responsibilities – aka ‘single source of truth’
The client is highly detailed oriented with a fast-paced business model. Precision, accuracy and efficient management of data and reporting is the priority for an executive. You must demonstrate faultless execution of agreed working practices and expert data handling & reporting skills. This includes but is not limited to the following:
Building relationships with the local agencies, the client leadership team, the consulting leads, and technology counterparts.
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.
Specific performance objectives, measures and a personal development plan will be agreed with and then appraised by your line manager but will include:
Accurate provision of data for reporting within the service level agreements relating to accuracy and deadlines.
Personal recommendation/ feedback amongst client, partners, peers and team members.
Some areas that any potential candidate will be evaluated include but are not limited to the following:
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’?
Requirements and prospects
Dynamic self-motivated team-player who approaches challenges in a proactive and flexible manner
An interest in data coordination, management, manipulation and visualisation skills
Excel skills desired (ability to build Pivot tables, SumIfs, Named Ranged, Lookups, Filters, and Graph data)
Strong spoken and written communication skills are needed for this role
Curious and connected: Exploits available tools fully to achieve efficient results; aware of alternative technologies that may benefit; learns from colleagues and shares knowledge with others
Inventive: Diagnoses problems by identifying and understanding the cause of the problems
Create Client Bonds: Understands what the client wants and why by actively listening and clearly articulating a solid understanding of the Client’s objectives, their services, capabilities, strengths, weakness, objectives etc
Build relationships: Builds rapport with others in order to develop productive and effective relationships at work
Initiative and Drive: Effectively prioritise multiple tasks; takes appropriate actions to avoid/manage crisis
A minimum of 5 GCSEs (or equivalent qualifications) at grade C or above including English and Maths.
Ongoing employment at this or another agency or progress onto a higher level qualification.
Things to consider
Please list ALL qualifications you currently hold (or are awaiting results for) accurately and comprehensively, including subject name and level as appears on certification. If – after being offered a position – you are found to have deliberately omitted or inaccurately listed qualifications that make you ineligible for the apprenticeship (e.g. previous training in the same modules) you will be in breach of your contract with Creative Pioneers2 and we reserve the right to either re-advertise the role or offer to an alternative candidate.
REGISTER YOUR CV