A dbt "logic mesh" with packages: standard model and metrics across 25 autonomous organizations
Greenpeace unified metrics across 25 independently run organizations with a three-layer dbt package architecture, without a mandate to force anyone to comply.
Overview
Greenpeace International manages data across 25 independent entities on different platforms using a three-tiered dbt package strategy (source packages, localized transformation logic, unified metrics model). A 12-person team onboards new offices every two months and stands up full warehouses in 14 days.
What you'll take away
- 01
Greenpeace's roughly 10-person central team supports 25 independently run national organizations through a three-layer package architecture: source packages, a thin per-organization intermediate layer, and one shared standard data model.
- 02
The hardest part wasn't technical, it was linguistic: getting 25 organizations to agree on what a shared term like "donor" actually meant before building anything.
- 03
About 75% of the logic in any organization's project now lives in shared packages, and roughly 50 package releases a month propagate automatically to 170 consuming projects, 120 of which need no human intervention at all.
Session speaker
Koen Verburg
Greenpeace International