Data Analyst

King's College London - Supporter Operations

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 visualisation 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.