An insurance company providing insurance coverage and services to individuals and business owners for more than 125 years. The $1.3 billion company offers auto, home, condo, identity theft, umbrella and renters’ insurance to consumers, as well as general business coverage, worker’s compensation, loss prevention and premium audit services for companies.
The client's executives needed better visibility across all of their data to be able to design future products and gain a better understanding of populations across different types of insurance policies, to improve actuarial rates and regulatory reporting. IT leaders soon found that reaching those goals with a combination of new and old technologies would be difficult. To meet this challenge, the client embarked on a digital transformation journey to implement a new, packaged insurance administration platform in the cloud, as well as to build a new data warehouse to work with the new insurance platform. The new system would have to be customized to integrate several legacy insurance systems that house sensitive data, which presented many technical challenges. Data flow to the new platform was critical and required IT teams to understand the business’s goals, the data requirements and regulatory requirements. The client turned to the specialists at Baker Tilly to support their transformation journey.
The Baker Tilly team worked with client stakeholders to develop a “business first” approach to drive new data flow models based on the priorities of the business. Our team provided clarity to questions and architected the data models specifically to meet requirements for design, development, and testing. Once those models were built, they implemented the technology, using Microsoft’s SQL Server, Azure Data Factory, and Power BI. Throughout the duration of the project, the Baker Tilly team:
The client received multiple business-facing solutions from the Baker Tilly team, each designed to surface the most relevant and accessible content for each set of users. Their product developers can understand which products are working well in the market, and better design future products. Data reveals which products are profitable and who are the right targets for new products. From an actuarial perspective, the client has better insights into their populations across different types of policies, and they can use that data to adjust or improve rates. Regulatory reporting and compliance are now easier, more consistent and reliable, with significantly improved testing capabilities. With new modern tools and data models architected for the future, the client now has a platform to move the business forward.