Database Coordinator July 2014
EveryChild Application Pack
Database Coordinator
12 month fixed term contract (maternity cover)
Deadline for applications: Sunday 31st August 2014
Contents Letter from CEO Job Description Terms and Conditions
Database Coordinator July 2014 Dear Applicant
Thank you for your interest in this role at EveryChild. Please find enclosed the application pack.
EveryChild is an international development charity working to stop children growing up vulnerable and alone. We are passionate about our vision for a world in which every child has the chance to be cared for safely in a family. By joining us you will be contributing to achieving that vision. We believe that we can achieve significantly greater impact by bringing together national organisations working directly with children and families all over the world and that is why we are leading the development of a new global alliance, Family for Every Child, which will be launched in 2014. We hope we can build on the excellent reputations of EveryChild and other founding members of Family for Every Child to become a lead player in the international arena, demonstrating how change can be better led from developing countries.
To achieve this pioneering model for development, EveryChild is going through significant change. Staff are part of that change and have the opportunity to contribute their skills and experience to making it happen.
We are fortunate to have extremely hard working staff and partners who share the vision, mission and values. It is their commitment to improving the lives of children, together with the creativity, energy and determination of the communities with whom we work, that enables us to meet our goals and achieve real and lasting change.
To apply for this post, please complete the Application Form and the Recruitment Monitoring Questionnaire, and return them to Maria Tsang, HR Advisor:
Post: 4 Bath Place, London EC2A 3DR Fax: 020 7729 8339 (FAO Maria Tsang) Email: [email protected]
Due to limited resources, we will only contact you if you have been short listed for interview. Candidates invited to second interview from within the UK may apply for travel expenses. Thank you for your interest, and good luck.
Yours faithfully
Anna Feuchtwang
Database Coordinator July 2014
Job Description
Job Title: Database Co-ordinator
Reporting to: Supporter Care Manager
Location: London
Job Purpose
The Database Co-ordinator is responsible for the maintenance and support of the fundraising database (iMIS). The database runs Microsoft SQL server 2005 and this position is responsible for its day to day running including maintenance, reporting and optimisation. This entails providing front line user support, carrying out pre-defined and ad-hoc import and export routines, and supporting the generation of regular payment files. In addition this position will provide support to the Supporter Care Manager in creating and delivering ad-hoc reports to be used to analyse our supporter base maintaining data integrity.
Scope and Limits of Authority
Reporting to the Supporter Care Manager, the Database Co-ordinator is responsible for the day to day maintenance and support of the organisational fundraising database (iMIS) as well as supporting a Database Officer. The post holder will proactively support the development of the database and will be the main contact for any database queries within the organisation.
Areas of Responsibility
Management of the IMIS database and in particular the delivery of the following: Database maintenance and support
1. To use SQL server to maintain database and provide reports for various departments within the organisation.
2. To be proactive in reviewing the database requirements for EveryChild providing technical expertise and support to the Supporter Care Manager, providing options for how to take the database forward.
3. To act as a first point of contact for database support issues and queries from Supporter Care, Sponsorship, Finance, Supporter Development and Sponsor and Key Supporter departments.
4. To complete reports detailing progress of development and problems within database and the solutions and decisions taken to resolve these.
5. In agreement with Supporter Care Manager, liaise with iFINITY support to resolve complex database issues.
Database Coordinator July 2014
6. To work with external agencies to set up and run data import procedures (of new supporters, etc) aiming to streamline import processes where possible.
7. Organising training/induction of new iMIS users and ongoing support for relevant teams to ensure users are proficient in the use of the system.
8. To ensure data quality is maintained and that cost effective options are applied to capture, update and clean data.
9. Work closely with ICT to ensure database and ICT updates do not interrupt iMIS users and processes continue to run, documenting any challenges updates cause.
10. To provide other reports and development as agreed by the Supporter Care Manager.
Support of Financial Processing
11. To correct any inconsistencies with batches generated for Credit Card and Direct Debit payments due for submission to BACS/Sagepay using SQL server
12. To importing warm gift payment files for Direct Marketing mailing and telemarketing appeals
13. To provide weekly transaction/upload reports to the Finance department.
14. To Run the Gift Aid claim from iMIS providing the data for EveryChild to claim Gift Aid income worth approximately 10% of EvC’s income.
15. To Provide data for annual Gift Aid refunds and liaise with HMRC and Finance on queries
Supporter Development Support
16. Select and prepare warm appeal mail-files from the database, and advise on selection criteria where required.
17. Weekly data integrity checking to allow accurate data selections for Supporter Development activity
18. To set up automated regular letters
Sponsor and Key Supporter Support
19. Support the Sponsorship Migration Project process with data selections, data integrity, data cleansing as well as disenrollments
Key Relationships and contacts
Internal
Supporter Development team Finance team
Sponsor and Key Supporter team Supporter Care team
Database Coordinator July 2014 Docdata Mailing fulfilment
NTT and GoGen Telemarketing agency HMRC for Gift Aid queries
CAF (Charities Aid foundation)
iFINITY for database support and development Experian QAS Bottomline WinBACS
PERSON SPECIFICATION
Attributes/Requiremen
ts
Essential
Desirable
Education / Qualifications and Knowledge
1. Degree level or equivalent experience in Transact SQL
2. Demonstrable knowledge of the concept of relational databases
3. Knowledge of the maintenance of MS SQL databases
4. Knowledge and proficiency in MS SQL environment, including creation and maintenance of Views, Stored Procedures and Triggers.
5. Demonstrable knowledge of relational database concept, including table design
6. Demonstrable knowledge of the concepts of direct marketing
Experience 7. previous experience in a Database
related role
Skills and Abilities 8. Excellent organisational skills
9. Excellent communications skills, both written and verbal
10. Ability to stay calm under pressure 11. Problem solving and diagnostic skills 12. Previous experience of training staff 13. Proficiency in MS Office (currently 2010) 14. Proficiency in Cristal Reports (currently
Database Coordinator July 2014
version 9)
15. Proficiency in SSRS
General 16. Commitment to the aims and objectives
Database Coordinator July 2014
Terms and Conditions
Length of Contract/ Notice period
12 month fixed term contract (maternity cover)/ 1 month
Salary Package £29,787 - £31,715
Annual Leave
25 days per year 3 day winter closure 8 days bank holidays
Length of service award – 1 additional day annual leave for every year of service up to a maximum of 30 days.
Sick Leave
Sickness entitlement following completion of probation is 8 weeks full pay and SSP for an additional 20 weeks within a 52 week period
Study Leave
Employees can apply for up to 10 days study leave per year as a part of our professional development programme.
Family friendly
Enhance maternity leave and pay – up to 3 months full pay for eligible employees
Enhanced paternity leave and pay – up to 2 weeks full pay for eligible employees
Child care vouchers – tax saving scheme
Parental leave – up to 16 weeks unpaid leave available to eligible employees
Flexible working – employees can make formal requests to work more flexibly
