Campaign Selections Consultant

Harnham; Stratford-upon-Avon; Hybrid; GBP 45,000 - 50,000; Full time

Job summary

Harnham is seeking a Campaign Selections Consultant for a 12-month FTC in Stratford-upon-Avon. The role focuses on SQL-driven campaign delivery, turning briefs into precise data selections that drive commercial outcomes and customer engagement across multiple product areas.

You will build, automate and run customer selections using SQL, join data from CRM and engagement sources, and collaborate with analytics on testing and measurement. Hybrid work with in-office presence one day per month.

Qualifications

• Strong SQL skills for querying customer level data.
• Experience in campaign selections, CRM data or related area.
• Able to translate briefs into robust data outputs.
• Comfortable with structured templates and process improvement.
• Industry background is open; transferable experience valued.

Responsibilities

• Build, deliver high quality campaign selections to support marketing and engagement.
• Translate briefs into clear, technical selection requirements.
• Build, automate and run customer selections using SQL.
• Join and manipulate data from CRM, transactional and engagement sources.
• Use APIs to deliver selections into the CRM platform.
• Work with analytics on testing and campaign measurement.
• Plan and schedule selections 1–2 months ahead to meet timelines.

Skills

SQL

Campaign selections

CRM data

Data manipulation

Tools

APIs

Job description

Campaign Selections Consultant - 12 month FTC

Stratford upon Avon | 2 days a month in office | £45,000 to £50,000 plus bonus

This role stands out for its strong focus on SQL driven campaign delivery within a business that genuinely values customer experience and data quality. You will sit close to live customer activity, turning campaign ideas into accurate, well structured selections that directly support commercial outcomes across multiple product areas.

The Role

You will be responsible for building and delivering high quality campaign selections that support marketing and customer engagement activity.

• Translate campaign briefs into clear, technical selection requirements
• Build, automate and run customer selections using SQL
• Join and manipulate data from multiple sources including CRM, transactional and engagement data
• Use APIs to deliver selections into the CRM platform
• Work closely with analytics colleagues on testing and campaign measurement
• Plan and schedule selections one to two months ahead to support delivery timelines

Campaign activity spans email and direct mail, with increasing scope across digital channels as capability continues to grow.

Your Skills and Experience

• Strong SQL skills with confidence querying and manipulating customer level data
• Experience in campaign selections, customer analytics, CRM data or a related area
• Comfortable working with structured templates while continuously improving processes
• Able to translate business or marketing briefs into robust data outputs
• Industry background is open, with transferable experience valued

What They Offer

• Salary between £45,000 and £50,000 plus bonus
• Hybrid working with one day per week in the Stratford upon Avon office
• Exposure to large scale customer data and CRM transformation work
• Clear progression opportunities into analytics, data science or broader data roles
• Access to a supportive, collaborative data community