At a Glance
- Tasks: Use SQL to build customer selections and analyse campaign performance.
- Company: Established UK insurance business expanding its analytics capabilities.
- Benefits: Competitive salary, strong bonus, flexible hybrid working, and fast interview process.
- Other info: Dynamic team environment with opportunities for impactful insights.
- Why this job: Own campaign analytics and directly influence customer strategy and revenue.
- Qualifications: Strong SQL skills and experience in campaign analytics or CRM.
The predicted salary is between 35000 - 45000 £ per year.
I'm hiring a Customer Selections & Analytics Consultant for a long-established UK insurance business that is expanding 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.
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
Responsibilities:
- Build audiences for marketing campaigns
- Ensure the right customers are targeted at the right time
- Analyse campaign performance and drive improvements
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
Final note:
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 employer: Harnham
Join a long-established UK insurance business that values innovation and employee development, offering a dynamic work culture where your contributions directly shape customer engagement strategies. With strong bonus potential, flexible hybrid working arrangements, and opportunities for professional growth in a supportive environment, this role as a Customer Selections Analyst in Stratford-upon-Avon is perfect for those looking to make a meaningful impact while enjoying a balanced work-life experience.
StudySmarter Expert Advice🤫
We think this is how you could land Customer Selections Analyst
✨Tap into Campus Networks
If you're still in uni, don’t forget to engage with your campus's career services and attend finance-related events. Banks often do presentations and recruitment drives on campus, so put yourself out there and make use of these opportunities to show off your passion for the field.
✨Get Certified
Consider pursuing relevant certifications like the CFA or ACCA while you’re job hunting. They not only beef up your CV but also connect you with professional bodies which can lead to networking opportunities and even job openings in banking and financial services.
✨Connect on Professional Platforms
Join finance-focused groups on platforms like LinkedIn and engage in discussions. This can really help you stand out from the crowd, allowing potential employers to see your knowledge and interest in industry trends. Plus, you might stumble upon job postings shared exclusively within the group.
✨Apply Directly and Be Proactive
Don’t shy away from reaching out directly to firms like Harnham. Use their websites and apply through them, but also consider following up with a polite email to express your enthusiasm. Being proactive can make a huge difference in getting noticed in the competitive financial services sector.
We think you need these skills to ace Customer Selections Analyst
Some tips for your application 🫡
Show Off Your Numbers!:In the banking and financial services world, quantifiable achievements are key. Make sure your CV highlights your grades in relevant subjects, any financial certifications you hold, and specific projects where you've delivered measurable results. Employers love to see how your skills translate into real-world success.
Tailor Your Cover Letter to the Role:When applying for a full-time position, your cover letter should make a direct connection between your experience and the job description. Don't just state your enthusiasm for finance—dive into how your background in banking or financial analysis sets you apart. Let your passion shine through while being specific about what you can bring to Harnham.
Include Relevant Financial Software Experience:If you've worked with financial modelling tools or software like Excel, SAP, or specific analytical tools during your studies or internships, bring that up! Highlighting your proficiency can really make your application pop and show you're ready to hit the ground running in a full-time role.
Research and Reflect:Before hitting that 'apply' button on Harnham's website, do a little digging. Look up their recent projects, values, and culture. Reflecting their ethos in your application can make a huge difference and show you’re genuinely interested in being part of the team!
How to prepare for a job interview at Harnham
✨Brush Up on Financial Analysis Skills
Make sure you're well-versed in financial concepts and analytical techniques relevant to banking and financial services. Get comfortable with tools like Excel for modelling or financial forecasting, as technical questions in this area are common during interviews with Harnham.
✨Prepare for Case Studies
Expect to tackle case studies that demonstrate your problem-solving skills in real-world banking scenarios. Familiarise yourself with the types of problems you might face—think risk assessments or investment evaluations—and be ready to articulate your thought process clearly.
✨Show Your Passion for Finance
Since this is a full-time position, employers at Harnham will be keen to see your genuine interest in finance. Be prepared to discuss recent industry trends or news articles that excite you, showcasing your enthusiasm and engagement with the field.
✨Network with Industry Professionals
Before your interview, reach out to current or former Harnham employees on platforms like LinkedIn. They'll offer unique insights into the company's culture and the interview process, which can give us a delightful edge in showcasing a good fit for the team.
