University of London
Job Title: Database Assistant
Department: Vice Chancellor’s Department
Section: Development Office
- The University of London has the largest known alumni database of any University in the UK. This role will support and develop the University’s Blackbaud CRM Database ‘Senator’.
- The Database Assistant will update Senator as part of a programme of data cleaning and deduplication, including biographical, educational, financial and address data in accordance with data protection legislation.
- Data Entry: Enhance the quality of the data that we hold on Senator in accordance with data protection legislation and the University of London’s policies on information security by,
- Working as part of the Development Operations team to clean and de-duplicate data, including biographical, educational and address fields.
- Adding individual records to the database and in batch import where appropriate.
- Assisting with adding new and existing University of London datasets to the database as they become available.
- Cleaning database records highlighted in integrity reports.
- Assisting with the manual data entry of all Development Office activity (both past and current), ensuring that this is imported into Senator accurately.
- Ensuring the highest levels of data quality and accuracy.
- To support the Database Officer, in particular in the areas of:
- Providing training and produce training materials for new and existing users.
- Providing database support to members of the Development Office and users of our systems across the University of London.
- Producing and developing standard reports, ad hoc queries and KPIs.
- Gift processing, coding, administration and acknowledgment
- Importing data through batch and downloading from our online system BBIS
- Developing written procedures
- Assisting with database configuration
- Liaising with Blackbaud technical support
- Creation of event and payment pages on BBIS.
- Work with Development Office and University of London staff to understand data requirements.
- To actively follow and promote the University of London policies, including the University's Dignity at Work and Equal Opportunities Policy and actively promote these wherever possible.
- To maintain an awareness and observation of fire and health and safety regulations.
- Any other duties consistent with both the grade and scope of the post.
- Any other duties reasonably required of the postholder by the reporting manager
Reports to: Database Officer
Responsible for: N/A
Additional demands of the role:
To deliver services effectively, a degree of flexibility is needed.
Experience and Personal Qualities
- An interest in higher education or charity sector fundraising.
- An interest in data management and data quality.
- Experience of manually entering large volumes of data accurately.
- A methodical and inquisitive approach to data and database management with a willingness to learn, ask questions and provide new ideas and solutions.
- Excellent communication skills, evidenced by the ability to understand and communicate verbally and in writing to both technical and non-technical audiences.
- Ability to collect and assess information rapidly, identifying key points and drawing conclusions.
- Exhibit strong organisational skills, including the ability to take projects to completion with a high level of independence, the ability to work on multiple tasks and to prioritise competing deadlines.
- Availability to work during office hours both in and outside of the academic term.
- Commitment to delivering timely, high-quality service and support for the Development Office.
- An interest in current database technologies and developments in the Higher Education or fundraising technology market.
- Experience of working with a relational database and the data entry process to maintain data quality and integrity.
- Knowledge and experience of handling confidential information in line with the Data Protection Act.
- Experience of working in a fundraising office.
- Demonstrate initiative and problem solving ability in identifying and solving issues occurring on database systems.
- Experience of data analysis and data visualization.
- Knowledge or experience of the University of London student, alumni or staff experience.
Technical Knowledge and Skills
- Excellent MS Office skills, including Excel, Word, Outlook and or equivalent.
- Experience of Blackbaud products and systems such as Blackbaud CRM/Enterprise, Raiser’s Edge, BBIS, Net Community and Blackbaud Merchant Services.
- Experience of analysing and reporting on large data sets, including financial data.
Education and Professional Qualification
- Working knowledge of and Asian or European language other than English.
Proactivity and planning
Working collaboratively with others
Problem solving and decision making
Creativity and innovation
Striving for excellence
Self-development and commitment to learning
Adapting to change
Competencies are scored on an A-D scale, with D representing the highest demonstration of the competency.
For further information on each of the competencies and relevant levels, please refer to the University’s Competency Model http://www.london.ac.uk/5258