Associate Data Analytics Director

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 is 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 is a client-facing role. The person will sit within the client's Loyalty team and 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 to remain close to the strategic approach for the loyalty programme and can tap into the wider team to help with insights or recommendations.

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, 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 an Associate Data Analytics Director.
• AWS Redshift.
• RedPoint Data Management knowledge 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.