Cowbell · 2023 - Present
Medallion Data Warehouse
Redshift as a reusable enterprise warehouse: Bronze, Silver, Gold and domain marts with dbt models, separating ingestion, normalization, business modeling and consumption.
Kumar Gaurav · Staff Data ArchitectThe problem
The warehouse had grown around a single use case. Adding a new domain meant reworking the whole stack.
Key decisions
- Separate raw data from business semantics.
- Incremental dbt transformations run on ECS, orchestrated through Glue.
- Physical design tuned to workload, not one-size-fits-all.
- Marts aligned to consumption domains with clear ownership.
Outcome
New domains can be added without recreating the stack, and the warehouse serves the wider company rather than one product.
Architecture flow
- Source systems
- Ingestion
- Bronze: raw and traceable
- Silver: clean and standardized
- Gold: business models
- Data marts for domain consumption
More architecture work
Book a conversationEnterprise Data Foundation
A reusable data foundation for risk, products, analytics and AI, not one-off pipelines. Ingestion, medallion warehouse layers, domain marts and operational distribution from a single architectural spine.
Read case studyGlobal Risk Data Platform
Large-scale company risk-data architecture that ingests, enriches, normalizes and distributes company-level intelligence across countries. Built as a reusable risk pool for underwriting, products, analytics and intelligent systems, and today the data foundation beneath Cowbell's OMNI AI agents.
Read case studyGlueFlux
Metadata-driven processing framework. Pipelines defined in YAML so teams onboard Spark, Python and dbt workloads without rebuilding orchestration, deployment and operational patterns every time.
Read case study