Data Analyst

Great Ormond Street Hospital; City Of London; Hybrid; GBP 42,000; Full time

Job summary

A renowned children's healthcare charity is seeking a Data Analyst to help harness the power of supporter data to grow income and engagement. The ideal candidate will have strong skills in SQL and Power BI, demonstrating the ability to translate complex data into actionable insights. This role offers a salary of £41,851 per year with a hybrid working policy of a minimum of two days in the office.

Benefits

30 days annual leave

Flexible working arrangements

Enhanced pension scheme

Life assurance

Health and wellbeing schemes

Qualifications

• Strong SQL skills ideally working with MS SQL Server.
• Proficiency in Power BI.
• Advanced Excel skills, including pivot tables, formulas, and macros.
• Experience working with CRM systems, ideally Salesforce.
• Ability to interpret and communicate complex analytical insights to non-technical audiences.

Responsibilities

• Use MS SQL Server to extract and analyse supporter data for fundraising.
• Develop engaging Power BI dashboards and reports for decision-making.
• Translate complex data into actionable stories for strategic direction.
• Collaborate with teams to evaluate campaign performance and trends.
• Apply statistical techniques to deliver evidence-based recommendations.

Skills

Strong SQL skills

Proficiency in Power BI

Advanced Excel skills

Experience with CRM systems

Interpreting complex data

Job description

Data Analyst

Application Deadline: 24 October 2025

Department: Fundraising

Employment Type: Fixed Term Contract

Location: Great Ormond Street Hospital Children’s Charity

Reporting To: Marcus Gearey

Compensation: £41,851 / year

Description

Are you a data-driven storyteller who loves uncovering the insights that shape strategy and make a real difference? Join Great Ormond Street Hospital Children’s Charity and help us harness the power of supporter data to grow income, deepen engagement, and change lives for seriously ill children across the UK.

This position is a 12 month fixed term contract.

The salary for this position is £41,851 pro rata and we operate a hybrid working policy of a minimum of 2 days per week in the office.

In line with our EDI strategy and Total Reward policy, we calculate our salaries based on benchmarking data across the charity sector. To ensure fairness for existing staff and new joiners, we do not offer salaries above the advertised rate.

Key Responsibilities

• Use MS SQL Server to extract, analyse, and interpret supporter data, providing high-quality insight to inform fundraising and engagement strategies.
• Develop engaging Power BI dashboards and reports (similar dashboard tools such as Tableau and Qlik may be considered) that enable colleagues to self-serve and make data-led decisions.
• Translate complex data into clear, actionable stories that drive strategic direction and campaign performance.
• Collaborate with teams across fundraising and engagement to evaluate campaign performance, identify trends, and uncover new opportunities for growth.
• Apply statistical and analytical techniques to deliver evidence-based recommendations and optimise supporter journeys.

Skills, Knowledge and Expertise

• Strong SQL skills ideally working with MS SQL Server.
• Proficiency in Power BI.
• Advanced Excel skills, including pivot tables, formulas, and macros.
• Experience working with CRM systems, ideally Salesforce.
• Ability to interpret and communicate complex analytical insights to non-technical audiences.
• A collaborative, curious mindset with a passion for using data to drive meaningful change.

Experience working with supporter/fundraising data is beneficial for this role.

How to apply

Please click on the apply button in the top right-hand corner where you will be taken to a short application form to complete.

Closing Date: 24th October

Benefits

• 30 days annual leave (plus bank holidays)
• A flexible approach to working arrangements.
• Access to our enhanced pension scheme.
• Life assurance.
Access to various health and wellbeing schemes, including the employee assistance programme.