Turning 100+ Countries of Health Data into Actionable Intelligence

About Client 

Our client is a premier global health non-profit headquartered in Geneva, Switzerland, investing over $4.5 billion annually to combat HIV, tuberculosis, and malaria in over 100 countries. To ensure that these funds are used effectively, a dedicated audit and investigation unit manages whistleblower reports and conducts confidential investigations to uphold accountability in the process of utilizing grants.

Business Challenge 

Data gaps was slowing down the fight against epidemics 

As the organization expanded to more than 100 countries, their data ecosystem became fragmented and increasingly difficult to manage. Each country relied on its own Health Management Information System (HMIS) most commonly powered by District Health Information Software 2 (DHIS2) and reported indicators differently.  

This lack of consistency meant outcomes couldn’t be compared, and best practices couldn’t be shared across regions. 

To address this, the organization introduced a unified Performance Framework as a global measurement system. But onboarding new countries into the framework was painfully slow. Mapping indicators, validating metadata, and reconciling definitions often took weeks of manual effort. Skilled program officers, instead of advising program partners, were consumed by spreadsheet work.  

Health data from national HMIS/DHIS2 systems had to pass through multiple integration layers before it reached the Grant Operating System (GOS), where Principal Recipients (PRs) consolidated and reviewed reports. Manual checks at each stage created delays and errors. Most critically, leadership often faced life-and-death funding decisions—where to allocate resources, which programs were working, and which interventions needed urgent attention without timely or standardized information.  

The Zuci Solution 

Building Trustworthy Data Pipelines at Scale  

Zuci recognized that the organization needed a fundamental reimagining of how health data moved from 100+ independent country systems into unified insights. 

ADEx: Automating the journey from country systems to global insights 

Working collaboratively with the organization’s technical and program teams, Zuci designed and implemented ADEx (Automated Data Exchange), an end-to-end pipeline that replaced manual reporting with automated, validated, and standardized data flows. For the first time, health data could move seamlessly from national HMIS/DHIS2 systems into the Grant Operating System (GOS), giving decision-makers near real-time visibility. 

Real-time visibility for program leaders 
ADEx turned the GOS into a live dashboard rather than a retrospective reporting tool. Program managers and Principal Recipients no longer had to wait weeks for consolidated reports. They could monitor performance almost in real time, just as a sales leader watches live CRM data. This allowed them to make adjustments on the ground while interventions were still unfolding. 

Shift-left validation: catching errors before they cascade 
Validation was embedded at the earliest points in the data pipeline rather than the usual manual reconciliation at the end. The team adopted a dual techno-functional approach combining deep expertise in global health metrics along with technical capabilities in data engineering. 

Zuci built SQL-driven test scenarios to systematically verify data accuracy across three critical layers:  

• Data movement and orchestration – automated flow between country systems and central repositories  

• Data transformation – applied business rules, performed calculations, prepared data for reporting  

• Data standardization – maintained reference data and ensured consistent definitions across countries  

For instance, if a country’s tuberculosis case definition didn’t align with the global framework, the issue was flagged immediately during setup itself. This shift-left approach turned data management from reactive firefighting into proactive quality assurance. 

A common measurement language across 100+ countries 
Zuci played a key role in breaking down complex KPIs into elementary indicators and validating country metadata through an Excel-based comparison framework linked with Master Data Services. The team worked systematically through each country’s indicator definitions, building transparent mappings that showed exactly how local measurements translated into the global framework. 

Streamlined onboarding: weeks reduced to days 
The solution came with standardized checklists and pre-built test scenarios that dramatically accelerated onboarding. What previously took weeks of manual effort—mapping indicators, configuring spreadsheets, and validating data by hand—could now be completed in just two days.