Analytics engineering

Experience cases

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

Data platform modernization and FinOps transformation

Head of Data · GOZEM

Reduced Google Cloud costs by 42.57% in one quarter while sustaining platform reliability and growing analytics adoption.
Challenge
As Gozem scaled across multiple countries and business units, analytics demand, reporting needs, and data volumes grew significantly. BigQuery transformation workloads relied heavily on scheduled queries with limited dependency management and visibility into cost drivers, leading to duplicated computation, increasing cloud expenditure, and growing operational complexity.
Approach

Established data platform observability and FinOps governance by analyzing BigQuery workload metadata to categorize ingestion, transformation, reporting, and ad hoc analytical activities. Identified the primary drivers of platform spend and led a modernization program spanning Dataform adoption, dependency-aware orchestration, incremental processing, partitioning and clustering optimization, reusable intermediate data models, and warehouse improvements tailored to workload access patterns.

Implemented monitoring and cost-allocation dashboards to guide ongoing optimization while maintaining data freshness and reliability as analytics usage grew.

Tools

Building Gozem's modern analytics foundation

Global Data Analyst · GOZEM

Established the analytical foundation that supported the company’s expansion, reducing reliance on manual reporting while enabling faster, more accessible, and more consistent decision-making across functions.
Challenge
Legacy data processes relied heavily on manual reporting and could no longer support the growing operational, analytical, and insights demands of a rapidly expanding business.
Approach
Designed and led the migration of the analytics infrastructure to Google Cloud and BigQuery, establishing a centralized data warehouse and automated data pipelines. Integrated reporting directly into tools already used across the organization, enabling self-service access to trusted data, automated dashboard refreshes, and significantly faster delivery of business insights.
Tools

Projects

Advanced Dataform framework

Reduced a model definition from approximately 150 lines to 20 lines of configuration in the documented example, while standardizing cost-efficient, production-ready BigQuery patterns across pipelines.
Challenge
Google Cloud Dataform simplified pipeline orchestration, but the existing setup still relied on full-table assertions, custom partition-aware MERGE logic, manual schema changes, and external orchestration for some steps. That added BigQuery scans and maintenance work as workloads grew.
Approach
Extended Google Cloud Dataform with a reusable modeling framework that standardizes advanced BigQuery engineering patterns across pipelines. The framework automates incremental processing, schema evolution, partition and clustering management, and partition-scoped data quality checks. This turned complex pipeline requirements into reusable model configurations, reducing unnecessary BigQuery scans and reliance on external orchestration.
Tools
Welcome

Quick intro

I’m Bolaji, a Data Engineer & Architect. I design and build production data platforms and marketplace analytics solutions, and lead the teams behind them.

I design how data flows from source systems to the products teams use. I build batch and streaming pipelines, model warehouse and lakehouse data, and build governed applications.

Former Head of Data with 7+ years building data platforms. Statistics Graduate with a decade across analytics, data science, and data engineering. Hands on GCP & AWS.

Built and led a data team from 0 to 14. Delivered ~300 bigquery models and airflow dags for reporting, self-service and operational tools. Led workloads optimisation that reduced GCP cost by 42.57% in one quarter.