Looding...

Data Integration into Snowflake Data Cloud

Insurance
case study

Business Impacts

Claims Dashboard

Reduction in Manual Tasks

Reduces Time to Access Reports

Increased Visibility and Usability

Customer Key Facts

  • Location : North America
  • Industry : Supplemental Insurance

Problem Context

The client, one of the largest providers of supplemental insurance, wanted to integrate Dental data into the cloud data ecosystem to enable the following:

  • Self-Service Access to Dental data for Actuarial, Analytics, Underwriting, and Pre-Sales Ops
  • Create data feed to Cloud Lake and open up access for analysis
  • Consolidate, aggregate, and enable visualization for Dental Claims data

Challenges

 

  • Prioritizing impactful KPIs out of all available KPIs
  • Timely access to accounts and databases
  • Getting requirements for future development since complete business information is not yet defined

Technologies

Infoworks

Infoworks

Snowflake

Snowflake

Tableau

Tableau

AWS EMR

AWS EMR

AWS S3

AWS S3

Hive

Hive

Protegrity

Protegrity

Developed a Consolidated Data Mart for Claims

Solution

Quantiphi developed a consolidated Data Mart for claims along with the Dental data feed. Attributes & metrics for analytics users with refined KPIs represent the state of claims operations across all lines of business at various levels of consumption. Visibility to data domains across Dental data sources by creation of self serve access through Snowflake and Hive

Result

  • Ability to work and search attributes across data for better visibility
  • For claims domains, Quantiphi integrated data from various sources for the claims operational dashboards for claims leadership

 

 

Thank you for reaching out to us!

Our experts will be in touch with you shortly.

In the meantime, explore our insightful blogs and case studies.

Something went wrong!

Please try it again.

Share