Job Summary Table of Data Analyst

Job Description Summary

As a Data Analyst within King’s College London’s Philanthropy & Alumni Engagement department, you will transform data from multiple sources to produce high-quality reports, dashboards, and analysis that drive fundraising and alumni engagement strategies.

Responsibilities

• Produce high-quality, digestible reports, dashboards, and bespoke pieces of analysis for fundraising and alumni colleagues using data from multiple sources
• Lead on benchmarking projects, including data submission, interpretation, and presentation of findings
• Communicate complex information clearly to provide insight into the performance of various fundraising and engagement programs
• Transform source data efficiently from multiple data sources for import into Dynamics CRM system
• Work collaboratively with the Data Team and others to improve data quality
• Collaborate with IT colleagues and other users to shape future CRM features
• Liaise with other teams on new fundraising projects and initiatives to ensure reporting requirements can be met
• Manage multiple requests and prioritize workload within an Agile development approach

Benefits and Perks

• Hybrid working arrangement (minimum 40% office time, typically 2 days per week)
• Opportunity to work with an award-winning fundraising team
• Be part of an innovative organization making positive change globally
• Supportive and collaborative work culture
• Opportunity to develop technical skills with cutting-edge tools and technologies
• Indefinite contract offering job security

Company Overview

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 realizing its 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.

Company Culture

Philanthropy & Alumni Engagement (P&A) is 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. The department is strongly values-driven with a focus on sustaining an excellent and supportive culture, which they see as key to creating a successful team. The team has an impressive track record with awards such as a CASE Platinum Award for Fundraising and a CASE Gold Award for Donor Relations and Stewardship.

Career Growth Opportunities

The Data Analyst role offers significant opportunities for professional development, with the expectation that the successful candidate will embrace new technologies and ways of working. The position provides exposure to cutting-edge data analysis techniques and tools, as well as the chance to work with a diverse range of stakeholders across the university and its health partners.

Diversity, Equity, Inclusion, and Belonging

King’s College London prides itself on being inclusive and welcoming. They embrace diversity and want everyone to feel that they belong and are connected to others in their community. In P&A specifically, they aim to build a diverse team that represents the communities served by the organizations they support. The university is committed to working with staff and unions on these and other issues to continue to support their people and to develop a diverse and inclusive culture.

Equal Opportunity Statement

King’s College London is committed to equal opportunities and welcomes applications from candidates of diverse backgrounds. They 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.

Remote Work Policy

P&A has adopted a hybrid working approach, with a minimum of 40% of time spent in the office. Typically, this equates to two days per week, but the department welcomes colleagues who wish to be present more frequently.

Application Process

1. Submit your CV and a supporting statement detailing how you meet the essential criteria listed in the job posting
2. If shortlisted, attend a standard skills-based interview (scheduled for 9th-12th June)
3. If successful at the first stage, attend a Core Values interview (scheduled for 18th-20th June)

Application Deadline

Applications close on 01 June 2025.

How to Apply

To apply, visit the King’s College London Jobs website and click “Apply Now”. The full Job Description document can be downloaded from the next page after clicking “Apply Now”.

Social Media Links

Connect with King’s College London on LinkedIn, Twitter, and Facebook.

Additional Information

An “Ask Us Anything” Teams call will be held on Wednesday, 28th May at 3:00pm. During this call, you can ask questions about the role, the selection process, department values, work culture, hybrid work policy, or simply listen to others’ questions. To join, please email paul.hanson@kcl.ac.uk.

Data Analyst Requirements and Technical Skills

Essential Criteria for Data Analyst Role

To be successful in this role, candidates must demonstrate:

• Knowledge of data insight, analysis, and reporting techniques
• Significant experience working with a fundraising or marketing CRM in a technical, database management, or report writing capacity
• Strong SQL skills for efficient data manipulation and querying
• Experience 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 manipulating large or complex datasets with precision and attention to detail
• Ability to communicate complex and technical information clearly to diverse stakeholders
• Strong time management skills to handle conflicting deadlines and multiple priorities

Desirable Criteria

While not essential, the following skills and experiences would be advantageous:

• Knowledge of advanced data modeling and analysis techniques
• Experience using Microsoft Dynamics and associated applications such as Customer Insights
• Experience building dashboards within Microsoft Dynamics
• Knowledge of programming languages such as DAX and M
• Enthusiasm for learning new technologies and improving processes

King’s College London Strategic Vision

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:

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

This Data Analyst role represents an excellent opportunity to contribute to this vision by enabling data-driven decision-making within the university’s fundraising and alumni engagement functions.

Explore Blog Articles:

1. UK Skilled Worker Visa – Complete Guide
2. Sweden Job Seeker Visa – How to Apply
3. Portugal’s Job Seeker Visa – What You Need to Know
4. Germany EU Blue Card – Benefits and Requirements