CoDataWeb All articles
Engineering

Your Data Scientists Aren't Building — They're Hunting Bugs. Here's Why That's a Monitoring Problem

CoDataWeb
Your Data Scientists Aren't Building — They're Hunting Bugs. Here's Why That's a Monitoring Problem

Imagine hiring a chef to run your kitchen and then making them spend half their shift figuring out why the oven stopped working last Tuesday. That's more or less what's happening on data teams across the country right now. The people you brought in to model churn, build recommendation engines, and surface business insights are instead playing detective — tracing broken DAGs, tracking down nulls that shouldn't exist, and answering the eternal Slack message: "Hey, why does this number look weird?"

This isn't a talent problem. It's an observability problem. And it's quietly eating your team alive.

The Actual Cost of Reactive Debugging

A commonly cited figure in the data engineering world — backed by surveys from outfits like Anaconda and various data practitioner communities — is that data professionals spend somewhere between 30% and 45% of their time on data cleaning and troubleshooting rather than analysis or model development. That's not a rounding error. On a team of eight, that's essentially three full-time employees whose output is going entirely toward keeping the lights on.

What makes this especially painful is that most of these issues aren't discovered proactively. They surface when a business analyst notices a dashboard looks off, when a product manager asks why a metric dropped overnight, or when a customer complains. By then, you're already behind. The pipeline failed hours ago. The bad data has propagated. The trust is already damaged.

This is the debugging tax — and most organizations are paying it without realizing it's even on the invoice.

Why Data Pipelines Are Uniquely Hard to Monitor

Software engineers have had decades to develop monitoring culture. Tools like Prometheus, Grafana, and Datadog are practically standard issue at this point. Uptime dashboards, error rate alerts, latency thresholds — these are table stakes in traditional application infrastructure.

Data pipelines are a different beast. A pipeline can "succeed" in every technical sense — the job completes, no exceptions are thrown, the scheduler moves on — and still produce completely wrong output. A join silently drops 40% of records. An upstream schema change causes a column to go null. A timezone bug shifts every timestamp by six hours. The system doesn't know it failed, so it doesn't tell you.

This is what engineers mean when they talk about silent failures, and they're endemic to data infrastructure. Traditional application monitoring isn't built to catch them.

What Open Source Projects Are Getting Right

The good news is that the open-source community has been chipping away at this problem for a few years now, and some genuinely useful patterns have emerged.

Great Expectations is probably the most widely adopted open-source data quality framework in the US right now. The core idea is straightforward: you define expectations about your data — column X should never be null, value Y should fall between 0 and 1, row count should be within 10% of yesterday's — and you run those checks as part of your pipeline. If something violates an expectation, you know immediately rather than three days later.

What makes Great Expectations compelling for teams that are new to data observability is that it generates human-readable documentation from your validation rules. Your expectations become your data contracts, and your data contracts become living docs. That's a pattern the open-source world figured out early: monitoring and documentation shouldn't be separate concerns.

Elementary takes a slightly different approach, sitting on top of your existing dbt models and warehouse to run statistical anomaly detection automatically. Rather than requiring you to define every possible failure mode upfront, it learns what "normal" looks like for your data and flags deviations. For teams that don't know where to start with data quality rules, this is a lower-friction entry point.

Apache Airflow's built-in alerting and the broader ecosystem of Airflow plugins have also matured significantly. Teams that are already using Airflow for orchestration can layer in SLA monitoring, task duration alerts, and dependency checks without adopting entirely new tooling.

What Actually Works at Different Scales

Here's the honest take: the right approach depends heavily on where your team is.

Small teams (1–5 data people): Don't try to boil the ocean. Pick your three or four most business-critical pipelines — the ones where failure causes the most pain — and add basic row count checks and null rate monitoring. Even a simple dbt test suite that runs on every model refresh will catch a surprising percentage of real-world failures. The goal at this stage is to stop finding out about problems from non-technical stakeholders.

Mid-size teams (5–20 engineers): This is where investing in a proper data observability layer starts paying off. Tools like Elementary or a managed solution like Monte Carlo can start to give you coverage across your entire warehouse rather than just the pipelines you remembered to instrument. Start building a data SLA culture — define what "healthy" means for key datasets and make that visible to the whole team.

Larger organizations: At scale, you're probably dealing with hundreds or thousands of pipelines and multiple data consumers with different reliability expectations. The open-source path here often means stitching together Airflow, Great Expectations, dbt tests, and something like Grafana for a unified view. Some teams build internal tooling on top of these. The key shift at this scale is moving from reactive alerting (something broke, go fix it) to predictive monitoring (this dataset is trending toward a quality threshold breach, go investigate).

Changing the Culture, Not Just the Tooling

Tools alone won't solve this. One of the most consistent findings from teams that have successfully reduced their debugging overhead is that the tooling change was the easy part. The harder part was establishing the expectation that data quality checks are part of shipping a pipeline — not an optional extra that gets added "when there's time."

That means code review processes that include data quality assertions. It means on-call rotations that include data engineers, not just backend engineers. It means dashboards that show pipeline health alongside business metrics, so leadership understands that data reliability is infrastructure, not housekeeping.

The open-source communities around tools like dbt have actually done a lot of the cultural heavy lifting here. The dbt community norms around testing, documentation, and lineage have spread practices that would have taken years to establish organically at individual companies. Following those community patterns — even if you're not using dbt — is a reasonable shortcut to building a healthier monitoring culture.

Stop Paying the Tax

The debugging tax is real, it's expensive, and it's largely optional. Most organizations are paying it not because monitoring data pipelines is technically impossible, but because it wasn't prioritized early enough and now it feels like too big a lift to address.

It isn't, though. Starting small — a handful of dbt tests, a row count alert, a Slack notification when a critical job runs longer than expected — creates immediate returns. The goal isn't a perfect observability platform on day one. The goal is to make sure your data scientists find out about failures before your VP of Sales does.

That bar is achievable. And the open-source ecosystem has already done most of the hard work to help you clear it.

All Articles

Related Articles

Inheriting a Data Model Nobody Understands: A Practical Guide to Reverse-Engineering Someone Else's Mess

Inheriting a Data Model Nobody Understands: A Practical Guide to Reverse-Engineering Someone Else's Mess

Dead Docs Walking: How Bad API Documentation Drives Away Great Engineers (And What Open Source Communities Figured Out First)

Dead Docs Walking: How Bad API Documentation Drives Away Great Engineers (And What Open Source Communities Figured Out First)

The Hidden Tax on Your Data Team: How Documentation Debt Quietly Drains Engineering Velocity

The Hidden Tax on Your Data Team: How Documentation Debt Quietly Drains Engineering Velocity