Data Analytics and AI

Investment Data Warehouse System Architecture Assessment


A Fortune 500 commercial lines property and casualty insurance holding company required a system architecture assessment to analyze options to modernize its legacy Investment Data Warehouse as it was not providing the expected value.

Client Challenges and Requirements

  • Business agility was hard to achieve as changes to the architecture resulted in major issues
  • Maintenance of the system was difficult due to the complex architecture and tightly coupled modules
  • Stale business analytics due to time-consuming processes
  • Disconnected data silos
  • Absence of data audits or governance

Bitwise Solution

Bitwise conducted a system architecture assessment and provided 2 options that could eliminate the challenges the business was facing.

Approach 1: To enhance the current IDW system in terms of functionality, scalability, and data consistency while building a central repository to maintain a data warehouse.

Approach 2: To build a new, flexible, cost-efficient, and highly available cloud-based solution in Azure.

Both approaches involved solutions for:

  • Data Model design
  • Data Quality
  • Data Governance
  • Reporting layer
  • Scheduling and deployments
  • Environment Setup

Tools & Technologies We Used

SQL Server
SQL Server Agent
Automated Script
Azure Blob Storage
Azure Data Factory
Azure SQL Managed Instance
MS Power BI
Azure Express Route, Key vault, Analysis Services, API, App Service

Key Results

Holistic assessment with multiple options

Short term and long-term approaches planned

Both solutions aimed at future modernizations

Minimum business disruptions

Download Case Study

    To get our latest updates subscribe to our Newsletter.

    Ready to start a conversation?