SQL · Python · Power BI

Clear analysis
for better
decisions.

I use data to understand performance, identify patterns and gaps, and build reporting and visualizations that help teams make informed decisions.

My experience includes public-health and programme data, with transferable skills across data analysis, reporting, operations and business intelligence.

View my work
Background

Who
I am.

Data analyst with hands-on experience in public-health and programme data.

I work with health and programme data to improve quality reporting, understand performance, identify gaps and communicate findings clearly to technical and non-technical teams.

My background includes HIV, TB, PMTCT, maternal and child health and GBV programmes, alongside data validation, quality assessments, dashboards and donor- and Ministry of Health-aligned reporting.

I approach analysis practically: understand the data structure, document assumptions, check quality, include domain logic & constraints and build outputs that help people use the numbers in review meetings and day-to-day decisions. My skills transfer across data analysis, reporting, operations and business intelligence.

Areas of focus
Analytical Dashboards Data Quality Assurance HIV Cascade Analysis Healthcare Planning Donor Funded Programmes M&E Systems Design County-Level Disaggregation Health Systems
Selected work 5 projects

Case
Studies.

Data work from Kenya's public health sector - Programme Data, TB/HIV cascade, health equity, among other areas.

/001/
End-to-end Data Pipeline for Kenya HIV Programme 2026
HIV Treatment Cascade & Health Systems Analytics

A reproducible ELT pipeline that combines WHO, World Bank, UNAIDS and Global Fund data to analyse Kenya’s HIV programme and health-system context. It stages and models the data in DuckDB, defines analytical features in SQL, and produces traceable, source-labelled outputs and visualizations.

HIV Python SQL Visualizations Data pipeline
Read case study
/002/
Simulates Public Health Data Domains 2025
SQL Data Quality Engine for Kenya Public Health Data

A SQL-based data quality engine for validating and standardizing Kenya's public health datasets. A PostgreSQL data quality system that automatically detects, records and manages common errors across public-health datasets. It demonstrates how validation, issue triage and audit trails can be built directly into the data layer.

SQL Public health data Data quality assessment Data validation Simulated data
Read case study
/003/
End-to-end Data Pipeline for Kenya TB Programme 2026
Kenya TB Surveillance & Analysis

A reproducible Python pipeline for examining TB burden, notification gaps, treatment outcomes and service context in Kenya. The project combines multiple public data sources while keeping indicator definitions, data limitations and analytical assumptions explicit.

TB Python Data pipeline Error Logging
Read case study
/004/
Programme mapping tool 2023
KCCB-ACTS Supported Sites Mapper

Combined programme and geographic data to create a clearer view of supported health facilities, service coverage and programme reach.

Programme mapping GIS Python
Read case study
/005/
Public health analytics 2026
Kenya TB Care Cascade Explorer

An interactive explorer of WHO tuberculosis data, connecting estimated burden, case notification, treatment cohorts, outcomes, TB/HIV indicators and notified case demographics across Kenya and selected countries.

Public health Data visualisation Python Streamlit
Read case study
Capabilities

Data, analysis
& reporting.

I combine programme knowledge, analytical methods and clear communication to support reporting, performance review and evidence-based decisions.

Data management
Data cleaning & validation Structured checks, reconciliations and quality assessment for reliable reporting.
SQL & database design PostgreSQL queries, joins, views and repeatable analytical models.
Data transformation Python and spreadsheets for shaping raw programme data into usable analysis.
Analysis & reporting
Programme performance Indicator analysis, trend review and interpretation of operational gaps.
Reporting & communication Donor and government reporting, performance summaries and clear analytical narratives.
Visualization Power BI, Python and web-based dashboards designed for review and decision support.
Monitoring & evaluation
Routine data review & DQAs Indicator tracking, data-quality assessment and performance-review support.
Results monitoring Reporting frameworks, data flows and practical measurement for programme teams.
Public-health systems HIV, TB, PMTCT, maternal and child health, health workforce and DHIS2/KenyaEMR workflows.
Get in touch

Let's
work together.

I'm open to data analysis, monitoring and evaluation, health information and public-health analytics roles across Kenya, East Africa and remote teams.

wayne@wayneowillis.com