Vacancy title:
Monitoring and Evaluation Database Developer

Jobs at:
Coffey

Deadline of this Job:
open until filled

Duty Station:
Nairobi, Kenya

JOB DETAILS:
Coffey – Delivering technical excellence and innovative solutions to manage complex risk in challenging environments sets us apart from our competitors.
Our diverse portfolio of services in geotechnical, environmental, testing, project management and international development creates value across the asset lifecycle for our clients and communities
Jamii Thabiti is a £17.4m programme lasting from November 2015 to March 2019, which seeks to engage with the institutional reform efforts of key safety and security institutions at the national level and in eight counties, and engage with civil society to promote more effective, accountable and responsive safety and security services. The programme will increase security and safety for men, women and children in Kenya through improved capacity of communities and government actors to work together to prevent and respond to three forms of violence: criminal violence, inter-communal violence, and violence against women and girls (VAWG).
Reporting to:
RME Lead
Direct Reports:
None
Assignment scope and Purpose
The purpose of this consultancy is to design a stable and reliable M&E database, according to Jamii Thabiti programme needs. The overall objective is to have an integrated and improved Monitoring, Evaluation and Reporting database for Jamii Thabiti programme that will allow for timely and enhanced collection, analysis, visualisation, interpretation and dissemination of programme data and information.
The consultant/consultancy firm will be responsible for developing, testing, improving, and maintaining the new database to help users retrieve data effectively.
Key responsibilities

• Work in consultation with Jamii Thabiti Research, Monitoring and Evaluation (RME) team to produce a conceptual data model that reflects the structure of the information to be held in the database.
• Share the conceptual data model with Jamii Thabiti technical team for review and improvement
• Translate the conceptual data model into database formulas and other elements (schema) that implement the relevant data structures within the database.
• Design database ensuring that security features are included to protect and secure the database system.
• Design dashboards that help in reporting and providing attention to information including data cleaning/error check functions
• Work closely with the RME team to input existing Jamii Thabiti data into the database
• Pre-test the database for data analysis and produce reports for their immediate use.
• Present the designed data base to Jamii Thabiti for further review and feedback
• Develop technical and training manuals and train selected Jamii Thabiti Staff on database design, development and maintenance activities
• Provide remote technical support for 3 months. Jamii Thabiti will retain 10% of total payment for a period of three months following commissioning of the database. During this period, the consultant will provide technical back stopping support to database users, ensuring that any problems that arise with the database are effectively resolved

Key Deliverables

• Conceptual model design of database and dashboard interface
• Presentation of model database to Jamii Thabiti
• Existing Jamii Thabiti data inputted in the database
• Pre-test runs of database and dashboard
• Presentation of final functional database and dashboard to Jamii Thabiti
• Technical and training manuals developed
• Training of Jamii Thabiti staff on database utilisation and management
• Three months remote technical support

Qualifications and Experience
The consultant/consultancy firm should have the following expertise:

• A minimum of 5 years of experience in database design and roll out for development projects
• BSc degree in Computer Science or relevant field
• Proven experience to lead in the structural design of a databases
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Knowledge of software development and user interface web applications
• Hands on experience with SQL and MS Access
• Familiarity working with Net Framework, JavaScript, HTML and Oracle
• Advanced Knowledge on SharePoint online and best ways to leverage its functionalities
• Excellent analytical and organization skills
• An ability to understand front-end user requirements and a problem-solving attitude
• Excellent verbal and written communication skills

General requirements

• Adhere to the 10 principles for digital development
• Adhere to all security advice from Coffey’s Risk Management Team.
• Adhere to Coffey International Policies and Procedures as outlined in the Operations Manual.
• Adhere to Coffey International’s behaviours: Ingenuity, Collaboration, Respect, Intelligent Risk,
• Integrity and Delivery.
• Comply with and promote all Jamii Thabiti internal and global policies on child safeguarding, Fraud, conflict of interest, conflict-sensitivity, and Health and Safety

Job application procedure
Click here to apply:
https://secure.dc2.pageuppeople.com/apply/680/aw/applicationForm/initApplication.asp?lJobID=497220&sLanguage=en&sSourcePointer=aw&lJobSourceTypeID=796