Intergrated Data Management System (IDMS) Consultant at RTI International

 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) ConsultantLocation: AbujaJob DescriptionThe 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 ResponsibilitiesPrimary 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 IDMSDesign the draft of E-WASH database architecture and schema that includes all required tables and jointsFollow up meeting with MIS specialist to present the database architecture and schema for inputsReview 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 schemaRun database queries to create all reports as contained in the MEL plan and/or SOWTest the database functionalities and generate prototype reports for review by MIS specialist, MEL Advisor and other technical advisorsRevise the reports queries based on the inputs made during the reviewDesign a draft E-WASH dashboard architecture for review by MIS Specialist and MEL AdvisorRevise and finalize dashboard architecture to incorporate feedback from MIS specialist and MEL ManageDevelop the E-WASH dashboard using the finalized and approved architectureDeploy the database and dashboard on a web server and/or E-WASH computers for testingEnter/import all available data and test the dashboard functionalitiesResolve all identified issues during dashboard testingComplete dashboard data entry/importsDeliver final product in form of deployed MIS on web server and copies of database and application source codes on an external hard drive storage deviceTrain MEL staff on dashboard report creation using queriesExpected IDMS componentsThe IDMS will consist of the following MEL System components and modules:Monthly, Quarterly and Annual Work PlansProgram 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 ReportsMEL RosterGIS Products and MapsMonthly, Quarterly and Annual Progress ReportsSurvey and Research Reports (including beneficiary Household reports, Collaboration Maps, Pivot Logs)Data Collection Matrix (DCM)Monitoring and Evaluation (M&E) reporting toolsKnowledge Management (KM) ProductsMEL Calendar and Task PlannerGeo-spatial data visualization dashboard 

Apply at