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. We needed a way to standardize metrics fast. By using the dbt semantic layer alongside Analytics8, we 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 we approached the problem, what we built, and what we’d do differently. If you’re trying to clean up inconsistent reporting or move away from fragile legacy logic, this is for you.