Overview of the MoPH Data Warehouse/DHIS2
Part of the scope of the project is to strengthen the Health Information System (HIS) for both Public and Private sectors. HSR has supported the MoPH to develop the MoPH Data warehouse and implement activities to improve data quality and use for improving access to and utilization of quality health data for evidence-based decision making. It is important to make health data available to the public and the civil society in addition to policymakers and program managers, to ensure that the public and the civil society understands the current situation as well as the progress in the health sector.
To facilitate the analysis and use of health data, the Ministry of Public Health (MoPH) developed a data warehouse in collaboration with the USAID-funded, Health Sector Resiliency (HSR) project in Afghanistan. The first version of the MoPH data warehouse, developed using the web-based District Health Information Software (DHIS-2), was launched on August 29th, 2017. Since then, significant work has been done to enhance the system. The MoPH Data warehouse is an online, central repository for all health data, where MoPH, government officials and program implementers can access and monitor program implementation, and services delivery at multiple levels including the central, regional, provincial and district level. In addition, through the data warehouse, the MoPH will provide easier access to information to facilitate evidence-based decision making.
The Ministry of Public Health (MoPH) in Afghanistan collects the following different types of data:
- Administrative data
- Health Services data
- Survey data
The following data sources have been included in the DW.
Scope of Work (SoW)
- HMIS (Health Management Information System)
- Integrated Disease Surveillance and Response System (IDSR).
- The Startup Mortality List (SMoL) - Collecting the underline causes of deaths information.
- Minimum Required Standard (MRS) - For monitoring private health facilities.
- Expenditure Management Information System (EMIS).
- National Monitoring Checklist (NMC).
- HRMIS aggregated information.
- Pharmaceutical Information Management System.
- Community Health Worker information system (CHW).
- M&E Framework reporting dataset.
- Health Surveys.
HSR is seeking a qualified ICT/data management specialist to work closely with the Information and Communication Technology (ICT) team to develop an interactive national health public portal for the Ministry of Public Health (MoPH) with data derived from the MoPH DHIS2-based data warehouse.
The dashboard will be a live, interactive matrix with different filters as proposed/agreed by the MoPH. The data will be filtered by period, location, health facility type, specialty, size in hospital beds and service types.
The ideal candidate will have the skills and experience required to develop an information portal for a Ministry of Health.
- Review the MoPH indicator atlas and the existing health dashboards;
- Conduct consultative meetings with stakeholders (Ministry of Public Health and other development partners) to define clear and well-thought out requirement for the national health public portal.
- Document requirements for the national health portal.
- Develop prototype for the national health portal and review with stakeholders for feedback.
- Incorporate the feedback and finalize the national health portal in collaboration with stakeholders.
- Develop a test plan for the developed portal.
- Address any identified issues from the testing team.
- Develop an end user manual, technical manual and plan for TOT.
60 working days including remote work and 2 visits of minimum two weeks each to Kabul.
- Detailed work plan describing the approach and timeline for developing a robust national health information portal.
- Software Requirement Specification (SRS) document.
- Deployed, tested and functional national health information portal.
- End user and technical manual.
- A TOT for the technical team.
- Provide support for one year after user acceptance.
This assignment is not limited to individuals. Software development companies that meet the requirements for delivery of the assignment can also apply.
- Advanced university degree (Master’s degree or equivalent) in computer science, information systems, mathematics, statistics, public health, informatics, management information systems, business intelligence or related field. A first-level university degree in combination with five additional years of qualifying work experience may be accepted in lieu of the advanced university degree.
- Strong knowledge of enterprise data warehousing (EDW), dimensional modelling and design, analytics, enterprise dashboard and health key performance indicators (KPIs) would be an asset.
The national public portal should be developed with (asp .net Core2/ Angular) that is proven to be interoperable with DHIS2. If commercial BI tools are used, the end user should not be subject to license encumbrances. For instance, D3, Chartjs, etc.
- Minimum of 5 years of experience developing BI tools, data visualization, and dashboards at enterprise level.
- Hands-on experience in development work using the RESTful API.
- Full-stack developer in technologies (Asp.net Core2/Angular).
- Proven experience in developing information systems for ministries of health, UN agencies or related organization.
- Experience in a healthcare setting is preferred.
About the Organization
Palladium develops and delivers solutions that create positive impact for communities, businesses, societies and economies. We transform lives and create enduring value by working with governments, corporations and non-profit organisations.
Palladium is built on the idea that progress will be supported by four key pillars: • International Development • Strategy Execution Consulting • Impact Investment • Training and Events We create positive impact through more than 100 current projects with more than 2000 employees operating in over 90 countries.