At a Glance
- Tasks: Use SQL to build customer selections and analyse campaign performance.
- Company: Established UK insurance business focused on customer analytics.
- Benefits: Competitive salary, strong bonus, and flexible hybrid working.
- Other info: Fast interview process with a supportive team environment.
- Why this job: Own end-to-end campaign analytics and directly impact customer strategy.
- Qualifications: Strong SQL skills and experience in CRM or campaign analytics.
The predicted salary is between 40000 - 50000 £ per year.
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 is 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 involves sitting 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 includes a SQL test (sent upfront), a single competency interview, and a 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.
Customer Selections Analyst in Stratford-upon-Avon employer: Harnham - Data & Analytics Recruitment
Join a well-established UK insurance company that prioritises data-driven decision-making and customer engagement. With a strong focus on employee development, flexible hybrid working arrangements, and a competitive bonus structure, this role offers a unique opportunity to influence customer strategy while working in a collaborative and innovative environment. Located in Stratford-upon-Avon, you'll enjoy a vibrant community with easy access to major cities, making it an ideal place for both professional growth and personal enjoyment.
Contact Details:
Harnham - Data & Analytics Recruitment Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Customer Selections Analyst in Stratford-upon-Avon
✨Tip Number 1
Get your SQL skills sharp! Since this role is all about data, brush up on your SQL queries and practice building customer selections. We recommend using online resources or even creating your own mini-projects to showcase your skills.
✨Tip Number 2
Network like a pro! Reach out to current employees or alumni from the company on LinkedIn. A friendly chat can give you insider info and might just help you get your foot in the door. Plus, it shows your genuine interest in the role!
✨Tip Number 3
Prepare for that SQL test! Since it’s upfront, take it seriously. Practice common SQL problems and think about how you can apply your knowledge to real-world campaign scenarios. We believe in you!
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen. Plus, we love seeing candidates who are proactive and engaged with our platform. Let’s get you that interview!
We think you need these skills to ace Customer Selections Analyst in Stratford-upon-Avon
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your strong SQL skills in your application. We want to see how you've used SQL in past roles, especially in campaign selections and customer analytics. Don't just say you have the skills; give us examples of how you've applied them!
Tailor Your Experience:When you're writing your application, tailor it to the role. Focus on your experience with campaign performance analysis and audience segmentation. We love seeing how your background aligns with what we're looking for, so make it clear!
Communicate Clearly:Good communication is key in this role, so let that shine through in your application. Use clear and concise language to explain your experiences and insights. We want to see that you can present findings effectively, just like you would in the job!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly. Plus, it shows you're keen on joining our team at StudySmarter!
How to prepare for a job interview at Harnham - Data & Analytics Recruitment
✨Master Your SQL Skills
Since this role is heavily focused on SQL, make sure you brush up on your SQL skills before the interview. Practice writing queries that could help in building customer selections and segmenting audiences. Being able to demonstrate your SQL prowess will show that you're ready to hit the ground running.
✨Know Your Campaigns
Familiarise yourself with common campaign strategies and performance metrics. Be prepared to discuss how you would approach audience segmentation and what factors you consider when analysing campaign performance. This will help you connect your experience to the role's requirements.
✨Engage with Stakeholders
This position requires collaboration with various stakeholders, so think about examples from your past where you've successfully communicated insights or findings. Prepare to explain how you would present your analysis clearly and effectively to non-technical team members.
✨Prepare for the SQL Test
Since there's an SQL test upfront, take it seriously! Review sample questions and practice coding in a SQL environment. Make sure you understand the logic behind your queries, as this will not only help you in the test but also in the interview discussions.
