Data warehouse Enterprise Architecture (EA) Consultant

  • Senior-level, Short-term contract assignment
  • Posted on 24 January 2019
  • Kabul, Afghanistan
  • Closing on 30 January 2019

Job Description

The USAID Health Sector Resiliency (HSR) Project supports the Ministry of Public Health (MoPH) to implement critical sector-wide reforms that will be required to increase the resiliency and self-sufficiency of the health sector and move towards sustainability. The HSR Project primarily focuses on improving the health sector’s stewardship, governance, financing and human resources. The project engages both the public and private components of the health sector and supports the MoPH to strengthen and reform its systems at both central and subnational levels.

Part of the scope of the project is to strengthen the Health Information System (HIS). 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.

Overview of the MoPH Data warehouse/DHIS2
The Ministry of Public Health (MoPH) in Afghanistan collects the following type of data using different data collection tools.

It includes
1 Administrative data
2 Health Services data
3 Surveys data

To facilitate the analysis and use of health data, Ministry of Public Health (MoPH) started the development of 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 aims to provide easier access to information to facilitate evidence-based decision making.

The MoPH data warehouse so far has part of service data and working to include all data sources to complete bigger picture of enterprise architecture of information of system in MoPH.

The following sources so far included in the DW.
1 HMIS (Health Management Information System)
2 Integrated Disease Surveillance and Response System (IDSR).
3 The Startup Mortality List (SMoL) - Collecting the underline causes of deaths information.
4 Minimum Required Standard (MRS) - For monitoring private health facilities.

As per the institutionalization plan for the MoPH data warehouse, the following databases will be integrated in the near future.
1 National Monitoring Checklist (NMC).
2 HRMIS aggregated information.
3 Pharmaceutical Information Management System.
4 Community Health Worker information system (CHW).

To present a comprehensive picture of the MoPH Data warehouse/DHIS2, including mapping and documenting the linkages between the various databases in the system, HSR seeks the services of a consultant to develop an Enterprise Architecture for the Ministry of Public Health (MoPH)’s Data warehouse in Afghanistan.

Main Responsibilities
* Develop a detailed work plan of activities for developing the EA. The Data Warehouse Architecture (DWA) encompasses the metadata, hardware, software, policies, governance, and requirements by which all information systems are developed, deployed, and managed. The entire Information System Framework is guided by this architecture.
* Conduct knowledge sharing workshops with the MoPH data warehouse TWG to ensure that the local team is in the know of the process of developing the EA.
* Conduct consultative meetings with relevant MoPH departments and the stakeholders
* Map and document the existing systems; inclusive of the inputs, processes, outputs, technology and the functional status.
* Work with the MoPH data warehouse TWG to document an interoperability framework.
* Work with the MoPH data warehouse TWG to document a governance framework
* Work with the MoPH data warehouse TWG to develop the EA blueprint, inclusive of the business, application, data and technology architecture throughout the development life cycle of the enterprise architecture.
* Manage to develop means for transforming, calculating and reporting of the data received from various sources for health management.
* The MoPH adopted DHIS2 as the MoPH data warehouse, and as such, the application architecture should show the relationship between databases that are to be integrated in the MoPH data warehouse as well as those that will have to be developed using different development environments.

* Detailed work plan describing the approach and timeline of system development activities
* A blueprint for the Enterprise Architecture by each of the following domains.
* Business architecture
* Application architecture
* Data architecture
* Infrastructure architecture
* A completed Enterprise Architecture for the MoPH data warehouse.
* A clear and comprehensive design of ETL.

Level of Efforts for the assignment

One month (30 working days) including a field trip and remote work. The anticipated start date for the assignment is February 2019.

Master’s degree in Computer Science, Information Technology, Public health, Informatics, Management Information Systems, Business Intelligence or any other relevant field is required.

Possession of any Enterprise Architecture certification like TOGAF would be an added advantage.

* Five years’ experience in developing enterprise architectures at a national is required.
* Experience in a healthcare setting is highly desirable.
* Knowledge of the DHIS 2 platform would be an advantage.
* Demonstrated ability to manage multiple, concurrent and complex projects.
* Ideal candidate should be team and customer centric.

About the Organization

Palladium is a global leader in the design, development and delivery of Positive Impact - the intentional creation of enduring social and economic value. We work with foundations, investors, governments, corporations, communities and civil society to formulate strategies and implement solutions that generate lasting social, environmental and financial benefits.

For the past 50 years, we have been making Positive Impact possible. With a team of more than 2,500 employees operating in 90 plus countries and a global network of more than 35,000 technical experts, Palladium has improved - and is committed to continuing to improve - economies, societies and most importantly, people's lives.

Palladium is a child-safe organisation, and screens applicants for suitability to work with children. We also provide equal employment to all participants and employees without regard to race, color, religion, gender, age, disability, sexual orientation, veteran or marital status

Similar Jobs