Case Study Deskcasestudydesk.com
InsuranceSourced

Case Study: Texas Mutual cuts ELT tool costs 50%+ and speeds processing 18-20% with Coalesce

Texas Mutual Case StudySourced & dated by Case Study Desk
Key facts · TL;DR
Company
Texas Mutual
Industry
Insurance
Challenge
Legacy ELT tool constrained a modern Snowflake stack
Headline result
50%+ lower ELT tool costs

Key results

50%+
ELT tool cost reduction
eliminated licensing fees, decommissioned on-prem servers
18-20%
Faster data processing
nightly processing time
Zero
Downtime at cutover
full code migration, no downstream disruption

The challenge

Texas Mutual is the leading provider of workers' compensation insurance in Texas, with more than 1,000 employees and millions of dollars flowing through premiums, dividends, and commissions each year. Six years into a modernization effort, it had moved key workloads to Snowflake but was still constrained by a legacy ELT tool that created performance, maintenance, and scalability issues.

The solution

The data engineering team adopted Coalesce Transform as a Snowflake-centric transformation environment, migrating all code and decommissioning on-premises servers to fit how a lean engineering team works.

The results, in context

Texas Mutual reduced ELT tool costs by more than 50% by eliminating licensing fees and decommissioning on-premises servers, and improved data processing speeds by 18-20% as nightly processing time fell. The migration cutover was completed with zero downtime for downstream users.

Products used

Coalesce Transform