Data & Insights Analyst

The Data & Insights Analyst will be responsible for supporting the maximisation of effective fundraising through high-quality data, robust CRM management and administration, and clear, actionable insight. The postholder will ensure that fundraising and supporter data is well-designed, accurately maintained, and transformed into meaningful business intelligence that supports growth, retention, and exceptional donor experiences.

Working closely with fundraising, marketing, supporter care, and leadership teams, the role will provide insight into donor behaviour, campaign performance, income trends, and supporter informatics. By developing and maintaining reliable data structures, reports, and data selections the postholder will help the charity make informed, evidence-based decisions, and support fundraising campaigns to maximise income at all levels.

This role plays a critical part in strengthening the charity's relationship with its supporters by ensuring data enables personalised engagement, informed stewardship, effective compliance, and continuous improvement across all fundraising activity., * Ensure supporter and fundraising data is accurately maintained, consistent, and fit for purpose within the Charity's CRM and other data systems

• Support the development and maintenance of data structures, coding frameworks, and naming conventions
• Carry out data validation, transformation, imports, and updates (such as supporters, donations, campaigns, consent data)
• Identify and resolve data quality issues such as duplicates, inconsistencies, and data gaps
• Undertake regular data cleansing, reconciliation, and audits to improve data integrity and quality Support, train, and guide colleagues to ensure best practice use of the CRM and maintain high standards of data entry

Data Selections & Campaign Delivery

• Create accurate and targeted data selections for direct mail, email, lottery, and multi-channel fundraising campaigns
• Work closely with fundraising teams to understand campaign objectives and develop effective targeting strategies
• Apply segmentation approaches based on supporter behaviour, value, and engagement
• Manage suppression lists and ensure all selections comply with consent and communication preferences Support test-and-learn approaches (e.g. A/B testing, pricing tests, control groups) through robust data selection and analysis

Insight, Reporting & Analysis

• Analyse supporter and fundraising data to identify trends in income, behaviour, retention, acquisition, and campaign performance
• Produce regular reports, dashboards, and performance summaries to support decision-making
• Support the team in developing and maintain Power BI dashboards and reporting frameworks using data from the Charity's CRM and other systems
• Support in translating complex data into clear insight, commentary, and recommendations for non-technical stakeholders
• Evaluate campaign performance and support in providing actionable recommendations to improve results and supporter experience

Insight-Led Improvement & Collaboration

• Work collaboratively with fundraising, finance, and operational teams to understand data needs and improve data use
• Proactively identify opportunities to improve targeting, reporting efficiency, and supporter journeys
• Share insight and recommendations to support income growth and supporter engagement
• Contribute to the development and embedding of a data-driven culture across the organisation
• Support the Systems Team with the implementation of and migration to new data systems, playing a role in data mapping, extraction, transformation, validation, and user acceptance testing (UAT)

Compliance & Governance

• Ensure all supporter data is handled in line with GDPR, PECR, fundraising regulation, and internal policies
• Accurately manage consent, communication preferences, and suppression requirements
• Ensure all data selections, extracts, and reporting are compliant and secure

Other Responsibilities

• Maintain clear documentation of data structures, definitions, reporting logic, and Power BI models
• Support training of colleagues and stakeholders in CRM and data processes
• Undertake any other duties appropriate to the role
• As EHAAT is a patient focused emergency medical charity we feel it is essential that all our staff are competent and confident in the delivery of CPR and use of an AED (defibrillator) in an emergency. For this reason, you will need to complete mandatory, in house, CPR and AED awareness training annually, Experience supporting or contributing to systems projects, including data cleansing, testing, or reconciliation.

Do you have experience in SQL?, Strong analytical skills, able to interpret complex datasets and identify meaningful trends and insights., Organised, with the ability to manage multiple data requests and deadlines effectively., Good problem-solving skills, with a practical and methodical approach, Demonstrable experience in a data analysis, data support, or reporting role, Practical experience working with CRM systems, including maintaining data quality, structures, and reporting outputs., Previous experience in a charity or not-for-profit environment, Experience with Microsoft Fabric or other similar cloud-based data solutions, Team player with well-developed interpersonal skills, Clear and effective communication skills, both written and verbal, A commitment to continued professional development, and a desire to take part in formal and informal training and development opportunities

Pulled from the full job description

• Annual leave
• Employee discount
• Sick pay
• Employee assistance programme
• Company pension
• Cycle to work scheme, The Package

Salary: £35,000 per annum

As a valued member of the charity team, you will have access to a wider range of benefits including:

• 24 days annual leave plus 8 bank holidays (pro-rata), increasing with length of service
• Contributory pension scheme, with minimum 6% employer contribution, plus an annual pension review
• Occupational sick pay from day one employment
• Manage your own hours with core hours working schedule (non-retail roles)
• Free access to an Employee Assistance Programme (plus immediate family)
• Access to Cycle to Work through salary sacrifice
• Discounts at a variety of retailers via Blue Light Card, To help us fairly assess candidates, we ask that all application responses are your own work and not generated using AI tools. We're interested in your genuine voice, thinking, and experience.

Please note that our sites are not easily accessible via public transport, therefore access to your own transport would be highly beneficial for this role.

This position is subject to a Disclosure and Barring Service (DBS) check. The successful candidate will be required to undergo an Basic DBS check as a condition of employment.

If you would like an informal chat about the role, please contact sue.dawson@ehaat.org and we will organise a time to speak to one of the team.

Other roles you may have experience with:

• Data Analyst
• Business Intelligence Analyst
• Insights Officer
• Data Insights Analyst
• Database Administrator
• Database Analyst
• Database Co-ordinator
• CRM Administrator
• CRM Analyst

Disclaimer: Essex & Herts Air Ambulance reserve the right to close a vacancy earlier than the advertised date if a high number of applications are received. Once a vacancy has closed, we are unfortunately unable to consider further applications, so please submit your application as soon as possible to avoid disappointment.

Essex & Herts Air Ambulance, unlike NHS emergency services, is a charity. The free life-saving service is provided 24/7 by helicopters and by rapid response vehicles. Each critical care team consists of a pilot and co-pilot, a pre-hospital care doctor and a critical care paramedic. They can be rushed to the scene with life-saving support equipment to deliver advanced clinical care, usually only available in the hospital emergency department. Once stabilised, the patient will be conveyed to the most appropriate hospital by air or land. Without access to National Lottery funding and with only limited support from Government, we rely upon the generosity and goodwill of the people and businesses of Essex and Hertfordshire to remain operational and keep saving lives…we can't fly without you!