Case Study: EMC Insurance accelerates dbt migration and saves $6M with Analytics8 and MCP

EMC Insurance migrates 1,000 dbt models in 4 weeks with Analytics8

EMC Insurance, a $2 billion property and casualty insurer, faced challenges of scale and complexity during a company-wide data modernization effort. Their large legacy environment made it difficult to move quickly and maintain consistent definitions for key business metrics. They partnered with vendor Analytics8 to accelerate their migration work and gain clarity into how critical data was being used across their teams.

Analytics8 implemented an MCP framework to automate the discovery of data lineage and accelerate code migration. The solution enabled EMC to migrate 130 SQL-based views to roughly 1,000 dbt models in just four weeks, a process that previously took a year. Analytics8's work saved EMC $6 million annually in manual reconciliation costs and reduced Power BI model analysis from months to days, creating a foundation for the company's future AI initiatives.

EMC Insurance