National Database development

The purpose of this assignment is to strengthen the Nutrition Information System (NIS) in Afghanistan by integrating key nutrition indicators into the District Health Information Software 2 (DHIS2) platform and vice versa, ensuring widespread accessibility for national and international nutrition implementing partners. The assignment involves documenting NIS data standards, workflow process, and access protocols, as well as developing guidelines for data use and analysis to support nutrition managers at national and sub-national levels. Additionally, it aims to clarify roles, and accountabilities, review existing data sources to eliminate duplication, and integrate a plausibility component of community-based surveillance to improve data quality. Furthermore, it aims to revise the current IMAM reporting module as per the new WHO IMAM guideline and modification of field monitoring tools/modules. The assignment includes expanding the monitoring and supply features of nutrition dashboard, enhancing the online nutrition database, and developing modules to integrate data from various sources, such as HMIS and health facility registries. The consultant will be responsible for creating, testing, and maintaining databases to ensure efficient data retrieval and usability.

Below are the proposed deliverables aimed to transform the NIS into a centralized, user-friendly, and interoperable platform that empowers nutrition partners to analyze and interpret data from multiple sources seamlessly. Key action areas include:

Nutrition Information System is upgraded:

• Revise the IMAM module, supply chain management (SCM) module, and field monitoring including CBNI module align with updated IMAM guidelines.
• Integrate Early Child Development into NIS where applicable.
• Embed a quality assurance mechanism into the surveillance system, enabling field teams to conduct real time plausibility checks.
• Introduce real time data collection tool for community sentinel sites.
• Consolidate the supply requisition and distribution processes into a single window page.
• Customize the online SCM system (including cloud-based access) to supports business specific processes
• Simplify and document the supply management component to improve usability and efficiency.

Nutrition Data Integrated and Automated:

• Develop a centralized repository for active surveillance data, program monitoring data, supply chain management data, to triangulate community & facility-based data and comprehensive analysis of nutrition information.
• A two-way linkage of DHIS2/HMIS with NIS for surveillance related indicators and vice versa
• Semi-automated causal analysis and data synthesis to generate actionable insights for decision-makers.

Interactive Nutrition Dashboard Developed:

• Improve the interactive, real-time dashboard using Power BI to provide stakeholders with intuitive visualizations of program performance and nutritional status
• Linking/ embedding the dashboard with UNICEF Afghanistan Nutrition ECM page for live progress mapping
• Improve and integrate interactive dashboard and visualization within SCM system (real time tracking, alerts, inventory/shipment/orders monitoring)

Capacity of the implementing partners and field staff developed:

• Train implementing partners and field staff on system use, advanced reporting, and evidence-based decision-making to maximize the utilization of the system.

To qualify as an advocate for every child you will have… 

An advanced university degree (master’s or higher) in Data science, statistics or Computer Science.

At least 5 years of professional work experience in Management of Information Systems, database development with SQL and the development of online databases using Microsoft Asp.Net Core and C+ is required.

Experience in working with governments and UN agencies providing support on equity-based health and nutrition interventions.

Skills:

• 2+ years of experience working with BI tools (PowerBi, Tableau, Google Data Studio)
• Experience in data cleaning and data integration processes.
• Strong knowledge of statistics and experience using statistical packages for analyzing datasets
• Experience building data and reporting stacks from the ground up
• Knowledge of & hands-on experience as a technical solutions architect
• Excellent command of English and report writing skills
• Excellent analytical and research skills
• Developing country work experience and/or familiarity with emergency is considered an asset.
• Fluency in English is required. Knowledge of another official UN language (Arabic, Chinese, French, Russian or Spanish) or a local language is an asset.

Source:  https://jobs.unicef.org/cw/en-us/job/580782