At a Glance
- Tasks: Own campaign selections using SQL and drive impactful customer campaigns.
- Company: Join a leading UK insurer known for excellent customer experience.
- Benefits: Competitive salary, bonus, and hybrid working model.
- Other info: Be part of a dynamic team during a major data transformation.
- Why this job: Transform insights into real campaigns and make a difference in customer engagement.
- Qualifications: Strong SQL skills and experience in customer analytics or CRM.
The predicted salary is between 45000 - 50000 £ per year.
If you’re a SQL-heavy analyst tired of insight going nowhere, this is where your work actually turns into live customer campaigns! Brand-new role, strong team, and a business investing heavily in customer data + marketing capability.
The Company
You’ll be joining a leading UK insurer with a strong reputation for customer experience and long-term stability; they’re in the middle of a major data transformation, with new platforms, better access to customer data, and a real push towards data-led decision making across the business.
The Role
Sitting in the Customer Selections & Analytics team, you’ll own the delivery of campaign selections end-to-end. This is a hands-on SQL role with clear commercial impact.
Key responsibilities:
- Build and deliver campaign selections using SQL
- Translate marketing briefs into technical requirements
- Work across CRM, transactional & engagement datasets
- Support test & learn campaigns and performance tracking
- Push selections into CRM (moving to Dotdigital)
- Plan and manage campaign cycles 1–2 months ahead
You’ll work across Financial Services, Personal Lines & Commercial, giving you broad exposure across the business.
Your Skills & Experience
- Strong SQL
- Background in campaign selections / CRM / customer analytics
- Experience working with large datasets
- Ability to translate business needs into data outputs
The Benefits
£45,000–£50,000 Bonus
How to Apply
Please register your interest by sending your CV to Adam Osborne at Harnham via the Apply link on this page.
Customer Analyst in Stratford-upon-Avon employer: Harnham
Join a dynamic and forward-thinking B2B company that prioritises data-driven decision making and offers a fully remote work environment across the UK. With a strong focus on employee growth, you will have the opportunity to lead a talented team while shaping the marketing analytics strategy in a rapidly expanding organisation. Enjoy a collaborative work culture that values innovation and provides significant investment in your professional development.
StudySmarter Expert Advice🤫
We think this is how you could land Customer Analyst in Stratford-upon-Avon
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those already working at the company you're eyeing. A friendly chat can give you insider info and maybe even a referral!
✨Tip Number 2
Prepare for the interview by practising your SQL skills. Be ready to showcase how you've used SQL in past roles to drive customer insights and campaign selections. Real-life examples will make you stand out!
✨Tip Number 3
Show your passion for data-led decision making! During interviews, talk about how you’ve contributed to data transformations or improved customer experiences through analytics. It’s all about demonstrating your impact.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take that extra step to connect with us directly.
We think you need these skills to ace Customer Analyst in Stratford-upon-Avon
Some tips for your application 🫡
Tailor Your CV:Make sure your CV reflects the skills and experience mentioned in the job description. Highlight your SQL expertise and any relevant campaign selection experience to catch our eye!
Showcase Your Impact:When detailing your previous roles, focus on how your work has led to tangible results. We love seeing how your insights have turned into successful campaigns or improved customer experiences.
Keep It Clear and Concise:We appreciate a well-structured application. Use bullet points for easy reading and keep your descriptions focused on your achievements and relevant skills. No need for fluff!
Apply Through Our Website:To make sure your application gets to us smoothly, use the Apply link on our website. It’s the best way to ensure we see your application and can get back to you quickly!
How to prepare for a job interview at Harnham
✨Know Your SQL Inside Out
Since this role is SQL-heavy, make sure you brush up on your SQL skills. Be prepared to discuss specific queries you've written and how they impacted previous campaigns. Practising common SQL problems can also help you feel more confident.
✨Understand the Business Context
Familiarise yourself with the company’s focus on customer experience and data-led decision making. Be ready to explain how your analytical skills can contribute to their goals, especially in transforming customer data into actionable insights.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to translate marketing briefs into technical requirements. Think of examples from your past work where you successfully managed campaign selections or worked with large datasets, and be ready to share those stories.
✨Show Enthusiasm for Data Transformation
This company is investing heavily in data capabilities, so express your excitement about being part of a data transformation journey. Discuss how you can support their push towards better customer analytics and campaign performance tracking.