WWGS Database Administrator (based in Dublin)

Self Help AfricaCareers - Ireland

Job Title: WorldWise Global Schools (WWGS) Database Administrator
Programme: WorldWise Global Schools
Location: Self Help Africa Head Office, Kingsbridge House, 17-22 Parkgate Street, Dublin 8, D08 NRP2 (Flexible)
Contract Type: Full-time (5 days/week) fixed term contract for 1 year
Salary: €40,000-€45,000
Reports to: WorldWise Global Schools Deputy Director

Job Purpose
Database development and maintenance has been identified as a strategic objective for WWGS, to ensure effective and efficient programme systems as it continues to work with growing numbers of schools and stakeholders.

The WWGS database is central to all programme processes, including: grant administration, events, finances, communications and reporting. It is also used to generate regular updates and reports to the programme’s funder, Irish Aid, and enables the WWGS programme to be responsive to the GCE needs of the post-primary sector.

The Database Administrator will be responsible for managing the growing WWGS database, including the updating of existing data systems and migrating of data from Excel onto Salesforce. (S)he will also consolidate and develop WWGS systems of data collection and analysis, in order to improve and refine programme reporting and inform future programme developments. The Database Administrator will need to work in collaboration with members the WWGS staff team to deliver a strengthened system of data collection, analysis and reporting.

Key Areas of Responsibility:

Metadata Management
• Maintain, develop and test WWGS online user interfaces, primarily for WWGS Global Passport applications, grant applications, grantee reporting and the online teacher expenses system. This will involve amending existing interfaces annually.
• End to end management of WWGS database and interface.

Technical Support
• Provide ongoing internal technical support to resolve issues arising within the online portals, particularly during the Global Passport applications process and throughout the Annual Grant Call.
• Identifying and correcting performance issues, and reviewing systems and error logs.
• Identify, optimize and trouble shoot poorly performing or broken SQL stored procedures.
• Collaborate with Chief Information Officer to optimize WWGS database where necessary
• Build the capacity of the WWGS staff team where relevant
• Documenting all WWGS database processes.

Data Generation, Storage, Collation & Reporting
• Contribute to fulfilling all reporting requirements to Irish Aid (half yearly reports in March and September annually)
• Generate data to populate relevant indicators on the WWGS results-based framework (RBF) on an ongoing basis
• Collation of relevant data to generate meaningful data reporting
• Ensure that a comprehensive and accessible system of filing data is in place, to store data generated (using WWGS cloud storage on Box).
• Generation of reports on key programmes areas such as on the Global Passport, Grant Applications, WWGS interventions.

Data Integrity & Maintenance
• Maintain and expand the WWGS database in order to generate a clear statistical overview of all GCE engagement by engaged post-primary schools (namely grants cycle overview and award programme overview). This includes migrating data currently saved in Excel onto Salesforce.
• Ensure the WWGS database is up to date and accurate.

Data Presentation Views
• Run and save data reports and templates as and when required, as well as creating regularly updated views that can act as overview tools for the whole team.
• Enhance WWGS programme data visualization.

Data Schema Design and Architecture
• Undertake data field mapping to outline how the WWGS database can grow and function efficiently on the Salesforce platform

General Administration
• Provide general administrative support to the programme team throughout the year as required.
• Ensure all time records, annual leave requests, and expense claims are submitted for approval on a timely basis via Salesforce.
• Assist with updating of systems and policies in adherence with General Data Protection Regulation (GDPR)

Key Relationships
• WWGS Programme Director
• WWGS Deputy Director
• WWGS Grants & Operations Officer
• WWGS Education Officers
• SHA ICT Department
• SHA Chief Information Officer
• WWGS grantees and programme participants (primarily teachers)
• Coordinators from GCE NGOs and Networks

Knowledge, Experience & Skills
• Demonstrable knowledge and experience of working with databases
• 2 years of specific experience of Salesforce essential
• Strong Salesforce administration and support skills, and strong SQL server database and administration support skills.
• Advanced problem solving and trouble shooting skills.
• Ability to communicate effectively within a wider team.
• Experience working independently and in a team oriented collaborative environment.
• Demonstrable knowledge and experience of SQL/SOQL
• Strong data modelling and project planning skills
• Strong IT proficiency and experience with Microsoft Office, particularly Excel
• Excellent attention to detail and report writing/generating skills
• Creativity and commitment to deliver results
• Ability to work effectively alone and as part of a team
• Demonstrable knowledge/experience of the post-primary and/or GCE sector

Role Competencies
Managing yourself – Holds an awareness of own abilities and areas for development; adapts and uses abilities to work well with others and to help achieve objectives. Communicating and working with others – Uses the most appropriate channel to share information with others both inside and outside WWGS; adapts the message to meet the communication needs of the audience.
• Delivering results – Systematically develops plans towards achieving WWGS objectives and delivers on commitments; uses appropriate techniques to help achieve agreed objectives.
Planning and decision-making – Systematically develops plans towards achieving WWGS’ objectives and delivers on commitments; makes clear, informed and timely decisions appropriate to role, in the interests of WWGS and those we work with.
Creativity and innovation – Seeks out, develops and successfully implements new ideas that further the needs of WWGS and those we work with; builds on proven approaches and learns from ongoing work to improve it.

How to Apply:

Candidates must be legally entitled to work in Ireland at the time of application.

Please upload a completed Application Form, CV and cover letter outlining your suitability for the role here

Please note incomplete applications will not be considered for shortlisting.

Download JD here

Closing date is 17th August 2020 by 5pm

Interviews are provisionally scheduled for beginning of September 2020.

Self Help Africa is an Equal Opportunities Employer

Any candidate offered a job with Self Help Africa will be expected to sign Self Help Africa’s Safeguarding Policies and Code of Conduct as an appendix to their contract of employment and agree to conduct themselves in accordance with the provisions of these documents.

This role will require garda vetting.