.png)
Department: Marketing Sciences
Employment Type: Fixed Term Contract (Secondment)
Duration: 6 months
Location: London (including c. x1 per week in Eastleigh)
WHO WE ARE
We are RAPP – world leaders in activating growth with precision and empathy at scale.
As a global, next-generation precision marketing agency we leverage data, creativity, technology, and empathy to foster client growth. We champion individuality in the marketing solutions we create, and in our workplace. We fight for solutions that adapt to the individual’s needs, beliefs, behaviours, and aspirations.
We foster an inclusive workplace that values diversity and emphasises personal well-being.
THE ROLE
Overview:
RAPP are in the process of defining a new loyalty proposition for a well-known DIY retailer. This will be a complete shift from the current programmes and will touch all parts of the business.
In addition, the business are undergoing a big data transformation, moving from old legacy systems to Azure. This consolidation of data sources means greater visibility and more accurate data – and a more opportunity for sophisticated uses of data.
General information:
This a client facing role. The person will sit within the client’s Loyalty team. They will set the priorities.
The expectation is that the candidate can do the hands-on work and provide proactive recommendations to the clients based on results.
The candidate will also have a line into the client team at RAPP so they can remain close to the strategic approach for the loyalty programme and can tap into the wider team to help with insights or recommendations (e.g. they won’t be on an island for this secondment).
There will be an initial onboarding with the RAPP team, and then a more detailed onboarding with the client’s Data Analytics team to understand data, data tables, systems, etc. This will require time on-site at the client’s office in Eastleigh on average once per week, with the other 2 in-office days at our London office.
Responsibilities:
- Preparation of results reporting for always on and ad-hoc campaigns. This includes reviewing comms engagement, channels of response, conversion, ROI, incremental impact, etc.
- Regular review of Loyalty stats. Similar to report above but specifically for Club and TP e.g. total active members, ATV, Avg. frequency, revenue of member vs non-members, etc.
- For all outputs, provide insights and recommendations, liaising with the RAPP team as needed.
- Development of dashboards in Power BI (once data transformation is complete). Dashboard views to be co-defined with the client’s Loyalty team and reviewed with the client’s Data Analytics team to ensure correct data points are featured.
ROLE REQUIREMENTS
- Currently in a similar role either as a Senior Data Analyst looking for the next step up OR a Associate Data Analytics Director
- AWS Redshift
- RedPoint Data Management (https://www.redpointglobal.com/data-management/) Knowledge here isn’t critical.
- PowerBI & Power Platform
- Azure Databricks
- Python on Azure Databricks (if we’re looking for anything more advanced)
- Any experience with Braze data would be a bonus as well
We are RAPP. And we can’t wait to meet you.
Top Skills
What We Do
We are a global creative agency, but the individual 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.
Gallery
