Consultant II - Development of RSSH Grant Data Use Products at Management Sciences For Health - MSH

Job ID: 13-11058
Group/Office: PDG (Program Delivery Group)
Dept/Unit: PDGGEN - Program Delivery Group
Project/Program: A607 - Nigeria Global Fund RSSH
Reports To: Director HMIS
Grade: Consultant

Overview

• Data use is central to communicating the effect of the program and it is also very useful for improving decision making to enhance achievement of program goals.
• Data visualization, i.e. use of graphics, plots, dots, lines, or bars information graphics and other format, is a very effective and efficient method of communicating results to diverse stakeholders as it presents data in a format which helps decision makers and other users to quickly and properly understand the data. This allows the audience to make sound decisions.
• This will require that the information presented must be up to date and readily available in a format that is user friendly, easily accessible and consistently available (some of the issues to be addressed by the GF RSSH grant).
• When finalized, the grant use products will be configured into an interactive billboard to showcase the grants’ performance over time, using data visualization approach.
• The grant interactive billboard will allow data disaggregation by a multiplicity of indices including disease areas, sector (public and private), state, LGA, facility, year and month (to the extent of the disaggregation available in the data).

Specific Responsibilities
Scope of Work for Consultant:

• Review the GF RSSH performance indicators, definition, disaggregation and targets
• Review the CaTSS interactive billboard
• Discuss with the various stakeholders (MSH GF RSSH Directors, MSH IT specialist, MSH personnel engaged in the development of the CaTSS billboard, SR PIUs, HISP) on the information which may stimulate action by the various stakeholders at all levels and the various data use products that should be produced
• Document and validate the requirements of the interactive billboard
• Develop a first version of the user-friendly interactive billboard (using Power BI) based on the validated requirements. Note that the interactive billboard should (among others) allow users to: drill down to obtain required information up to the limit of the available disaggregation in the data set, upload data from a spreadsheet, enter data manually into the application.
• Test the first version of the interactive billboard to identify and fix any bugs that may be discovered
• Present the tested version of the interactive billboard to stakeholders for comments
• Collate and use relevant feedback from the stakeholders to finalize the billboard
• Work with MSH to test run the interactive billboard and ‘place’ it in an appropriate location
• Prepare a user’s manual/guide for the interactive billboard

Deliverables:

• Report of the meeting/engagement with stakeholders to identify the various information required to be presented in the grant interactive billboard
• Validated interactive billboard requirements
• Functional Grant Interactive Billboard developed in Power BI and available to all stakeholders
• Guidance document on how to use the interactive billboard
• Codes used to develop the billboard and other required documentation (e.g. architecture, etc)

Timeline:

• This assignment is for an estimated Level of effort of 7 days only for one consultant.

Qualifications and Experience

• The Consultant possess a graduate degree in Computer Or Information Science with at least 4 years of developing or managing interactive systems for reporting and; have evidence of work done in Nigeria in the area. A post graduate degree will be an added advantage
• Previous experience in the development of data use products
• S/he must show proven understanding of database designs, data presentation, interoperability protocols, etc
• S/he must have an understanding of health databases.