Data and Analytics Platform Development Case Study

This case study outlines the development of a Data and Analytics (D&A) platform by Tiger Analytics for a major US life insurance company. The objective was to improve data provisioning by unifying data from multiple enterprise data warehouses, addressing challenges such as data silos, performance bottlenecks, and untapped data potential. The solution involved creating key components including the End-of-Month Layer and the Business Data Vault Layer, which facilitated data validation and accessibility. A dimensional data model was developed for the Insights Data Mart, and a Python+Ninja framework was implemented to orchestrate data loading and ELT pipelines. The tech stack included AWS, Snowflake, and Azure DevOps, among others. The results showed significant improvements in query performance, agility in business insights, and enhanced data provisioning for users, all while ensuring trusted data access without ETL congestion.