Intergrated Data Management System (IDMS) Consultant at RTI International

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.