CRM Campaign Analytics Analyst – SQL-driven Targeting

Harnham; West Midlands; Hybrid; GBP 42,000 - 64,000; Full time

Benefits offered by this job

Bonus 17.5%

Hybrid working (1 day onsite)

Job summary

Harnham is hiring a Customer Selections & Analytics Consultant for a long‑established UK insurer, focusing on customer analytics and marketing capability. You’ll own end‑to‑end CRM analytics from data selection to insight and influence targeting strategies.

Based in Stratford-upon-Avon with flexible hybrid working (1 day onsite), the role emphasises campaign targeting, audience segmentation and performance analysis, with strong SQL skills and stakeholder collaboration.

Qualifications

• 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.
• Experience in insurance or regulated environments.
• Experience with Power BI or other visualisation tools.
• Understanding of test‑and‑learn / campaign optimisation approaches.

Responsibilities

• 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.

Skills

SQL

CRM analytics

Audience segmentation

Campaign performance

Stakeholder comms

Presentation skills

Tools

Power BI

Job description

Harnham is hiring a Customer Selections & Analytics Consultant for a long‑established UK insurer, focusing on customer analytics and marketing capability. You’ll own end‑to‑end CRM analytics from data selection to insight and influence targeting strategies.

Based in Stratford-upon-Avon with flexible hybrid working (1 day onsite), the role emphasises campaign targeting, audience segmentation and performance analysis, with strong SQL skills and stakeholder collaboration.