Do you want to make a difference and be part of a vibrant and inclusive organisation that has been helping save lives for more than a century? As one of the country’s best-loved charities, St John Ambulance played a pivotal role in responding to the pandemic as well as ‘everyday’ health emergencies, training, supporting communities, and improving young people’s lives. 

This is a 12 month fixed term contract

This is an exciting time to join St John with our new 10 year strategy underway and our ongoing digital transformation. We are now seeking a Marketing Database & Systems Analyst within our Education & Enterprise division where you will develop SQL Server databases (Training, Supplies, Events, Ambulance Operations - mostly B2B but with one element of B2C) and create and maintain SQL scripts to run data selections needed for the delivery of revenue-focused Marketing Campaigns. This role will be responsible for providing insights and expertise while liaising with stakeholders as well as improving and optimising flows and processes amongst the different systems using SQL, VBA and other technologies echoing St John Ambulance digital transformation.

We pride ourselves on being a great place to work, providing a supportive culture with opportunities to grow and develop your career, achieve a healthy work-life balance and to be recognised for the great work you do. The role benefits from a competitive salary, generous pension, hybrid/flexible working, 33 days holiday (inclusive of bank holidays) - increasing to 38 days over 5 years, options to buy and sell holiday, free first aid and mental health first aid courses, Blue Light and NHS online shopping discounts, cycle to work scheme, lifecare, mental health and wellbeing tools and volunteering days.   

Please see the job description for more detail (this can be viewed on our website or once you click apply) 

About You: 

• Experience of managing and maintaining large databases ideally within a Marketing environment
• Experience of data analysis reporting and B2B data management
• Experience of VBA/Macros to automate Excel/Office processes
• An advanced knowledge of SQL, SSIS and MS Excel
• A good understanding of data protection principles
• Strong attention to detail with high level of organisation

About The Role:  

• Liaise effectively with stakeholders to determine campaign requirements and translate those into data outputs from databases and systems. Use Data techniques to match these outputs to the stakeholders requirements. This involves segmentation, deduplication, formatting, deletion and addition of content as needed.
• Maintain the various data silos, ensuring that the data from the various Education & Enterprise systems are validated in the SQL databases.
• Support the data flows between St John Ambulance 3rd party Marketing Data partners to enhance the business value of the Marketing Data.
• Corroborate that the data stored is still fit for purpose and suggest and implement changes when business needs merit.
• Provide automated solutions for manual/time-consuming processes. This will involve engaging with non-technical stakeholders to fully understand the nature of their processes and ways to integrate this with other existing subprocesses.

About Us: 

This is a fantastic opportunity to join a team of over 1,900 employees and over 30,000 volunteers, united by our goal of saving lives through essential first aid services, training and campaigning. As a charity with rich heritage and a long history of serving humanity, we are proud of our past and excited about creating a healthier, safer, more resilient future.  

St John Ambulance works at the heart of communities, supporting and enabling them to access and receive physical and mental health first aid. We do this through developing and providing effective community response and outreach services (e.g. Ambulance response, Falls response, Night Time Economy and Homelessness outreach) and using our longstanding expertise to empower people with vital clinical skills and the confidence to use them (e.g. our Volunteers and Community Advocates, NHS Cadets and Young Responders programmes). 

Find out more about us, including our Ask Me campaign, at www.sja.org.uk  

For candidates or St John Ambulance volunteers wishing to apply, please apply below. 

St John Ambulance is committed to increasing the diversity of our team and making sure we best reflect the diversity of the communities we serve. At St John, everyone is valued and supported to thrive; we have several networks including the Armed Forces, Multi Culture, Disability and Accessibility, Pride, Family and Carers and Women’s groups. We do not tolerate any form of discrimination and engender a sense of belonging for all, by creating an environment of mutual respect, where we value unique differences and demonstrate authentic allyship. We believe passionately in equity, diversity and inclusion.    

We reserve the right to close this vacancy early if we receive a high volume of applications for the role. Therefore, if you are interested, please submit your application as early as possible. 

Please note St John does not accept speculative CVs and will only consider CVs submitted for an advertised role.