Decisions / Capability Assessment

Capability Maturity Assessment

Capability maturity assessment for enterprise data platforms. 15 capabilities scored across 4 levels. Identify specific gaps and prioritize investment.

Platform maturity is not uniform. An organization can be Level 4 on batch ingestion and Level 1 on lineage, and a single platform-wide score hides exactly the gaps that hurt. This assessment scores 15 capabilities independently, so you can identify specific gaps and prioritize investment. The danger it guards against is real: leaders see a well-orchestrated pipeline and conclude the platform is mature, then a regulator asks for column-level lineage and nobody can produce it.

This is the assessment-tool companion to the organizational Maturity Model. The four levels here compress its five: Fragmented spans the model’s Ad Hoc and Managed levels, Standardized and Governed correspond directly, and Enterprise-Grade maps to Optimized. Use the model to describe the platform to leadership; use this page to decide what to fix next.

Capability Maturity Matrix

Score each capability against four levels. Be honest; the value of this exercise is proportional to how uncomfortable the results make you.

CapabilityLevel 1: FragmentedLevel 2: StandardizedLevel 3: GovernedLevel 4: Enterprise-Grade
Batch ingestionManual scripts, ad-hoc extracts, tribal knowledge about source systemsScheduled pipelines with basic monitoring, documented source connectionsSelf-serve ingestion with automated onboarding, templated connectorsMulti-source orchestrated ingestion, SLA-driven with automated failover
CDCNone, or manual full extracts pretending to be incrementalBasic CDC with polling or timestamp-based detectionStreaming CDC with schema evolution handled automaticallyReal-time CDC with inline quality validation and guaranteed delivery
LineageNone. Nobody knows where data comes from or who consumes itManual documentation that is already out of dateAutomated technical lineage captured from pipeline metadataColumn-level lineage, impact analysis, regulatory-ready reporting
Quality controlsNo checks. Data is assumed correct until someone complainsBasic row counts and null checks on critical tablesAutomated quality gates at each layer transition, alerting on failuresQuality contracts with SLOs per dataset, trend analysis, consumer-facing dashboards
HistorizationOverwrite. Yesterday’s data is gone foreverBasic SCD Type 1 (current state only) with some audit columnsSCD Type 2 or append-only patterns with valid-from/valid-to trackingBitemporal modeling with full audit history, correction tracking, and point-in-time queries
OrchestrationCron jobs. Nobody knows the dependency graphAirflow or Composer with basic DAGs, manual retry on failureDependency-aware orchestration with retry logic, SLA tracking, and alert routingSelf-healing pipelines, dynamic scheduling based on data availability, cross-domain coordination
Access controlShared credentials or wide-open service accountsRole-based access at the dataset level, manually maintainedColumn-level and row-level security policies, access request workflowsAttribute-based access control, automated periodic review, dynamic masking
Data contractsNone. Producers change schemas whenever they wantInformal agreements: “we’ll let you know before we change things” (they won’t)Formal schemas with versioning, published SLAs, and notification policiesContracts enforced in CI/CD, breaking changes blocked until consumers acknowledge
Cost managementNo visibility. Data infrastructure costs are buried in cloud billsMonthly bill review, someone investigates spikes after they happenChargeback by domain or team, query cost limits, storage tieringCost per data product, predictive cost modeling, automated optimization recommendations
MetadataNone. Data exists but nobody can find it or understand what it meansBasic catalog with table-level descriptions, manually maintainedAutomated metadata capture from pipelines, searchable catalog with freshness indicatorsUnified business, technical, and operational metadata with usage analytics and lineage integration
Pipeline monitoringNone. Failures are discovered when a consumer complainsJob success/failure tracking with email notificationsSLA tracking per pipeline, freshness monitoring, automated escalationPredictive monitoring with anomaly detection, capacity forecasting, and consumer impact analysis
Self-service accessNone. All data access requires a ticket to the platform teamShared tables available in a warehouse, no documentation or guaranteesGoverned datasets with documentation, quality indicators, and access request workflowsData marketplace with contracts, SLAs, usage metrics, and consumer feedback loops
ML/AI integrationNone. Data scientists extract raw data and build everything from scratchAd-hoc notebook access to warehouse tables, no feature managementOffline feature store with versioned feature definitions and governed training datasetsOnline and offline feature stores, production serving integration, feedback loops from predictions
ReconciliationNone. Nobody validates that data in the platform matches the sourceManual spot checks when something looks wrong, usually after a business decision was already madeAutomated cross-source reconciliation checks at defined intervalsContinuous reconciliation with tolerance thresholds, automated alerting, and root cause tracking
Schema managementAd-hoc changes. Someone alters a table in production and hopes nothing breaksDocumented change process: changes are reviewed but not validated automaticallySchema evolution policies with compatibility rules (backward, forward, full)Automated compatibility validation in CI/CD, schema registry with versioning and deprecation

How to Use This Assessment

Score each of the 15 capabilities from 1 to 4 based on your current state. Not your planned state. Not where you will be next quarter. Where you are right now.

Step 1: Score honestly. Walk through each row with the people who actually operate the capability, not the people who designed it. Architects will tell you Level 3. Operators will tell you the truth.

Step 2: Identify urgent gaps. Any capability below Level 2 is a gap that will bite you. Level 1 means no standard process exists; you are relying on individuals, not systems. These capabilities break when someone goes on holiday.

Step 3: Flag compliance-critical capabilities. Lineage, access control, quality controls, historization, and reconciliation have regulatory implications. If any of these sit at Level 2, they need to reach Level 3 before your next audit, not before your next roadmap cycle.

Step 4: Prioritize governance before consumption. It is tempting to invest in self-service access and ML integration because they are visible to stakeholders. But self-service without quality controls produces self-service garbage. ML without lineage produces models nobody can explain to a regulator. Build the governance foundation first.

Step 5: Reassess quarterly. Capability maturity changes. It also regresses: a team reorganization, a key departure, or a migration can drop a capability by a full level. Track movement over time, not just the current snapshot.

Common Patterns

These patterns show up in nearly every assessment. Recognizing yours is the first step toward fixing it.

Strong ingestion, weak governance

Data gets into the platform efficiently. Pipelines are reliable, orchestration works, monitoring catches failures. But nobody knows what the data means, who owns it, or whether it is correct. The platform is a well-oiled machine that produces undocumented, ungoverned output. Business users do not trust it, so they maintain their own spreadsheets alongside it.

Strong BI, weak contracts

Dashboards work. Executives get their reports. Then an upstream team renames a column and half the dashboards break on Monday morning. There is no contract between producer and consumer, just implicit dependencies that work until they do not. The BI team spends more time fixing breakages than building insights.

Strong security, weak lineage

Access control is tight. PII is masked. Audit logs exist. But when a regulator asks “show me every system this customer’s data flows through,” nobody can answer without a two-week manual investigation. Security without lineage means you can prove who accessed data but not where it came from or where it went.

Strong platform, weak operations

The architecture is sound. The technology choices are defensible. The platform could handle ten times the current load. But nobody owns incident response. Alert fatigue has set in because every quality check fires a notification and nobody triages them. Pipeline failures are resolved by the person who happens to notice, not by a defined process. Technical excellence without operational discipline produces an impressive platform that is unreliable in practice.

Sample Assessment Visualization

The chart below shows a typical enterprise assessment: strong in some areas, weak in others. The unevenness is the point. If your assessment produces a flat line, you either have a genuinely mature platform or you are not being honest.

SAMPLE ASSESSMENT · STRONG INGESTION, WEAK GOVERNANCE 0 1 2 3 4 Batch ingestion 3 CDC 2 Lineage 1 Quality controls 2 Historization 2 Orchestration 3 Access control 3 Data contracts 1 Cost management 2 Metadata 1 Pipeline monitoring 2 Self-service access 1 ML/AI integration 1 Reconciliation 1 Schema management 2 MATURITY LEVEL · NAVY = AT LEVEL 1, THE INVESTMENT PRIORITIES
A typical uneven assessment: operational capabilities mature, governance capabilities at Level 1

This sample reflects the “strong ingestion, weak governance” pattern. Batch ingestion and orchestration are at Level 3. Access control is at Level 3 because security invested in it independently. But lineage, contracts, metadata, and self-service are all at Level 1: the platform ingests and secures data effectively, but nobody can find it, understand it, or trust it without asking the platform team.

The fix is not to improve ingestion further. The fix is to raise lineage, metadata, and contracts to Level 2 before doing anything else. The highest-value investment is always in the weakest governance capability, not in the strongest operational one.

Using this framework for an architecture review or a target-state design? Start with the review checklists, open an issue on GitHub, or reach the author at sunil@sunilprakash.com.

Search the guide