CRM Analyst — Loyalty & CLV Analytics

Molton Brown; City Of London; Hybrid; GBP 42,000 - 62,000; Full time

Benefits offered by this job

Flexible working

Health & wellbeing offers

Pension options

Job summary

Molton Brown is seeking a CRM Analyst to support global customer insights and the loyalty program. You will manage CLV reporting, customer tiering, and campaign ROI analysis to drive growth across channels and markets.

The role focuses on recency, frequency and monetary value metrics, customer journeys, and cross-territory data insights. A background in retail and health & beauty is preferred, with advanced Excel and SQL skills.

Qualifications

• Graduate or equivalent with an analytical background.
• 3+ years experience operating in a CRM Analyst level role.
• Experience with RFM modelling and loyalty data reporting.
• Advanced Excel with v-lookups, pivots and complex formulas.
• Experience using Business Insights tools preferred.
• SQL or Fabricor useful.

Responsibilities

• Support CRM Manager with customer insight and CLV reporting across the business.
• Create tiering target models based on Recency, Frequency and Monetary value.
• Report on CLV metrics and manage the CRM dashboard.
• Analyze consumer behaviour trends and ROI of campaigns.
• Review customer feedback from surveys, social media and reviews.
• Monitor competitor and loyalty trends across territories.
• Provide support to Digital Analytics and Optimization Executive.

Skills

CRM analytics

RFM modelling

Advanced Excel

SQL

Customer insights

Loyalty programs

Campaign analysis

Data reporting

Education

Graduate or equivalent with analytical background

Tools

Business Insights tool

Fabricor

SQL

Job description

Molton Brown is seeking a CRM Analyst to support global customer insights and the loyalty program. You will manage CLV reporting, customer tiering, and campaign ROI analysis to drive growth across channels and markets.

The role focuses on recency, frequency and monetary value metrics, customer journeys, and cross-territory data insights. A background in retail and health & beauty is preferred, with advanced Excel and SQL skills.