Enterprise data warehouse

Bringing operational, CRM and financial data into one place, so the numbers mean the same thing to everyone.

Employer project · implementation details are intentionally limited.

At Karage, I designed dimensional data models and contributed to a centralized BigQuery warehouse that brings together CRM, finance, and production data for reporting and analysis.

The broader initiative includes Apache Airflow ingestion and transformation workflows, migration planning, shared reporting structures, and cross-functional requirements gathering. It supports analytics across more than 1,000 customers, 2,000+ branches, and 300,000+ vehicle records.

One concrete outcome was consolidating multiple reporting workflows and reducing report-generation time by 60%.

Related: Data engineering · Experience