The Challenge:

The National Health Insurance Authority (“the Authority”) in The Bahamas was undergoing a significant enhancement of its technology assets to take advantage of modern technology solutions.

The Authority is tasked with administering the government funded National Health Insurance scheme in The Bahamas through public and private entities

The Approach:

KPMG’s approach to this project management solution was to split the methodology into four phases; data catalogue and metrics, business case and proposed architecture, implementation, and end-to-end testing, documentation and training. This was to help identify the main Key Performance Indicators, measure performance, and support decision making. This was to help inform the business case put forward detailing the benefits a key technology asset identified for construction a ‘Global Reporting Platform’, the purpose of which is to automate reporting and provide population and other analytics to the Authority.
Health Insurance

The Outcome:

Data Catalogue and Metrics:

A full review of the data available within the Authority was combined with discovery exercises to understand the KPIs and information required by the Authority to measure its performance and support decision making.

A Data Catalogue describing the data assets available and the transformations that would be required in order to extract the desired metrics was created, with data quality issues flagged for resolution.

Business Case and Proposed Architecture:

A business case for the benefits of the Global Reporting Platform was prepared, which included a proposed cloud architecture, that made use of Platform-as-a-Service resources. Moreover, a running cost estimate was prepared, presented, and approved.


A tenant was set up for the Authority, following dev-test-prod and security best practices.

Extract, transform, load (“ETL”) processes were designed and built, including the use of external data sources through application programming interfaces (“APIs”) for population and standardized diagnosed data.

  • Data validation checks were designed and built, including connections with logs and automated alert systems to facilitate monitoring of the quality of the ETL process.
  • A data warehouse was designed and built following the Kimball methodology.
  • End-to-End Testing, Documentation, Training:
  • A an end-to-end testing plan, with specific test cases, was generated and carried out.
  • Documentation was assembled to support the client with maintenance of the system going forward and training given as necessary

Contact Us