Jobs Career Advice Signup
X

Send this job to a friend

X

Did you notice an error or suspect this job is scam? Tell us.

  • Posted: Jan 22, 2019
    Deadline: Jan 31, 2019
    • @gmail.com
    • @yahoo.com
    • @outlook.com
  • Never pay for any CBT, test or assessment as part of any recruitment process. When in doubt, contact us

    RTI International is one of the world’s leading research institutes, dedicated to improving the human condition by turning knowledge into practice. Our staff of more than 3,700 provides research and technical services to governments and businesses in more than 75 countries in the areas of health and pharmaceuticals, education and training, surveys and ...
    Read more about this company

     

    Integrated Database Management System Consultant

    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

    Method of Application

    Interested and qualified candidates should submit a CV (not more than 5 pages) to STTA@ewash.rti.org  at not later than January 31, 2019 clearly specifying the position as the SUBJECT of the email.

    For further information about RTI International, please visit our website at www.rti.org

    We are proud to be an EEO/AA employer M/F/D/V

    Build your CV for free. Download in different templates.

  • Apply Now
  • Send your application

    View All Vacancies at RTI International Back To Home

Subscribe to Job Alert

 

Join our happy subscribers

 
 
Send your application through

GmailGmail YahoomailYahoomail