Enterprise metrics governance & AI-ready semantic layer
Data Director · GOZEM
Established a single source of truth for business metrics across analytics, reporting, and AI-powered workflows.
- Challenge
As Gozem expanded its analytics footprint across multiple business domains and countries, the risk of inconsistent metric interpretation increased. KPI definitions, transformation logic, aggregation rules, dimensions, and query implementations were often embedded across dashboards, SQL queries, reports, and undocumented team knowledge.
At the same time, emerging AI-powered analytics workflows created new requirements. Business users needed trusted natural-language access to data, while AI agents required a reliable understanding of business concepts, metrics, and relationships to generate accurate insights.
The organization needed a foundation capable of serving both humans and AI systems with a consistent interpretation of business performance.
- Approach
Designed and implemented the foundation of an enterprise metrics governance framework covering KPI definitions, source systems, transformation dependencies, aggregation behavior, available dimensions, lineage, and canonical calculation methods.
Created a centralized metrics catalog documenting how each KPI is derived, whether from raw operational data or transformed analytical models, including supporting business context, relationships between metrics, valid dimensions, joins, and calculation formulas.
Standardized KPI computation through reusable BigQuery and Dataform assets powering reporting and analytical applications, ensuring consistent metric definitions across dashboards, analyses, and operational workflows.
Introduced governed AI access to warehouse data through an MCP-enabled BigQuery integration in Claude. Selected senior users could query enterprise data using natural language within their existing Google Cloud IAM permissions.
This work also laid the foundations for an AI-ready semantic layer capable of supporting future copilots, autonomous agents, self-service analytics experiences, and automated decision-support systems.
- Tools
BigQuery
Dataform
MCP
Claude
Python
Looker Studio
Google Cloud IAM