Data Selector (6 Month Fixed Term Contract)

ABOUT RAPP 

We stand up for individuality. We actively foster an inclusive workplace where diversity and individual difference are valued and leveraged to achieve the agency’s vision. And most importantly we value every individual’s wellbeing.  

As a diversity champion, equal opportunities and disability confident employer and an ardent advocate of flexible working we understand that everyone has unique requirements and needs.

We are a global creative agency, but the individual really is at the heart of everything we do. We use data to find out what makes them tick. We use technology to talk to them one-to-one – but to one million at a time. And we use creativity to encourage them to engage, click, buy and bond, again and again.  

Each brand is unique and has its own individual challenges. We pride ourselves in rising to each and every one of them, for brands such as KFC, Mercedes Benz, IKEA, PayPal and Virgin Media 02.

 

Us

To foster collaboration and relationships, our hybrid model requires three office days per week. As equal opportunities proponents, we are open to discuss any hybrid working related needs during the initial screening.

The Health and Wellbeing of our people matters immensely to us at RAPP which is why we work with Sanctus (mental health partner) and Sayge (professional development), to offer personal and professional support coaching for all our Employees. We also have a dedicated Learning and Development team and offer regular career conversations and bespoke L&D programmes so that you can leave us with more than when you started.

We recognise that the work of diversity, equity and inclusion calls on all of us. That’s why we set up The Neighbourhood. A collective of people, at different stages of the DE&I journey, whether impacted or allies, dedicated to helping our colleagues take ownership and effect change across 4 key pillars; Anti-racism, Disability, Gender & LGBTQ+ and Parents & Carers.

You’re better at work when you feel better in yourself.  So, in addition to your annual holiday, you can take a “Me” day and an “Us” day, every year. Your “Me” day is for you to invest in yourself – go after a life goal, meditate, learn to paint, bake cakes or just have a duvet day watching Netflix!

Your “Us” day is all about giving back and helping others – volunteer, pick litter at a local park, hang out with the elderly or raise money for a local charity.

Whatever stage of life you are at, we make sure you have the tools you need to have a healthy work life balance.

 

The Opportunity

• You’ll get to work on one of the largest accounts in the agency, BBC TV Licensing, that provides funding for the BBC to make amazing content – from TV and radio shows to Bitesize and podcasts
• Part of the account’s uniqueness is that the BBC has outsourced its whole marketing function to RAPP. So, not only do we get to lead the marketing objectives and strategy that drive real behaviour change. But we also manage the implementation of that strategy all the way through to selecting the data / briefing the media agency to delivering the creative (across multiple channels) and analysing performance. 
• You’ll be joining a large (50+ people) group of talented and supportive team members dedicated to TVL plus the wider agency creative teams. Oh, and we’ve won quite a few awards for our work too! 
• Data, insights and performance is at the heart of what we do, and you’ll be working across data strategy including segmentation, UX, Customer Experience strategy, loyalty and creative. TVL is a fantastic account to learn or hone your skills in delivering effective, end to end customer journeys. 
• You’ll get monthly one to one with your manager just to talk about your objectives and how you are continually developing.

 

The Role

We are looking for a bright and confident campaign selections analyst to join the team.

This is a challenging yet rewarding role that sits within the Data Selections Team. This unique role bridges the gaps between Marketing, Data Planning, Analytics and Operations and offers great exposure to all areas of the account on a day-to-day basis.

An opportunity has arisen in the team for a fixed-term contract role due to additional resource being needed to support the team on several new and complex projects.

The successful candidate will assist the team in the end-to-end delivery of all Campaign Selections whilst ensuring everything is delivered accurately and on time to a very high standard. The role would suit someone who is eager to learn, comfortable working under pressure, organized and who has a keen eye for detail.

There will be ample opportunities to learn new tools and technologies, undertake project work and a variety of ad-hoc reporting.

 

Responsibilities

The Campaign Selections Analyst’s primary responsibilities will be:

• To impact Project Scope documents from the Client Leadership team in collaboration with the other delivery teams to ensure there is a clear and common understanding of the work needed to deliver the project.
• To produce Siebel Databriefs from the information given in the Project Brief and as part of the impacting process. This will include working with a Data Planner to be able to implement the desired test plan in Siebel.
• To select data from the TVL marketing database (CMS) for direct mail, email, field campaigns using Siebel Marketing & Analytics.
• To monitor the accuracy and integrity of the data throughout the production process, including ad hoc counts and queries.
• Non-author QC of colleagues’ data selections
• Ad hoc analysis/counts to assist in the development and targeting of campaigns as required
• Daily report checking/general admin
• Produce ad hoc campaign analysis and queries using SAS/Siebel in response to Customer Queries, Subject Access Requests and Freedom Of Information requests

WE’RE LOOKING FOR:

Technical Skills/Experience

• Highly data literate and comfortable working with large/complex database/datasets
• 2 years data selection/processing experience. Ideally marketing services (e.g. data processing bureau/data services supplier) or agency background
• Experienced in using Siebel or similar CRM applications (although full Siebel training will be given)
• Experience of SQL would be helpful although not essential
• Good understanding of Direct Marketing
• Educated to min A-level/college level

 Personal Attributes Sought

• Quick learner
• Methodical/rigorous attention to detail
• Logical thinker
• Good communication skills and ability to interpret data in ‘lay terms’
• Team player/good interpersonal skills