Responsibilities

• Using SQL and Alteryx as appropriate to extract and manipulate customer data from Databricks in order to understand customer behaviour and target customers for CRM campaigns
• Use SQL and Power BI as appropriate to measure the effectiveness of those CRM campaigns, effectively communicating levels in confidence in those results and ongoing campaign recommendations.
• Own the end-to-end campaign targeting and measurement process, working closely with the CRM team to produce initial audience counts, apply eligibility criteria and suppressions, confirm final volumes, and establish robust test and control groups.
• Work with CRM team to develop an understanding of which targeting strategies have been the most effective, test and learn to evolve our understanding and share ongoing proactive ideas and suggestions
• Demonstrate strong stakeholder management by proactively communicating progress, opportunities, risks and changes in audience volumes to stakeholders throughout the campaign lifecycle.
• Demonstrate strong campaign management expertise. Advise on best practices for end- to- end SLAs and cross functional process, targeting, suppressions, evaluation, and QA.
• Segment and extract customer data from relational databases for targeting and evaluation. Apply effective QA processes to ensure data accuracy.
• Collaborate with CRM and Performance Marketing teams to improve personalisation and relevancy.
• Communicate incremental impact of the CRM campaigns, and ongoing recommendations, to stakeholders.
• Build strong relationships across Marketing and Digital teams, in particular.

Requirements

• Strong SQL skills for data extraction and analysis.
• Proven experience in campaign analytics, including targeting and measurement.
• Strong organisational skills, with the ability to manage multiple campaigns and deliver selections and measurement outputs to agreed deadlines.
• Excellent communication skills, with the ability to clearly explain requirements, progress and analytical findings to technical and non-technical stakeholders.
• Highly numerate with strong analytical skills.
• 2+ years in marketing analysis or similar role.
• Proficient in SQL & Excel; Power BI and Alteryx preferred but not essential. Databricks experience preferred but not essential

Preferred

• Power BI and Alteryx preferred but not essential. Databricks experience preferred but not essential

Benefits

• Discount -Up to 50% discount and access to regular Sample Sales
• Holiday - 25 days rising to 28 with length of service
• Holiday Buy – opportunity to buy up to 5 days holiday
• Pension Scheme - enrolled in our Group Personal Pension schemes upon joining the business.
• 20% Bonus - In addition to our competitive salaries, all our employees are entitled to join a discretionary bonus scheme (based on policy eligibility)
• Wagestream Money Management app - access to Wagestream gives you power over your pay and supports financial wellbeing
• Continued Development – We offer structured support from our own in-house Learning and Development Hub
• Salary Sacrifice scheme for Electric vehicles (dependent on grade and meeting policy eligibility)
• Private Healthcare (based on contract duration)
• Life Assurance