Customer Selections Analyst (12-month FTC)

Harnham; West Midlands; Hybrid; GBP 42,000 - 64,000; Full time

Benefits offered by this job

Bonus 17.5%

Hybrid working (1 day onsite)

Job summary

Harnham is hiring a Customer Selections & Analytics Consultant for a long‑established UK insurer, focusing on customer analytics and marketing capability. You’ll own end‑to‑end CRM analytics from data selection to insight and influence targeting strategies.

Based in Stratford-upon-Avon with flexible hybrid working (1 day onsite), the role emphasises campaign targeting, audience segmentation and performance analysis, with strong SQL skills and stakeholder collaboration.

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.
• Experience in insurance or regulated environments.
• Experience with Power BI or other visualisation tools.
• Understanding of test‑and‑learn / campaign optimisation approaches.

Responsibilities

• 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.

Skills

SQL

CRM analytics

Audience segmentation

Campaign performance

Stakeholder comms

Presentation skills

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

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.