Home / Work / Semantic analytics

Case study · AI & semantic analytics

Semantic analytics in production.

Outcome first: a production Claude + Snowflake Cortex semantic layer, delivered through an enterprise plugin marketplace I spearheaded — 12 plugins across six business domains. Claims, Policy & Underwriting, Finance, and Legal ask governed questions in plain English; executives assemble QBRs, reserve reviews, and financial reports from it. The quarterly reserve review went from 3 days to under 30 minutes and QBR prep from 4 days to under an hour; ~200 monthly active users (40% of the company) run 2K+ queries a month at 30% lower token consumption; regulatory reporting stays consistent; and cross-domain metrics like policy erosion went from impractical to routine. Most enterprise GenAI pilots never reach production; this one is company-wide.

claudesnowflake cortexmcpdbtdagster
RoleLead engineer — spearheaded & run it
ScopeEnterprise-wide · 12 plugins · 6 domains
StatusIn production
StackClaude · Cortex · dbt · Dagster · MCP
01 · Problem

Insurance runs on questions: how is this book performing, what's eroding, does this quarter's regulatory report match last quarter's definitions? Answering them meant analyst queues, hand-built extracts, and — the quiet killer — subtly different metric definitions across domains, which is how a company ends up arguing with its own numbers.

The naive fix, "point an LLM at the warehouse," fails in a regulated industry for a reason that deserves respect: an answer you can't govern is a liability with good grammar. The real problem was never can a model write SQL — it's can the business trust what comes back, every time, within the access each person already has.

02 · Approach

The constraint set came first: answers had to draw on governed, curated data — not raw tables; metric definitions had to be consistent across domains and with regulatory reporting; and the system had to serve non-technical users, not just analysts.

That pointed at a semantic layer rather than a chatbot — and at a marketplace rather than a monolith. The intelligence lives in authored domain skills that encode how each domain's data actually works and bridge the data catalogs into agent-ready data products. Each plugin packages the skills a domain needs; the marketplace makes them discoverable, governable, and supportable at enterprise scale. Writing skills is closer to authoring documentation for a very literal colleague than to prompt engineering — and it's where the leverage is: once claims and policy could be read together, cross-domain metrics like policy erosion went from impractical to routine.

03 · The system
04 · Results
ResultDetail
3 d → 30 minQuarterly reserve review — cross-domain plugin knowledge, deck templates, period-over-period point-in-time analysis; QBR prep fell from 4 days to under an hour
12 plugins · 6 domainsEnterprise marketplace, enabled company-wide — ~200 monthly active users, 2K+ queries/month
C-suite in productionFive C-suite regulars among users building QBRs, reserve reviews, financial reports, and canonical dashboards; token consumption 30% lower than unassisted LLM use
Trusted & compliantSnowflake Cortex evaluations were the breakthrough — one set of governed definitions, the same number in the dashboard, the filing, and the chatbot
New metrics unlockedCross-domain measures (e.g., policy erosion) previously impractical to produce
05 · Learnings

The semantic layer is the product; the model is a component. Domain skills age like documentation, not like prompts — budget for their upkeep. A marketplace is an organizational design as much as a technical one: it needs a roadmap, evaluations, governance, and support, and someone accountable for all four. And "10×" is only an honest number when you say what it measures — the speedup is in the workflows, not a magic multiplier on people. The pattern that survived contact with a regulated business is the one the industry converged on: AI that works inside the governance you already built, not around it.


Building governed AI analytics in a regulated business? I've made the mistakes already — happy to compare notes.