Contact
Contact
+61 2 9267 5869

Case Study

Improving Data Governance for NSW iCare - Insurance for NSW

iCare Logo

Background

iCare had a data quality issue that needed fixing. iCare outsource claims management to external claims managers who send regular data feeds into a centrally maintained data warehouse. This data warehouse is used for premium setting, scheme and management reporting and needs to maintain high quality data. Note: Insurance For NSW is a division of icare. Icare is Australia’s largest insurer. Insurance for NSW provides insurance for NSW government departments in a self-insurance scheme.

The Challenge

Establish an automated data quality framework to address the entire data governance lifecycle.

Improve the data quality and reduce the time and effort to maintain the data.

The solution was a mixture of bespoke .NET development, ETL development and issue management integration.

We Integrated the data quality service with issue management and data error reporting systems and created issue dashboards and issue management functionality to track data quality issues and close them when underlying errors were resolved.

The Solution

Implementation

We established a fully automated data governance solution that:
  • Maintained a data dictionary and business glossary of all data elements, allowing Insurance for NSW to automatically generate new data manuals and track changes between versions,
  • Automatically classified data errors as data was received into the warehouse,
  • grouped these into issues,
  • assigned issues to the relevant sending party and monitored and closed issues automatically as underlying data was fixed.

Results

  • A successful solution that met the challenges iCare wasfacing.
  • The new solution helped them significantly reduce the effort and time required to maintain the quality of the data in the data warehouse.
  • The solution Improved transparency of communication between all stakeholders and allowed them to make strategic changes to continue to maintain high quality data.
Lodestone Solutions Logo
Ground-breaking tech solutions.
News
Follow Us
Linkedin
Get in Touch
  • Level 1, 204 Clarence Street
    Sydney NSW 2000, Australia.

Copyright © 2023 Lodestone Solutions. All Rights Reserved.