Solving a $6 Million Problem with the dbt Semantic Layer​

EMC Insurance faced inconsistent data definitions buried in a rigid legacy system, leading analysts to spend millions of hours reconciling numbers instead of delivering insight. To break the cycle, EMC partnered with Analytics8 to deploy the dbt Semantic Layer and create a consistent, queryable foundation for metrics like loss ratio. The result was a shared source of truth that streamlined reporting and freed analysts to focus on higher-value work.

In this session, EMC Director Rob Vicker and A8 consultant Alexander Lecocq explain how they approached the problem, what they built, and what they would refine if starting again. This talk is useful for anyone dealing with conflicting reports, fragile legacy logic, or pressure to standardize metrics across the business.

Meet the host

Alexander Lecocq, Senior Consultant , Analytics8

Alexander is a Data Engineer who relishes in dealing with scattered or inconsistent sources and turning them into organized, usable datasets for analytics teams. In his time at Analytics8, he has worked with many different industries and types of data, from large scale IOT and eCommerce datasets to more bespoke, handmade datasets and overcome challenges in ingesting, transforming and modelling them. He often uses techniques from his time in history research to evaluate qualitative material, interrogate difficult sources, and help clients gain confidence in the data they rely on.

Other data analytics resources

Webinar announcement features five consultant headshots with names and titles, highlighting "How dbt Helps Our Clients Remove Data Engineering Bottlenecks." Logos for dbt and Analytics8 appear. Text is accompanied by colorful diagonal lines.

How dbt Helps Our Clients Remove Data Engineering Bottlenecks
Watch Video
Two men are shown smiling in professional attire against a digital, futuristic background. Text reads: "Coalesce. Back to the Future: Where Dimensional Modeling Enters the Modern Data Stack. JOHN BARCHESKI, Senior Consultant. TONY DAHLAGER, Managing Director. Hosted by dbt Labs."

Back to the Future: Where Dimensional Modeling Enters the Modern Data Stack
Watch Video
Headshot of a smiling man, Tony Dahlager, Managing Director, on a blue background. Text reads: “How to Optimize Data and Analytics Spend, Part 5: Talent Strategy for Consulting Providers.” Analytics8 logo is visible.

5 Ways to Optimize Data and Analytics Spend
Watch Video

Get in touch

Have a question or want to learn more? Talk to one of our experts.

Contact us