About the role
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.
Millions of jobs, with real people getting hired every day
Questions, answered
Click "Apply with JobAssist" – we tailor your resume and application to this role and submit it for your approval.
Yes. This role at Harnham was screened before publishing – we confirmed the employer before listing it.
The employer didn't disclose a salary range for this listing. JobAssist shows pay whenever it's available.
This position can be done from anywhere, with no in-office requirement.
Yes – every application is tailored from your profile and this job's requirements, and you can review and edit before it's sent.