Data Analyst

Data Analyst

Application Deadline: 20 January 2026

Department: Fundraising

Employment Type: Fixed Term Contract

Location: Great Ormond Street Hospital Children\’s Charity

Reporting To: Marcus Gearey

Compensation: £41,125 / year

Description

Are you a Data Analyst with strong BI skills who enjoys turning complex reporting needs into clear, trusted dashboards — and who thrives on delivery‑focused projects?

We are recruiting a Data Analyst on a 6‑month fixed‑term contract, with a primary focus on delivering a Business Intelligence project to migrate and consolidate dashboards from Qlik into Power BI. This role will play a key part in simplifying our reporting estate and strengthening the quality, consistency, and usability of BI across the charity.

If the migration programme completes ahead of schedule, the role will operate as a Data Analyst, delivering insight, analysis and reporting to fundraising and non‑fundraising teams in line with the standard responsibilities of the post.

Salary

The salary for this position is £41,125 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

• Deliver a time‑bound Business Intelligence project to migrate dashboards from Qlik to Power BI.
• Work with Heads of Fundraising and senior stakeholders to review the existing portfolio of dashboards to consolidate, rationalise, and simplify reporting aligned to charity priorities.
• Interrogate and, where necessary, amend existing data warehouse SQL extracts; understanding how data is sourced, transformed, and used across reports.
• Own QA, reconciliation, and documentation of migrated and redesigned dashboards, ensuring accuracy and stakeholder confidence.

Skills, Knowledge and Expertise

• Proven experience building and maintaining Power BI dashboards.
• Experience working with Qlik as well as rationalising legacy reporting.
• Strong, hands‑on SQL experience, including writing, reviewing, and amending queries against our MS SQL Server data warehouse.
• Ability to work with senior stakeholders to understand requirements and simplify complex reporting into clear, usable outputs.
• Strong attention to detail, particularly around data quality, validation, and reconciliation.
• Strong Excel skills (pivot tables, formulas, lookups).

Desirable

• Experience working with CRM systems (ideally Salesforce).
• Experience supporting fundraising, marketing or supporter analytics.
• Understanding of ETL processes and the data lifecycle in a reporting environment.

About The Team

You will join muc Insight, Research, Innovation and Supporter Data team—a collaborative group of professionals who use evidence and analysis to shape strategy, inspire innovation, and enhance supporter engagement. You’ll be working in a team featuring at least one fellow analyst, contributing to an environment that values curiosity, precision, and creativity.

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.

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.