Full 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 companyA 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 roleYou’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 bringMust-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.