000 Blog Template

It’s 7:14 AM, and Finance has already filed a ticket. The overnight reconciliation report is missing data. You open three tools and work through the list: 

✔ The Apache Airflow DAG completed

✔  The Snowflake load finished on schedule

✔  The ERP batch job ran without error

Every status is green. An hour later, after pulling logs and looping in data engineers and the ERP team, the root cause surfaces: a batch window collision. Three days earlier, someone on the data engineering team rescheduled a Snowflake data transformation job without flagging the downstream dependency. By the time the transformation finished, the ERP ingestion window had already opened and run on whatever data happened to be there.

No tool failed. No alert fired. The business simply didn’t get what it needed.

Here’s what should bother you about this: every tool in the chain did its job correctly. The Airflow DAG ran exactly as designed. Snowflake processed its workload on schedule. The ERP batch process completed without error. The failure didn’t happen inside any of these systems. It happened in the space between them — the business process handoff that none of them was built to own.

Who’s accountable for the execution chain from system to system?

This isn’t a tooling failure, and it isn’t a criticism of any individual platform. Airflow is excellent at orchestrating data engineering workflows. Snowflake is excellent at processing analytical workloads. ERP schedulers are excellent at managing batch execution. Each of these tools does exactly what it was designed to do, within its own domain.

But the metric your leadership actually cares about — Did the business get trusted data on time? — isn’t tracked by any of them. There’s no shared dependency model spanning the end-to-end workflow, no common SLA tying the outputs of one system to the inputs of the next and no unified data pipeline monitoring capability that measures data flow against business deadlines rather than technical job completion. Each tool’s definition of “done” stops at its own boundary.

A 2025 IBM Institute for Business Value study of 1,700 chief data officers found that poor data quality often goes unnoticed precisely because its impact doesn’t surface at the point of failure. It appears downstream as an incorrect decision, lost revenue, process delays and compliance exposure, long after the root cause has propagated.

If that finding describes your Monday morning with uncomfortable precision, will you keep treating these episodes as isolated incidents, or will you recognize them as an architectural gap in how the end-to-end business process is governed?

The postmortem cycle you can’t break

By the time Finance files the ticket, the failure has already propagated. The reconciliation report is wrong, the financial close cycle may have started on incomplete data and your team is in recovery mode, conducting root-cause analysis on a problem that occurred hours earlier. Mean time-to-resolution (MTTR) starts from when the business notices, not when the job failed. The time between those milestones is typically measured in hours.

What makes this pattern so persistent is that it never quite presents as a systems failure. It looks like a process coordination issue, easily slipping between the various team-to-team cracks. And it gets addressed in a postmortem, assigned to a working group and recurs two months later with a marginally different trigger: a different rescheduled job, a different batch window, a different team that lacked awareness of the downstream dependency.

You’ve seen this cycle. The postmortem identifies “improved cross-team communication” as the fix. The action item is a shared calendar or a Slack channel. It holds for six weeks. Then someone new joins the data engineering team, a batch window shifts by 30 minutes or a schema change propagates without notification, and nobody updates the tribal knowledge that was holding the chain together.

The structural cause is that no one owns the end-to-end business process that spans these tools. It’s never truly resolved because it’s rarely named as the problem. Instead, it gets filed under “communication,” which is a diplomatic way of saying “we have no dependency model across the business workflow, and we’re substituting human memory for architecture.”

Two chains, same invisible failure

The handoff problem surfaces differently depending on where it hits. Two scenarios illustrate how much ground it covers.

  1. In a B2B edge-to-core flow, a supplier file arrives at the network edge via a secure file transfer gateway. From there, the file requires transformation, schema validation and ingestion into the ERP as part of a larger supply chain or financial process. Each step runs on a different schedule, owned by a different team, with no shared data lineage connecting receipt to posting. When the supplier file lands two hours late, the failure is silent until inventory counts are off, an invoice doesn’t post or a supply chain decision gets made on data that hasn’t fully arrived. IT owns the latency, even though the failure happened in a gap nobody was monitoring.
  2. In a financial close scenario, period-end close depends on outputs from cloud data platforms like Snowflake, Databricks or a cloud data warehouse service, feeding into the ERP’s record-to-report process. When data engineering reschedules a transformation job without flagging the downstream ERP dependency, the batch window executes, the job shows green and Finance pulls the morning pack to find numbers that don’t reconcile. The data freshness issue doesn’t surface until the business is already operating on compromised figures.

In both cases, every individual tool performed correctly within its own domain. The failure resided in the business process that depended on their outputs arriving in the right sequence, at the right time, for the right downstream system.

The reflex that keeps you stuck

When the same failure recurs, the instinct is to add more observability: more alerts, more status feeds, another real-time dashboard layered on top of existing tooling. More signal gets you to the problem faster, but it doesn’t change the fact that the business found the problem first.

This is where most IT Ops leaders get trapped. You’re optimizing for faster reaction when the real leverage is in eliminating the category of failure entirely. The absence in most hybrid environments isn’t signal, but scope

Each tool produces comprehensive telemetry about its own execution. What’s missing is visibility across the end-to-end business process that depends on those tools. SLA management is tied to business outcomes rather than individual job completion, and dependency mapping spans the full workflow from data platform outputs through ERP ingestion to downstream business action.

That’s the layer a business service orchestration platform like RunMyJobs by Redwood occupies. It doesn’t replace Airflow, Snowflake, ERP schedulers or any other domain-specific tool. Each continues to do what it does best. RunMyJobs integrates their inputs and outputs into the broader business workflow, applying SLA monitoring, compliance, security and dependency governance across the full chain. It’s the technology-agnostic orchestration layer for the business process that currently has no owner.

Visibility starts where the tools stop

The hybrid application and data technology estate won’t consolidate or become less complex on its own. Innovation demands that new applications be built and new platforms be adopted. With this inevitable expansion comes the open-source data pipeline orchestrator, application-native scheduler, cloud service tooling, ERP batch process and trading partner file transfer workflows. This is the environment today — and for the foreseeable future. 

Come back to the 7:14 AM ticket. If you had RunMyJobs running that business service, the ticket would have never happened. Neither would the multi-team incident response, the protracted root-cause analysis and all the finger-pointing and frustration these types of failures create. RunMyJobs would have monitored, identified and automatically remediated the situation, and the business service would have been delivered on time, without error. 

Closing this architectural gap requires a strategic decision on application and data orchestration. It means looking at your automation silos and deciding to consolidate mission-critical business application outcomes onto a platform that can accelerate your transformation at the lowest possible total cost of ownership (TCO). That’s not a monitoring upgrade, an amended cross-team communication process or another dashboard that doesn’t address the underlying problem. It’s a different and vastly superior operating model. 

See how RunMyJobs connects hybrid data pipelines into a single governed execution layer.

About The Author

Gerben Blom's Avatar

Gerben Blom

Gerben Blom has 20 years of expertise in the workload automation space. At Redwood, he has held roles as Principal Product Architect and Product Leader and is now Field CTO for RunMyJobs by Redwood. Considered the global subject matter expert on automation and digital transformation topics, he has a background in implementing and designing customer use cases and abstracting them into product features, enabling the biggest organizations on the planet to achieve their business goals. Gerben has always put the customer first to maximize the value of Redwood solutions in their automation and transformation journeys.

Gerben holds a Master’s in Artificial Intelligence from the University of Groningen, the Netherlands.