Semantic Layer for AI-Ready Finance Data

Challenge: Finance teams defined the same metrics in different ways, so dashboards, reports and new AI tools gave conflicting answers.

What I did: Designed a semantic layer across finance functions with governed metric definitions, documented business logic and reusable dbt models that people and AI tools both query.

Result: One source of truth for finance metrics, and a foundation that lets AI tools answer questions from trusted numbers instead of raw tables.

Tools: dbt, SQL, semantic layer design, data governance