Customer Selections Analyst

Harnham; Stratford-upon-Avon; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

Strong 17.5% bonus

Hybrid: 1 day onsite

Job summary

Harnham is hiring a Customer Selections & Analytics Consultant for a long-established UK insurance business, focusing on customer analytics and marketing capability. The role is hands-on SQL, concentrating on campaign targeting and performance analysis within a team that drives how customers are engaged and retained.

You'll build audiences, analyze performance, and deliver clear insights to optimise campaigns. Experience in CRM analytics and stakeholder communication is essential for success.

Qualifications

• Strong SQL skills.
• Experience in campaign selections / CRM / customer analytics.
• Experience building audiences and segmenting customer data.
• Experience analysing campaign performance and delivering insights.
• Ability to work with stakeholders and explain results clearly.
• Good communication and presentation skills.

Responsibilities

• Build customer selections using SQL based on campaign briefs.
• Segment audiences to support targeted marketing activity (cross-sell and retention).
• Collaborate with stakeholders across the business to understand campaign requirements.
• Analyse campaign performance and provide clear, actionable insight.
• Present findings back to stakeholders to improve future campaigns.
• Support the development of dashboards and reporting for campaign evaluation.
• Help refine targeting approaches through continuous feedback and optimisation.

Skills

SQL

Campaign selections / CRM / customer分析

Audience segmentation

Campaign performance analysis

Communication / presentation

Stakeholder management

Tools

Power BI

Job description

I'm hiring a Customer Selections & Analytics Consultant for a long‑established UK insurance business that's continuing to invest in its customer analytics and marketing capability.

This is a hands‑on SQL role focused on campaign targeting and performance analysis, sitting in a team that directly influences how the business engages and retains its customers.

The company

I'm hiring a Customer Selections & Analytics Consultant for a long‑established UK insurance business that's continuing to invest in its customer analytics and marketing capability.

This is a hands‑on SQL role focused on campaign targeting and performance analysis, sitting in a team that directly influences how the business engages and retains its customers.

The company

A well‑known UK insurer with a long history, now serving a wide range of customers across business, home, motor and pet insurance.

Data is central to how they grow and retain customers, with a strong focus on improving customer value and engagement through smarter targeting and insight.

The role

You'll sit within a team of SQL‑driven analysts responsible for:

• Building the audiences for marketing campaigns
• Ensuring the right customers are targeted at the right time
• Analysing campaign performance and driving improvements

This is a true end‑to‑end CRM analytics role - from selection through to insight.

What you'll be doing

• Build customer selections using SQL, based on campaign briefs
• Segment audiences to support targeted marketing activity (e.g. cross‑sell and retention campaigns)
• Work with stakeholders across the business to understand campaign requirements
• Analyse campaign performance and provide clear, actionable insight
• Present findings back to stakeholders to improve future campaigns
• Support the development of dashboards and reporting for campaign evaluation
• Help refine targeting approaches through continuous feedback and optimisation

What you bring

Must‑haves

• Strong SQL skills
• Experience in campaign selections / CRM / customer analytics
• Experience building audiences and segmenting customer data
• Experience analysing campaign performance and delivering insights
• Ability to work with stakeholders and explain results clearly
• Good communication and presentation skills

Nice to have

• Experience in insurance or regulated environments
• Experience with Power BI or other visualisation tools
• Understanding of test‑and‑learn / campaign optimisation approaches

Why this role

• Own end‑to‑end campaign analytics - not just reporting
• Work in a team that directly impacts customer strategy and revenue
• Strong bonus (17.5%) alongside salary
• Flexible hybrid working (1 day onsite)
• Fast interview process

Location

• Based in Stratford‑upon‑Avon
• 1 day per week onsite
• Commutable from Birmingham, Coventry, Warwick, Leicester, Nottingham, and surrounding areas

Interview process

• SQL test (sent upfront)
• Single competency interview
• Fast turnaround

If you have experience in CRM or campaign analytics and want a role where you can own both targeting and insight, this is a great opportunity.