On May 17, 2026, InfoQ reported on Neobank Monzo Builds Governed Data Mesh Across 100 Teams and 12000 dbt Models. Monzo established a data mesh that balances decentralized ownership with centralized governance at a scale of 100 teams and 12,000 dbt models. This structure delegates data ownership to domain teams while contracts, quality, and lineage are secured by a central platform.
From the perspective of designing data platforms for mid-sized companies in custom development, this provides a blueprint for resolving the issue where dbt models multiply to the point where nobody has a complete view. Following our work covered in DuckLake 1.0 Data Lakehouse Custom Development for Mid-Sized Companies and Netflix Model Lifecycle Graph Custom MLOps Governance, this represents the first large-scale case in the dbt ecosystem that successfully implements the structure of distributing data ownership and responsibility while centrally guaranteeing quality. This article outlines the architecture, phases, contract clauses, and ROI approach when delivering data mesh migration and dbt governance for clients.
Why Demand for Custom Development Explodes at Mid-Sized Companies Facing dbt Sprawl
| Structure | Monolithic DWH | Uncontrolled dbt Sprawl | Governed Data Mesh |
|---|---|---|---|
| Model Ownership | Entirely owned by data team | Unknown (unable to trace who made changes) | Explicitly owned by domain teams |
| Quality Responsibility | Data team | Ambiguous | Domain teams + central contracts |
| Dependencies | Manageable | Explosive across 12,000 models | Explicitly defined via data contracts |
| Impact of Changes | Company-wide coordination | Noticed only after breaking | Blocked proactively via contract violation detection |
| New Additions | Approved by data team | Added arbitrarily by each team | Domain approval + central review |
| PII / Compliance | Central checks | Numerous loopholes | Automated tag-based inspection |
In other words, the problem mid-sized companies face where everything collapses the moment dbt models exceed 500 can be structurally solved through migration to a data mesh.
Three Structural Shifts Driven by a Governed Data Mesh
Shift 1: Moving from Data Team Monopolies to Domain Ownership
Each domain team—including sales, accounting, and marketing—owns and updates its own dbt models. The data team is redefined into a step-back role as a platform provider.
Shift 2: Moving from Manual Visual Checks to Data Contracts
Schemas, row counts, null rates, cardinality, and other rules are codified into data contracts and validated automatically within CI. Violations block production deployments.
Shift 3: Moving from Executive Distrust of KPIs to Full Lineage Tracking
Executive dashboard figures can be traced with a single click through lineage to see which dbt model, source table, and core business system they originated from. Debates over whether these numbers are trustworthy disappear from executive meetings.
The Five Phases of Delivering Data Mesh Migration and dbt Governance for Clients
Phase 1: Existing dbt Inventory Audit (2 to 3 Weeks)
We conduct a comprehensive review of the client's dbt project to visualize models with unknown ownership, duplicate logic, deprecation candidates, and high-risk changes. In many mid-sized companies, 20% to 40% can be deprecated.
Phase 2: Domain Decomposition Design (3 to 4 Weeks)
We split dbt models into three to seven domains, such as management, sales, accounting, marketing, and product. Domain leads are designated on the client side.
Phase 3: Data Contracts and Governance Infrastructure Setup (4 to 6 Weeks)
- Automated validation via dbt-checkpoint, dbt-meta-testing, and Great Expectations
- Lineage management via OpenMetadata, DataHub, or Unity Catalog
- PII tagging and automated masking
Phase 4: Domain Team Onboarding (6 to 8 Weeks)
We train each domain to operate under a model where they write and review their own team's dbt code. The custom development partner transitions into a coaching role.
Phase 5: Monthly Data Governance Meetings (Ongoing)
On a monthly basis, we report to executive management on the number of contract violations, deprecated models, new models, and quality scores by domain.
Standard technology stack set for custom development
| Layer | Recommended technology | Alternative |
|---|---|---|
| Data Transformation | dbt Core / dbt Cloud | SQLMesh |
| Data Contracts | dbt-contracts / Soda | Great Expectations |
| Metadata Management | OpenMetadata / DataHub | Unity Catalog |
| DWH | BigQuery / Snowflake | Databricks / DuckLake |
| Orchestration | dbt Cloud / Dagster | Airflow |
| Visualization | Looker Studio / Metabase | Tableau |
| CI | GitHub Actions + dbt CLI | GitLab CI |
This is positioned as an extension of our BigQuery + Looker Studio Data Platform Custom Development for Mid-Sized Companies.
Which projects need this and which do not
| Projects requiring this | Projects not requiring this |
|---|---|
| 200+ dbt models | dbt not introduced / fewer than 50 models |
| Organizations with 5+ domains | Single domain |
| Leadership questions KPI figures | No doubts regarding KPI figures |
| Monthly or weekly report delays | Operations with low real-time requirements |
| Handles PII / personal information | Internal statistics only |
Six clauses to include in client contracts
| Clause | Details | What the client should verify |
|---|---|---|
| Target dbt Projects | Scope list | Liability outside scope |
| Data Contract SLAs | Time from violation detection to remediation deadline | Acceptable tolerance for business impact |
| Domain Lead Authority | Approval and review authority | Workload when holding concurrent roles |
| PII Tagging Accuracy Target | 95% or higher, etc. | Audit trails |
| Handover upon contract termination | dbt + metadata + IaC | Copyright and intellectual property attribution |
| Incident Escalation Tree | Business hours / 24/7 | Need for direct executive line |
Estimated Client ROI (Assuming 1,200 dbt Models across 6 Domains)
| Item | Without Migration | With Migration | Difference |
|---|---|---|---|
| Monthly broken dashboard count | 28 incidents | 4 incidents | -24 incidents |
| Data team effort | 480 hours/month | 180 hours/month | -300h |
| Reporting delay to management | 12 days/month | 2 days/month | -10 days |
| Deprecated dbt models | 0 | 320 inquiries | — |
| Annual audit effort | 240h | 60h | -180h |
| Annual benefit | — | — | Approximately 24M to 36M JPY |
At this scale, achieving payback within the first year comes well into reach even after subtracting migration and ongoing governance operational costs. When evaluating investment decisions, consider converting the data team and audit labor figures in the table above using your internal personnel rates.
Five common pitfalls
Pitfall 1: Appointing Domain Leads with Concurrent Roles
Actual ownership will not function. Build 0.3 to 0.5 dedicated person-months directly into the contract.
Pitfall 2: Making Data Contracts Too Rigid
Development velocity will stall. A phased introduction—such as warnings only initially, followed by blocking after three months—is essential.
Pitfall 3: Attempting to Migrate All Existing dbt Assets
Between 20% and 40% are candidates for deprecation. Specify a sequence of deprecation, consolidation, then migration in the contract.
Pitfall 4: Failing to Select a Metadata Management Platform
Operational philosophies vary greatly across OpenMetadata, DataHub, and Unity Catalog. Always run a PoC covering all three platforms with the client.
Pitfall 5: Delaying Visibility for Executive Leadership
Presenting only the number of contract violations fails to resonate with leadership. Translating this into a data reliability rate KPI is essential.
90-day action plan
| Week | Action |
|---|---|
| Week 1〜3 | dbt inventory audit + domain candidate design |
| Week 4〜7 | Data contract platform + metadata management deployment |
| Week 8〜10 | Pilot rollout in 1 to 2 domains |
| Week 11〜13 | Full domain rollout + monthly review setup |
Summary: Governance Custom Development Rescuing Teams Paralyzed by Excessive dbt Sprawl
Monzo's case demonstrated that order can be maintained even across 100 teams and 12,000 dbt models. For teams entrusted with custom data platforms for mid-sized enterprises, designing for domain ownership and centralized governance represents the next-generation standard offering.
If you are experiencing issues such as dbt models expanding to where nobody understands the whole picture, leadership questioning KPI metrics, or frequently broken dashboards, please reach out via our inquiry form. Because the required scope varies significantly based on model count, domain count, and existing DWH architecture, we provide tailored quotes following an initial assessment of your current environment.








