Case Study: HUB International modernizes clinical data and speeds ETL with Coalesce

HUB International Brings Its Clinical Informatics Data Strategy Into the Modern Age

HUB International, a leading insurance consulting group, needed to modernize its clinical informatics data strategy after rapid growth through mergers and acquisitions left it juggling multiple warehouses, manual Excel reporting, and slow, error-prone data transformations. The team also had to manage highly sensitive healthcare and insurance data under strict HIPAA-related privacy requirements, making it difficult to produce timely, reliable insights.

To solve this, HUB International partnered with DigBI Consulting and adopted Snowflake as its central data repository, with Coalesce handling data transformations for its new “Infused Analytics” platform. With Coalesce, HUB built its entire data warehouse and four data marts in under 100 hours, cut complex ETL runtimes from 3–5 hours to 1–2 minutes, and saved an estimated $54,000 in labor costs. HUB International says Coalesce has been a game-changer, enabling near real-time analytics and replacing countless hours of manual reporting.

HUB International

Kryijztoff Novotnaj

Chief Clinical Informatics Officer