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
