Integrated Database Management System Consultant at RTI International

Share this story
RTI (www.rti.org) is an independent, non-profit organization dedicated to conducting innovative, multidisciplinary research that improves the human condition. With a worldwide staff of more than 5,000 people, RTI offers innovative research and development and multidisciplinary services.
RTI International in collaboration with Plan International and other partners is implementing a 4-year USAID funded Effective Water, Sanitation and Hygiene (E-WASH) project. E-WASH will provide technical assistance to state governments to improve urban water service delivery by strengthening the governance, financial, and technical viability of six (6) state water boards (SWBs) in Nigeria. This is part of the United States Government’s (USG) efforts working with the Federal Government to address the heart of the challenges faced by the urban water, sanitation, and hygiene (WASH) services. The overall goal is improvement of urban water and sanitation service delivery.The Effective Water, Sanitation and Hygiene (E-WASH) project, is seeking to identify an Abuja based IDMS consultant to develop and deploy Integrated Database Management System (IDMS) for data management and performance reporting to the project and USAID. The IDMS shall be the main repository of all Monitoring, Evaluation and Learning data and will be used for aggregating and analyzing activity-related information. All program reporting tiers will be categorized and are tagged with appropriate themes. All relevant output, outcome, and/or process indicators will also be selected and recorded in the database. The IDMS will be used to facilitate effective Knowledge Management (KM) for all reporting deliverables.This platform will be managed by the MIS Specialist and MEL Advisor to ensure quality control to facilitate the collation of all MEL related reports and developed reporting tools. The IDMS will be designed to facilitate effective grants monitoring by tagging Activity Monitoring Reports (AMRs) to associated grant milestone deliverables for each awarded CSEF grant; in this way, the MEL team will be able to effectively ascertain the performance of individual grantees on an ongoing basis. This will also highlight non-performing grants and identify red-flags for the program team (i.e. propose corrective actions) to follow up.The platform shall produce Activity Monitoring Reports (AMR) with its data pulled from specified templates in the IDMS which shall be routinely updated by the Performance Monitoring Specialist (PMS). Final Monitoring Report (FMR) will be generated by the MIS specialist at the end of each completed CSEF grant. The FMR will serve as an information depository to inform feedback into E-WASH activity for onward performance improvements.Key responsibilities:Primary responsibilities include, but are not limited to the following:

Initial meeting with MEL Advisor and MIS specialist to discuss the scope of work and answer any questions regarding the development of IDMS
Design the draft of E-WASH database architecture and schema that includes all required tables and joints
Follow up meeting with MIS specialist to present the database architecture and schema for inputs
Review revise and update database schema based on the input of MIS specialist and develop the E-WASH database tables and stored procedures based on the revised schema
Run database queries to create all reports as contained in the MEL plan and/or SOW
Test the database functionalities and generate prototype reports for review by MIS specialist, MEL Advisor and other technical advisors
Revise the reports queries based on the inputs made during the review
Design a draft E-WASH dashboard architecture for review by MIS Specialist and MEL Advisor
Revise and finalize dashboard architecture to incorporate feedback from MIS specialist and MEL Manage
Develop the E-WASH dashboard using the finalized and approved architecture
Deploy the database and dashboard on a web server and/or E-WASH computers for testing
Enter/import all available data and test the dashboard functionalities
Resolve all identified issues during dashboard testing
Complete dashboard data entry/imports
Deliver final product in form of deployed MIS on web server and copies of database and application source codes on an external hard drive storage device
Train MEL staff on dashboard report creation using queries

Expected IDMS components:The IDMS will consist of the following MEL System components and modules;

Monthly, Quarterly and Annual Work Plans
Program Implementation Plans (PIPs)
Performance Monitoring Plan (PMP)
Indicator Performance Tracking Table (IPTT)
SWB Service Improvement Plan (SIP)
SWB Action Plan (AP)
Activity Monitoring and Evaluation Plan (Specific MEL Plan)
SWB Performance Based Contract (PBC)
Grants Monitoring Reports (GMRs)
Activity Monitoring Reports (AMRs)
Final Monitoring Reports (FMRs)
After Action Reviews (AARs) and After Exit Reviews (AERs)
Ad-hoc and Evaluation Reports
MEL Roster
GIS Products and Maps
Monthly, Quarterly and Annual Progress Reports
Survey and Research Reports (including beneficiary Household reports, Collaboration Maps, Pivot Logs)
Data Collection Matrix (DCM)
Monitoring and Evaluation (M&E) reporting tools
Knowledge Management (KM) Products
MEL Calendar and Task Planner
Geo-spatial data visualization dashboard

Qualifications and Experience:

A minimum of B.Sc. degree or HND in Computer Science, information technology, statistics or related field with experience in management information system design and development
A minimum of eight (8) years of progressive, relevant work experience in database and web application design/development using Microsoft technologies
Demonstrated strength and experience providing similar technical assistance with international development project
Prior experience developing data management system with USG-funded programs is preferred;
Expert knowledge of integrated database design and development with Microsoft SQL server
Expert knowledge of web application development with Microsoft ASP.net framework
Expert knowledge of geo-spatial or web GIS dashboard development
Evidence of similar work done for USG-funded or other international development project