Solving a $6 million problem with the dbt Semantic Layer​ (Coalesce 2025)

At EMC Insurance, inconsistent data definitions across a rigid legacy system led to an estimated $6 million analyst-hours spent on reconciliation instead of delivering insights. They needed a way to standardize metrics fast. By using the dbt semantic layer alongside Analytics8, the team created a consistent, queryable layer for metrics like loss ratio, helping teams across the business get on the same page and ensure a single source of truth. This session walks through how EMC Insurance approached the problem, what they built, and what they’d do differently. If you’re trying to clean up inconsistent reporting or move away from fragile legacy logic, this is for you. Speakers: Rob Vicker, Data Analytics Architecture Director at EMC Insurance Alexander Lecocq, Senior Consultant at Analytics8 Learn more at: https://www.getdbt.com/