RTI International is an independent, nonprofit research institute dedicated to improving the human condition. Clients rely on us to answer questions that demand an objective and multidisciplinary approach—one that integrates expertise across the social and laboratory sciences, engineering, and international development. We believe in the promise of science, and we are inspired every day to deliver on that promise for the good of people, communities, and businesses around the world.
We are recruiting to fill the position below:
Job Title: Intergrated Data Management System (IDMS) Consultant
Location: Abuja
Job Description
The Effective Water, Sanitation and Hygiene (E-WASH) program is seeking to identify a 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
Demonstrated experience in design and development of web-based management information system with performance management module;
Demonstrated strength and experience designing and developing similar systems 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 e.g. experience handling queries for Automated Directive Systems (ADS) for performance monitoring and indicator reporting;
Ability to demonstrate sample databases with similar database schema;
Shortlisted candidates will be required to come with similar works for demonstration during interview.
Application Closing Date
8th April, 2019.
Method of Application
Interested and qualified candidates should submit a CV (not more than 5 pages) to: STTA@ewash.rti.org clearly specifying the position as the SUBJECT of the email.