Data Integration into Snowflake Data Cloud
InsuranceBusiness 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
Snowflake
Tableau
AWS EMR
AWS S3
Hive
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
