The Propel Health supported the Reproductive Health Directorate (RHD) to conduct a partner/stakeholder mapping exercise. The mapping targeted partners and stakeholders of Family Planning (FP) and Youth Friendly Health Services programs. The output was a dashboard that was developed through an expert demonstrating distribution of partners in charts and maps. Partner mapping excel templates were developed and shared with FP and YFHS coordinators to populate. The excel mapping captures FP and YFHS stakeholders across the 29 health districts, highlighting their geographical coverage and programmatic focus areas.

While the dashboard and the map have been developed, there is need to transform the data integration framework and redesign the visualizations based on new requirements. 

 Primary Objective:

The objective of the new scope is to update the data integration framework and redesign the visualizations based on new requirements

 Specific Objectives:

Specifically, the following will be applied:

• Migrate data into from the current platform to an integrable live data collection tool from the opensource market.
• Clean data to ensure there is granularity of donor groups.
• Add facility geocoordinates to the health facility data from Master Health Facility Registry.
• Create new visualizations based on all data elements.
• Add new maps and layers.
• Revise existing charts.
  

Scope of Work:

1. Migrate data from the existing template to a database for live tableau integration

• Create a tableau data connector for live refresh
• Migrate data to a new database
• Develop a data collection tool from the opensource market to push data to the database

2. Conduct data cleaning for the existing data 

• Disaggregate donors
• Disaggregate facility data
• Apply new coordinates for the health facilities
• Link all health facilities with coordinates

3. Revise existing visualization and create new visualizations

• Revise current visualizations to new chart types and legends
• Add new charts to the dashboard
• Add new maps and layers
• Publish dashboard to Malawi Analytics platform

4. Train users

• Develop user manuals
• Train users in enhanced dashboards

5. Provide user support

Deliverables: 

With respect to the assignment, the following deliverable have been Identified and are as follows:

1. New data collection tool adapted from the opensource market

• A data collection form can be developed that will be managed by the Ministry of Health for updating data

2. Clean data integrated with the visualization platform

• The data will be migrated from the current platform, cleaned and have new granular disaggregation with facility coordinates

3. Revised Tableau Dashboards

• Existing dashboards revised visualizations and maps

4. User manuals, training and user support

• User manuals developed from enhanced dashboards

Required Qualifications:

Education

• Bachelor’s degree in Geographic Information Systems (GIS), Computer Sciences, Physical Planning or related field.

Knowledge and Experience 

• Demonstrated experience in the development and implementation of geospatial and informatics outputs.
• Demonstrated experience in the database design, development and management.
• Experience in using the Business Intelligence tools such as PowerBI and Tableau.
• Demonstrated experience in UI/UX designs and implementation.
• Ability to take initiative and to work independently, as well as part of a team.

Languages

• Fluency in English is required 

Payment Schedule: 

The consultant will be paid upon receipt of satisfactory deliverables. In submitting the financial proposals, consultants must therefore outline the cost per deliverable.

Submission: 

Individual applicants are required to submit a technical and financial proposal along with curriculum vitae. The technical proposal should NOT exceed five (5) pages. Applications will be reviewed on a rolling basis and the position may be filled before the deadline.

Our company provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics.