UK-based • Supporting growing and regulated organisations
Data & Analytics Insurance

Insurance Claims Analytics & AWS Data Engineering

Connecting claims reporting to an automated AWS data pipeline.

Power BI + AWS automated ETL
About this example

This is an anonymised case study drawn from the founders' prior professional delivery experience. It is included to demonstrate relevant capability and is not represented as an EaseThat client engagement unless expressly stated.

The challenge

What needed to change

Claims and transaction reporting required data from multiple sources and a more efficient, repeatable process for extracting, transforming and delivering decision-ready information.

The approach

How the work was tackled

Led Power BI delivery from requirements gathering and stakeholder management through dashboard development. Used AWS Athena to query multiple data sources and developed an AWS Glue pipeline to ingest and process financial data from RDS and S3, with PySpark/Scala jobs orchestrated through Step Functions and CloudWatch.

Outcomes

What the work delivered

Delivered actionable claims and transaction insights through optimised Power BI dashboards.

Automated data workflows and reduced manual processing effort.

Created an end-to-end ETL pipeline supporting accurate and timely reporting.

Improved metadata management and schema control using AWS Glue Data Catalog.