Data and Research Lead

Job Description

Data and Research Lead Location: DerbySalary: Commensurate with skills and experienceOur clients school, founded in 1557, is a leading co-educational School situated in the historic village of Repton. The School boasts a consistently fine academic record and is active and successful in a wide range of other activities. The School’s 600 pluspupils, both boys and girls, are predominantly boarders. Each belongs to one of the ten boarding houses. The school prides itself on its long and close association with the village.Main Responsibilities

• Database Management– manage, maintain and operate the database. Ensure that the database is developed, updated and run according to current data security protocols. Ensure that back-up and recovery processes are fit for purpose. Establish‘query/report request’ protocols.
• Data Quality Assurance– work through the School’s electronic and hard copy records to ensure that data held is accurate, relevant, up to date and lawful.
• Database Enhancement– work with software developers/providers to ensure the database is fit for purpose, accurate, accessible and secure. Liaise with developers on an ongoing basis to design, commission, install and implement new features,integrations and apps – or customise existing – and troubleshoot and solve issues.
• Data Importing– ensure that annual bulk data imports (of Upper Sixth records) are processed accurately and in a timely manner.
• Capacity Planning– analyse database usage patterns/trends to identify resource and upgrade requirements. Make recommendations as appropriate.
• Database User Management– establish the needs and training requirements of end-users. Manage and monitor appropriate permissions and access levels and ensure data security and integrity. Provide ongoing training and support to approvedusers, where required.
• Research– support the Development Director and Alumni Relations Manager in identifying donor prospects, mentors, speakers, case studies etc and generating guest profiles for events and fundraising purposes.
• Reporting and Analytics– produce accurate data, reports and performance metrics to aid in event planning, audience profiling and donor, campaign and event analysis.
• Financial Reconciliation– support Development Director in gift processing through recording and tracking donations and reconciling with Finance Department.
• Data Privacy Compliance–implement a robust process to ensure Data Protection Law 2018, UK GDPR and PECR regulations are adhered to with regard to all stored data and bulk data migrations.
• Other Duties– any other reasonable duties as requested by the Line Manager.

Skills & ExperienceEssential

• Knowledge of SQL
• Knowledge of Oracle, MySQL, Raiser’s Edge, Salesforce, Potentiality or similar RDBMS, preferably used within the education or charities sector
• The technical know-how and ability to manage a database, identify gaps both in data quality and database functionality, and propose and implement workable solutions
• The perseverance and attention to detail to work through historical electronic and hard copy records and update contacts accordingly to ensure data integrity
• Experience in interrogating and analysing data and running and interpreting reports, along with the ability to distil findings and complex data into easy-to-digest formats (to include metrics)
• Good understanding of the Data Protection Act 2018, UK GDPR and PECR
• Self-starter with ability to work independently within a small team
• Flexibility and willingness to support the team with other activities when required (e.g. event and ticketing support/administration, OR alumni/staff/supplier/visitor liaison and queries, marketing support, social media support etc)
• Excellent problem solving, analytical and communication skills

Desirable

• Understanding of the alumni engagement and fundraising landscape as it relates to data processes and requirements (e.g. knowledge of third-party platforms such as JustGiving, Mailchimp and Eventbrite, as well as Gift Aid processing following HMRC guidelines)

Benefits

• Competitive Salary
• Pension
• Life Insurance
• 25 Days’ Annual Leave, plus Bank Holidays, plus Christmas closedown
• Sports Centre Membership

To ApplyIf you feel you are a suitable candidate and would like to work for this reputable School, please do not hesitate to apply.The School is committed to safeguarding and promoting the welfare of children and young people and expects all staff and volunteers to share this commitment, therefore the following shall be deemed to be included, in addition to the duties that you maybe required to perform.Promoting and safeguarding the welfare of children and young persons for whom you are responsible and with whom you come into contact.Under the Sexual Offences Act 2003 it is a criminal offence for a person over 18 (e.g. teacher, matron, sports coach) to have a sexual relationship with a child under 18 where that person is in a position of trust in respect of that child, even if therelationship is consensual. This applies where the child is in full-time education and the person works in the same establishment as the child, even if s/he does not teach the child. Moreover, whatever the age of the pupil, a sexual relationshipbetweenan employee and a pupil will be considered an abuse of a position of trust and gross misconduct, likely to result in dismissal.