How IntelliTect Supported WaterStreet’s Reporting and Data Migration Initiatives

Background

WaterStreet Company, founded in 2000 and headquartered in Kalispell, Montana, is a team of property and casualty insurance industry experts dedicated to transforming operations for P&C carriers, MGAs, insurtechs, and startups. Their cloud-based insurance administration platform, powered by Microsoft Azure, is complemented by a suite of back-office services, offering a one-stop-shop solution to help clients grow and scale efficiently. With over 20 years of experience, WaterStreet continues to deliver cutting-edge technology and exceptional customer experiences, enabling clients of all sizes to meet and exceed their business goals.

Challenge

WaterStreet faced two primary challenges that required IntelliTect’s assistance:

• Developing and supporting a robust reporting solution to meet their clients’ analytical needs.
• Migrating legacy data from an older, hosted solution to a newer platform without disruption.

While the business needs were well-defined, the technical implementation was entrusted to IntelliTect. Additionally, the project required scaling solutions using Microsoft’s cloud technologies while collaborating with an existing team of developers.

Solution

IntelliTect leveraged its technical expertise to deliver a comprehensive solution for WaterStreet:

1. Advanced Reporting with Power BI: Using Power BI integrated with Azure Analysis Services, IntelliTect delivered a reporting platform that provided actionable insights and improved data visibility.
2. Data Migration Strategy: Implemented a reliable ETL process using Azure Data Factory to automate nightly data transfers and transformations for Azure Analysis Services.
3. Microsoft Azure Technologies: Hosted SQL Server on Azure Virtual Machines to manage nightly data restores and schedule the daily refresh process.
4. Seamless Collaboration: Collaborated virtually with WaterStreet’s team of 10 developers to ensure smooth integration and knowledge sharing throughout the project.

IntelliTect’s expertise in Azure and Power BI transformed our reporting capabilities and ensured a smooth migration process. Their collaboration with our team was seamless and highly effective.”

— Nathan DeSpain, Vice President

Outcome

IntelliTect’s solutions allowed WaterStreet to achieve their goals effectively, enabling them to deliver enhanced reporting capabilities and a seamless migration experience to their clients. By sticking to a Microsoft-based cloud stack, WaterStreet maintained continuity with their existing ecosystem while optimizing performance and scalability.

Key Results

• Improved reporting capabilities with a user-friendly Power BI interface.
• Successful data migration with minimal disruption to ongoing operations.
• Strengthened team collaboration and technical alignment through virtual engagement.