Data Analyst

Organisation
King’s College London
Locations

London, UK

Application Deadline
Salary
£38,482 - £41,130

Philanthropy & Alumni Engagement (P&A) provides a fundraising and alumni engagement function in support of King’s College London. We are proud to work with colleagues across the university and its health partners to help them serve society through world-leading education, research and healthcare. Our work also includes a partnership with the Maudsley Charity in support of children’s mental health initiatives between the university’s Institute of Psychiatry, Psychology and Neuroscience and the South London & Maudsley NHS Trust.

We are a committed team that brings together fundraisers working across different channels, alongside colleagues who promote King’s College London’s engagement with its worldwide alumni community. Our work is underpinned and enhanced by a range of dedicated professionals in supporting areas covering proposition development, supporter engagement, supporter operations and business operations.

We have an impressive, well-established track record of success in securing support that allows the university and partners to deliver on their missions. This includes our global, award-winning World Questions: King’s Answers campaign, which set the standard in the sector and enabled us to raise substantial funds to help tackle some of the world’s biggest challenges. Ambitious and innovative, the team has won awards such as a CASE Platinum Award for Fundraising and a CASE Gold Award for Donor Relations and Stewardship. We are strongly values-driven with a focus on sustaining an excellent and supportive culture, which we see as key to creating a successful team that can support the university and its partners in making a real and positive difference to the world we live in.

More on King’s College London

King’s College London is an internationally renowned university delivering exceptional education and world-leading research. The university is dedicated to driving positive and sustainable change in society and realising our vision of making the world a better place.  Through its commitment to exceptional education, impactful research and genuine service to society, King’s College London is creating positive change in its communities, both in London and on the world stage. The Strategic Vision 2029 looks forward to King’s College London’s 200th anniversary in 2029 and sets out ambitious plans in five key areas: 

  • Educating the next generation of change-makers;
  • Challenging ideas and driving change through research;
  • Giving back to society through meaningful service;
  • Working with our local communities in London;
  • Fostering global citizens with an international perspective.

About The Role

The Data Analyst works within the Data Team, using and transforming data from multiple sources to produce high quality, digestible reports, dashboards, and bespoke pieces of analysis for our fundraising and alumni colleagues. You will also lead on any benchmarking projects, both the submission of data and the interpretation and presentation of their findings. Being a clear communicator of often complex information, you will deliver insight into the performance of our various fundraising and engagement programmes, giving colleagues the information they need to continually innovate and improve.

In addition, you will have a raft of technical skills and approaches that will enable you to efficiently transform source data from multiple data sources ready for import into our Dynamics CRM system.

You will be keen to learn and develop, embracing new technologies and ways of working, and will work with the Data Team and others across the department to improve the quality of the underlying data we all rely on. You will also work closely with others in the team, IT colleagues and other users across the organisation to shape future CRM features.

You will be required to liaise and work collaboratively with other teams on new fundraising projects and initiatives, thereby ensuring a joined-up approach, that future reporting requirements can be met, with learning shared and insight retained. You will often need to manage multiple requests and prioritise your workload, albeit we have adopted an Agile approach to development.

This is a full time post (35 hours per week), and you will be offered an indefinite contract. P&A has a hybrid working approach, with a minimum of 40% of time in the office. Typically, this equates to two days per week, but we’re very happy for colleagues to be in more frequently if they so wish.

About You

To be successful in this role, we are looking for candidates to have the following skills and experience:

Essential Criteria

  • Knowledge of data insight, analysis and reporting techniques
  • Significant experience of working with a fundraising or marketing CRM in a technical, database management or report writing capacity
  • Strong SQL skills
  • Experience of building reports and dashboards using Power BI or other data visualization tools
  • Ability to create data transformations using tools such as Power Query, Power Automate and/or VBA macros
  • Experience of manipulating large or complex datasets
  • Ability to communicate often complex and technical information in a clear and digestible way to a wide range of stakeholders, both internal and external
  • Experience of managing conflicting deadlines and multiple priorities

Desirable criteria

  • Knowledge of data modelling/ analysis techniques
  • Experience of using Microsoft Dynamics and its associated applications such as Customer Insights
  • Experience of building dashboards within Microsoft Dynamics
  • Knowledge of other programming languages, such as DAX and M
  • Restless enthusiasm for learning new technologies and improving processes

Downloading a Copy Of Our Job Description

Full details of the role and the skills, knowledge and experience required can be found in the Job Description document, provided at the bottom of the next page after you click “Apply Now”. This document will provide information of what criteria will be assessed at each stage of the recruitment process.

Further Information

We pride ourselves on being inclusive and welcoming. We embrace diversity and want everyone to feel that they belong and are connected to others in our community. In P&A we want to build a diverse team, which represents the communities served by the organisations we support.

We are committed to working with our staff and unions on these and other issues, to continue to support our people and to develop a diverse and inclusive culture at King's. We are open to discussing flexible working arrangements, including part-time, compressed hours and/or job shares, as appropriate and in the context of the business needs associated with the role.

We ask all candidates to submit a copy of their CV, and a supporting statement, detailing how they meet the essential criteria listed in the advert. If we receive a strong field of candidates, we may use the desirable criteria to choose our final shortlist, so please include your evidence against these where possible.

To find out how our managers will review your application, please take a look at our ‘ How we Recruit’ pages.

We offer the opportunity of an “Ask Us Anything” Teams call on Weds 28th May 3:00pm. During this call you will be able to ask any questions you might have about the role, the selection process, our department, our core values and work culture, our current hybrid work policy, or simply listen to others’ questions. To join please email paul.hanson@kcl.ac.uk.

This roles with have two interview stages, a standard skills-based interview followed (for up to two appointable candidates) by a Core Values interview.

First stage interviews are due to be held on 9th-12th June.

Core Values interviews are dure to be held on 18th-20th June.

Grade and Salary: £38,482 - £41,130 per annum, including London Weighting Allowance

Job ID: 115105

Close Date: 01-Jun-2025


Featured Jobs

Cornerstone Research

London, UK

June 05, 2025

Ofgem

Cardiff, Glasgow, London

May 27, 2025

Dementia UK

Aldgate, London

June 02, 2025

Care Quality Commission

United Kingdom

May 26, 2025

Oxford University Hospitals NHS Foundation Trust

Headington, Oxford, UK

May 26, 2025

Ofgem

London, Glasgow and Cardiff.

June 02, 2025

Our Partners

Logo for Bank Of England
Logo for Cma
Logo for Frontier
Logo for Logo
Logo for Amazon
Logo for Dstl

Like what you see?

Post a job