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 44817 - 54777 £ 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
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.
#J-18808-Ljbffr
Customer Selections Analyst (12-month FTC) employer: Harnham
As a leading specialist data consultancy, we pride ourselves on fostering a collaborative and innovative work culture that empowers our Analytics Engineering Consultants to thrive. With a focus on professional development, we offer extensive growth opportunities and the chance to work on high-impact projects across diverse industries, all while enjoying the flexibility of remote work in the UK. Join us to be part of a team that values your expertise and encourages you to influence strategy and drive meaningful change for our clients.
StudySmarter Expert Advice🤫
We think this is how you could land Customer Selections Analyst (12-month FTC)
✨Join Financial Networking Events
Jump into local finance meetups and conferences — they’re a goldmine for temporary roles in banking and financial services. You can chat with industry professionals and even get leads on upcoming opportunities that might not be posted online yet.
✨Utilise Temp Agencies Specialised in Finance
Reach out to temp agencies that focus on the banking sector. They often have strong ties with various firms and can help you secure short-term gigs that can help beef up your CV and get your foot in the door at firms like Harnham.
✨Connect with Alumni from Your Uni
Don't underestimate the power of your university’s alumni network. Many former students are working in banking and can help you find temporary roles or even offer mentorship. Reach out directly or attend alumni events to broaden your circle.
✨Stay Active on Job Boards and Company Websites
Keep your eyes peeled on job boards specifically for finance roles. Companies like Harnham might post temporary positions directly on their sites, so make sure to apply there too. Set alerts to catch those roles the moment they go live!
We think you need these skills to ace Customer Selections Analyst (12-month FTC)
Some tips for your application 🫡
Show Off Your Academic Achievements:In banking and financial services, your academic record can really make you stand out. List relevant grades, certifications, or coursework on your CV, especially if you've taken finance-related modules. This is particularly important for a temporary role where qualifications can help you shine even brighter!
Highlight Relevant Experience:If you’ve done any internships, part-time roles, or even coursework that aligns with banking or finance, make sure you include those! Showcase specific tasks where you used quantitative skills or analytical thinking, as this is what the hiring managers at Harnham will be keen to see in your application.
Tailor Your Cover Letter Purposefully:When writing your cover letter, focus on why you’re interested in a temporary position at Harnham. Let them know how you can quickly adapt to the team's needs and how eager you are to learn the ropes of the banking sector during this short stint. Your motivation and enthusiasm could really set you apart!
Be Prepared with References:For temporary roles, references can play a crucial role in your application. Make sure you’ve got a couple of references lined up who can vouch for your skills and work ethic. This helps to give Harnham confidence in your short-term commitment to the role.
How to prepare for a job interview at Harnham
✨Brush Up on Financial Regulations
Since this is a role in banking and financial services, be ready to discuss key regulations like MiFID, Basel III, or GDPR. These are hot topics, and your awareness of how they impact daily operations can give you a significant edge during your interview with Harnham.
✨Showcase Your Analytical Skills
Prepare for interview questions that assess your analytical abilities. You might need to tackle hypothetical scenarios involving risk assessment or financial forecasting. Bringing examples of relevant projects or coursework can emphasise your practical understanding of these concepts.
✨Highlight Flexibility and Adaptability
For a temporary role, showing that you can quickly pick up new processes and tools is crucial. Be ready to discuss previous experiences where you had to adapt to changing requirements or tight deadlines, as this will reassure Harnham that you’re a reliable team player.
✨Demonstrate a Willingness to Learn
In a temporary position, leaning into your eagerness to learn can really set you apart. Be prepared to share how you’re staying updated on industry trends or any additional training you've pursued. Employers appreciate candidates who are proactive about their development—even for short-term roles.
