Data Integration Officer

London (Greater) (GB)
Grade 5: £32,676 to £34,442 per annum, including London Weighting Allowance
Thursday, 8 April 2021
End of advertisement period
Monday, 3 May 2021
Contract Type
Fixed Term
Full Time

Job description

Fundraising and Supporter Development (F&SD) is an integrated department that provides a single fundraising and supporter engagement function for King’s College London, Guy’s and St Thomas’ Trust and for King’s Health Partners, working closely with the Maudsley Charity. Based at KCL, we work with colleagues across our partners to help them serve society through world-leading education, research and healthcare.

Working within the Data Team, the Data Integration Officer (fixed term contract) will lead on the design, build, test and rollout of number of data import routines, bringing data into our fundraising CRM (currently Raiser’s Edge 7.96) from a number of new platforms/ websites.  In addition, data exchanges of consent and communication preference data will ensure compliance and enable a joined up supporter experience.  Through clear documentation and training, you will provide colleagues with the confidence to use and maintain what you have built.

In response to recent research findings, you will also support the Database Manager in developing new segmentation and donor journeys for our Guy’s and St Thomas’ supporters.

As the organisation prepares to move to a new fundraising CRM (Microsoft Dynamics) you will support efforts to prepare data for migration, including the categorisation of data based on charity affinity, the extraction and indexing of imbedded media files, duplicate record management and the deletion of redundant data.

This post will be offered on a fixed-term contract for 12 months

This is a full-time post - 100% full time equivalent

Key responsibilities


  • Lead on the creation of new routines to manage the import of donation, event registration and fundraising, and email/ text marketing data from a number of new platforms into our Raiser’s Edge CRM
  • Establish other data exchanges to support our email marketing programme; particularly around consent and communication preferences
  • Clearly document and train team members in the use of any new processes
  • Taking a lead from the Database Manager, support the development of new segmentation/ donor journeys for our Guy’s and St Thomas’ supporter in response to recent research findings
  • Support the effort to prepare data for migration including, but not limited to, the categorisation of data based on charity affinity, duplicate record management and deletion of redundant data
  • Other projects – particularly related to the CRM migration project – as directed by the Senior Data Manager



The above list of responsibilities may not be exhaustive, and the post holder will be required to undertake such tasks and responsibilities as may reasonably be expected within the scope and grading of the post.

Skills, knowledge, and experience

Essential criteria

  • Experience of designing and building imports/ integrations using ETL tools
  • Working knowledge of VBA
  • Familiarity with CRM systems and the ability to quickly grasp new systems and processes
  • Excellent data management skills, and the ability to query and analyse data
  • Ability to work on your own initiative, make decisions independently, and think creatively
  • Ability to work to often tight deadlines and manage multiple priorities
  • Excellent communication skills, both written and verbal
  • Ability to convey complex information to a non-technical audience
  • Commitment to the department’s Core Values of respect, collaboration, ambition and accountability

Desirable criteria

  • Detailed knowledge of Raiser’s Edge CRM
  • Experience of building import routines using ImportOmatic

Further information

At present, Fundraising & Supporter Development staff are working from home, and this is likely to continue for some time.  As such, interviews for this role will take place on online.

Interviews are likely to take place week commencing …

About Fundraising & Supporter Development

Fundraising and Supporter Development (F&SD) is an integrated department that provides a single fundraising and supporter engagement function for King’s College London, Guy’s and St Thomas’ Trust and for King’s Health Partners, working closely with the Maudsley Charity. Based at KCL, we work with colleagues across our partners to help them serve society through world-leading education, research and healthcare.

We operate a unique and powerful model, which brings together fundraising for all our partners across major and principal gifts; trusts & foundations; legacies; corporate engagement and mass fundraising. We also promote KCL’s engagement with its worldwide alumni community, as well as engaging more broadly with supporters of all our partners. Our work is underpinned and enhanced by a range of professionals in areas such as donor relations, communications and marketing, prospect research, finance, data, supporter services and general administration. By pooling our passion and expertise to support the university and our health partners, our potential and impact is maximised.

We have an impressive, well-established track record of success in securing support that allows our partners to deliver on their missions. This includes our global, award-winning World Questions: King’s Answers campaign for KCL, 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 across the higher education and charity sectors, including the CASE Platinum Award for Fundraising.

We continue to set ourselves high standards and expectations in terms of supporting our partners, mapping out ambitious fundraising campaigns and appeals where we want to achieve ground-breaking milestones in areas such as children and young people’s mental health; sickle cell disease; cardiology; cancer; global women’s leadership; engineering; international relations and support for students who will go out and make a difference in the world. We are a strongly values-driven team, maximising the benefits of working across organisations and united in our ambition to support out partners in making a real and positive difference to the world we live in.

Our Partners

King’s Health Partners

King’s Health Partners (KHP) is an Academic Health Sciences Centre and a partnership between King’s College London and three NHS Foundation Trusts – Guys and St Thomas’, King’s College Hospital and South London and Maudsley. We bring together 40,000 NHS Staff with 30,000 students and researchers to join up world class research, education and pioneering clinical practice. Our partnership sees 4.8 million patient contacts each year. Academic Health Sciences Centres are engine rooms of high impact and innovation discovering new insights into disease, transforming diagnostics and unlocking new therapies. We speed up the time it takes to translate research and high impact innovations in physical and mental health into outstanding patient care. We do this by working in dedicated clinical academic groups and institutes and by involving more and more people in clinical trials and research. For more information, visit:

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, KCL is creating positive change in its communities, both in London and on the world stage. The Strategic Vision 2029 looks forward to KCL’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.

Guy’s and St Thomas’ NHS Foundation Trust

Guy’s and St Thomas’s Trust is among the UK's busiest and most successful foundation trusts, with a long history of clinical excellence and high quality care.  The Trust is made up of two of London's best known teaching hospitals – St Thomas' Hospital and Guy's Hospital. It also includes Evelina London Children’s Hospital and both adult and children’s community services in Lambeth and Southwark.

Dedication to the communities it serves is at the heart of everything the Trust undertakes, providing high quality and personal care. The Trust is guided by its values: putting patients first, taking pride in what we do, respecting others, striving to be the best and acting with integrity.

Royal Brompton and Harefield hospitals became part of Guy's and St Thomas' in February 2021, bringing together world-leading expertise and research in heart and lung disease.