Skip to content
  • ·ContentsHome. The title page, every section at a glance.
  • IWritingEssays and longer notes. Slow to write, slower to finish.
  • IIWorkThings I've built. Small, finished, and used by at least one person (me).
  • IIIInspirationThings I want to look at again.
  • IVLinksEverything I read and want to keep, on one page.
  • VQuotesSentences I pressed between pages.
  • VIPlaygroundExperiments that move.
  • VIINowWhat I'm doing this season.
  • ·ColophonHow this book is made: type, plants, sound.
↑↓ move · enter open · esc closetype to search every entry
Collected
06-01-2025
Reading
1 min
Family
#data-engineering · #bigquery

Enterprise data warehouse

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