Skip to main content

The Hidden Data Engineering Work Required to Make Enterprise AI Viable

Aniket Abhishek Soni

Enterprise AI often gets framed as a story about algorithms. The conversation centers on model architecture, parameter counts, and performance benchmarks. Leaders ask which model is best, which vendor is ahead, and how quickly they can deploy something impressive.

But in large enterprises, successful AI is rarely about algorithms alone. It is about the invisible data engineering work that makes those algorithms usable, reliable, and sustainable.

If AI is the engine of a modern organization, then data engineering is the road system beneath it. You can build the most powerful engine in the world, but without paved roads, traffic signals, and bridges that can support its weight, it will stall. In many enterprises, the engine is ready. The roads are not.

AI Is Only as Good as the Data Beneath It

Models fail because the data feeding them is inconsistent, incomplete, or poorly governed. Enterprise data rarely resides in a single place. It sits across legacy systems, cloud warehouses, third-party tools, and departmental silos. Formats vary. Definitions conflict. Ownership is unclear.

Before any model can generate value, data engineers must reconcile this fragmentation. That work includes building ingestion pipelines, normalizing schemas, handling missing values, and resolving duplicate records.

We addressed this by implementing a structured Medallion Architecture (Bronze–Silver–Gold) to standardize ingestion and transformation layers within a distributed Spark environment. At the normalization layer, we applied Master Data Management (MDM) principles and deterministic matching techniques to resolve duplicate records and harmonize instrument identifiers. We also introduced schema enforcement using Delta Lake–style ACID controls and embedded automated validation checks aligned with data quality framework best practices to prevent upstream drift.

Once the data foundation stabilized and referential integrity was enforced, model performance metrics improved significantly, and downstream reporting discrepancies were reduced. The algorithm had not changed. The data engineering discipline had.

This is not glamorous work. It does not make headlines. But it determines whether AI outputs are accurate or misleading.

Building for Scale in Cloud Native Environments

Enterprise AI does not operate in isolation. It must scale across geographies, business units, and workloads. This introduces a second layer of complexity: infrastructure that is cloud-native, elastic, and resilient.

Data pipelines must handle variable loads, support batch and real-time processing, and integrate with orchestration tools. They must be observable, meaning teams can monitor performance, detect anomalies, and trace failures. Without observability, small data quality issues can cascade into large operational disruptions.

Scalability also demands thoughtful architecture. Event-driven systems, distributed processing frameworks, and modular data layers are not optional in large enterprises. They are prerequisites for sustainable AI.

Legacy batch-based ETL systems in large financial environments often struggle with increasing transaction volumes and long processing windows, which delay risk analytics and compliance reporting.

We migrated core workflows into a distributed Apache Spark architecture, implemented Change Data Capture (CDC) for incremental processing to reduce redundant computation, and introduced orchestration aligned with event-driven architecture principles to improve resiliency. The platform was restructured using a layered data model inspired by the Lambda Architecture, enabling both batch and near-real-time processing. We also embedded observability practices consistent with Site Reliability Engineering (SRE) principles to monitor latency, failure points, and data drift.

By restructuring the pipeline into clearly separated bronze, silver, and gold layers, we reduced processing time while improving traceability and cost efficiency. The system became elastic enough to handle peak loads without overprovisioning compute resources, strengthening both performance and financial sustainability.

Auditability and Compliance as Core Requirements

In regulated industries, data engineering is not just a technical function. It is a compliance function. AI systems must be explainable. That means organizations need to trace how data moved from the source to the model to the output. They must document transformations, maintain lineage, and preserve historical states. If an auditor asks how a decision was made, the enterprise must be able to provide a clear answer.

This requires robust metadata management, dataset version control, and strict access controls. It also demands collaboration between engineering, legal, risk, and security teams.

By formalizing data lineage and embedding validation checkpoints directly into the pipeline architecture, we enabled compliance teams to trace outputs back to raw source systems within minutes rather than days. This significantly reduced audit preparation time and increased executive confidence in the integrity of AI-driven insights.

Too often, compliance is treated as an afterthought. A model is built first. Governance is layered on later. This approach rarely works at scale. Retrofitting auditability into an existing pipeline is expensive and disruptive. When data engineering incorporates compliance from the start, AI systems become more trustworthy. Stakeholders gain confidence. Regulators encounter fewer surprises. The organization avoids reputational risk.

In our road analogy, this is equivalent to building bridges that meet safety codes and to highways with clear signage. Without those elements, accidents are inevitable.

The Organizational Work No One Talks About

The technical hurdles are only part of the story. Enterprise data engineering also requires organizational alignment.

Data ownership must be defined. Teams must agree on shared definitions of metrics and entities. Funding must support long-term infrastructure investments rather than short-term experiments.

AI initiatives often begin as innovation projects within a single department. As they expand, they expose inconsistencies in enterprise data practices. What appeared to be a promising pilot becomes a lesson in fragmentation.

Across large enterprises, different business units often maintain their own definitions of core financial and operational metrics. This fragmentation makes it difficult to scale analytics consistently across departments. A key to solving this is to facilitate working sessions between engineering, analytics, and business stakeholder.

By aligning stakeholders around a unified platform strategy rather than isolated pipelines, the organization moved from siloed experimentation to a more cohesive enterprise data ecosystem capable of supporting AI initiatives at scale.

The Long-Term Payoff of Strong Foundations

When enterprises invest in scalable, auditable, cloud native data engineering, the impact extends far beyond AI.

Analytics accuracy improves because metrics are consistent and reliable. Compliance risk decreases because lineage and controls are embedded into the system. Operational performance stabilizes because pipelines are resilient and observable. Over time, the organization becomes more adaptive. New models can be deployed faster because the groundwork is already in place. Business units trust outputs because they understand how they were produced.

The engine finally has a road network in place to support it.

In the end, enterprise AI viability is less about breakthrough algorithms and more about disciplined engineering. The invisible work, the pipelines, the governance, the architecture, is what turns experimentation into sustained value.

Without strong roads, the engine goes nowhere. With them, enterprise AI becomes not just possible, but durable.

About the Author: Aniket Abhishek Soni is a senior data engineer and researcher with more than seven years of experience designing and leading large-scale data pipelines, cloud platforms, and AI-enabled solutions across highly regulated industries, including asset management, healthcare, financial services, and climate research. His work focuses on making enterprise data systems more reliable, governable, and performant to support advanced analytics and applied artificial intelligence in real-world environments.

Aniket Abhishek Soni is a Senior Data Engineer at a leading IT services and consulting company

The Latest

Two years ago, almost every customer conversation about AI started with the same questions: Which model should we use? What can it do? Is it ready for the enterprise? Today, those discussions have moved on. CIOs are far more interested in how to govern AI, integrate it with existing systems, prepare their workforce and make it part of everyday operations. The challenge is no longer to prove that AI can deliver value. It's instead about how to embed AI into the business in a way that's secure, scalable and delivers measurable outcomes ...

 

Two things happened to production incidents between 2023 and now, and they did not happen at the same speed. The first is that a class of dependency that barely existed three years ago now accounts for one incident in ten. Incidents disclosed by AI model and AI application providers rose from 1.7% of all disclosed unplanned incidents in 2023 to 10.7% in 2026 year to date, roughly a sixfold rise; that counts only incidents at AI companies themselves, so the true share is higher. The second is that the time to close an incident has not come down ...

When an AI assistant gives an incomplete or incorrect answer, teams often blame the model. They adjust prompts, switch models, increase context windows or test a new retrieval strategy. However the model may not be a problem. In many enterprise AI workflows, the problem begins inside the document-ingestion pipeline ...

If you talk to any security or observability teams right now, they're all fighting the same fire: their tooling was built to ingest X, but their sources are pumping Y and soon to be doing Z. The knee-jerk reaction is always the same: we need more platform. However, this reaction is wrong. Let me explain why, because the solution to this problem is foundational, not financial. Instead of hurling yet more money at the problem, make sure you've done what's needed upstream ...

Rapid AI adoption and the unique ways AI workloads operate is redefining the scope and structure of what these teams must deliver. This shift is forcing organizations to rethink how they manage scale, automation, and control, according to The State of SRE and Platform Engineering 2026, a new report from Dynatrace ...

AI is usually talked about as a software tool, but it also depends heavily on the network behind it. Whether a company is using AI for chatbots, automation, monitoring, analytics, or employee support, all of that information has to move across the network in a reliable and secure way. That means AI is not just an application decision. It is also an infrastructure decision. Before organizations rush into AI, they should ask a simple question: Is our network ready to support it? ...

Enterprise AI often lacks governed access to where business processes actually execute. Without that access, AI agents may be able to reason, but they cannot operate reliably across enterprise workflows. For AI agents to effectively carry out workflows, they will require integration-layer context and controls. Organizations can implement these prerequisites by providing AI with managed access to the middleware layer ...

Enterprise networks rarely behave the same way for very long. A routing adjustment in one region may unexpectedly alter application performance in another. A cloud migration may introduce hidden dependencies that go unnoticed until an outage occurs. All the while, the network is managed by several different teams, each of whom use different tool sets — and as a result, have different views of the network ... There’s usually an engineer who remembers why traffic fails over a certain way between sites, or which transparent firewall was added where. The problem is that human memory cannot scale alongside enterprise-scale networks ...

Ask an infrastructure team how confident they are in their ability to govern AI, and most will tell you they've got it handled. A recent survey of 406 IT decision-makers and platform engineering leaders found 86% expressing exactly that confidence. Ask the same group whether they have a formal written AI governance policy, and the number drops to 30%, according to Spacelift's Infrastructure Automation Report ...

In MEAN TIME TO INSIGHT Episode 27, Shamus McGillicuddy, EMA VP of Research, Network Infrastructure and Operations, and Parker Hathcock, EMA Research Director covering IT Service/Operations (ServiceOps), discuss observability unification in modern IT operations ... 

The Hidden Data Engineering Work Required to Make Enterprise AI Viable

Aniket Abhishek Soni

Enterprise AI often gets framed as a story about algorithms. The conversation centers on model architecture, parameter counts, and performance benchmarks. Leaders ask which model is best, which vendor is ahead, and how quickly they can deploy something impressive.

But in large enterprises, successful AI is rarely about algorithms alone. It is about the invisible data engineering work that makes those algorithms usable, reliable, and sustainable.

If AI is the engine of a modern organization, then data engineering is the road system beneath it. You can build the most powerful engine in the world, but without paved roads, traffic signals, and bridges that can support its weight, it will stall. In many enterprises, the engine is ready. The roads are not.

AI Is Only as Good as the Data Beneath It

Models fail because the data feeding them is inconsistent, incomplete, or poorly governed. Enterprise data rarely resides in a single place. It sits across legacy systems, cloud warehouses, third-party tools, and departmental silos. Formats vary. Definitions conflict. Ownership is unclear.

Before any model can generate value, data engineers must reconcile this fragmentation. That work includes building ingestion pipelines, normalizing schemas, handling missing values, and resolving duplicate records.

We addressed this by implementing a structured Medallion Architecture (Bronze–Silver–Gold) to standardize ingestion and transformation layers within a distributed Spark environment. At the normalization layer, we applied Master Data Management (MDM) principles and deterministic matching techniques to resolve duplicate records and harmonize instrument identifiers. We also introduced schema enforcement using Delta Lake–style ACID controls and embedded automated validation checks aligned with data quality framework best practices to prevent upstream drift.

Once the data foundation stabilized and referential integrity was enforced, model performance metrics improved significantly, and downstream reporting discrepancies were reduced. The algorithm had not changed. The data engineering discipline had.

This is not glamorous work. It does not make headlines. But it determines whether AI outputs are accurate or misleading.

Building for Scale in Cloud Native Environments

Enterprise AI does not operate in isolation. It must scale across geographies, business units, and workloads. This introduces a second layer of complexity: infrastructure that is cloud-native, elastic, and resilient.

Data pipelines must handle variable loads, support batch and real-time processing, and integrate with orchestration tools. They must be observable, meaning teams can monitor performance, detect anomalies, and trace failures. Without observability, small data quality issues can cascade into large operational disruptions.

Scalability also demands thoughtful architecture. Event-driven systems, distributed processing frameworks, and modular data layers are not optional in large enterprises. They are prerequisites for sustainable AI.

Legacy batch-based ETL systems in large financial environments often struggle with increasing transaction volumes and long processing windows, which delay risk analytics and compliance reporting.

We migrated core workflows into a distributed Apache Spark architecture, implemented Change Data Capture (CDC) for incremental processing to reduce redundant computation, and introduced orchestration aligned with event-driven architecture principles to improve resiliency. The platform was restructured using a layered data model inspired by the Lambda Architecture, enabling both batch and near-real-time processing. We also embedded observability practices consistent with Site Reliability Engineering (SRE) principles to monitor latency, failure points, and data drift.

By restructuring the pipeline into clearly separated bronze, silver, and gold layers, we reduced processing time while improving traceability and cost efficiency. The system became elastic enough to handle peak loads without overprovisioning compute resources, strengthening both performance and financial sustainability.

Auditability and Compliance as Core Requirements

In regulated industries, data engineering is not just a technical function. It is a compliance function. AI systems must be explainable. That means organizations need to trace how data moved from the source to the model to the output. They must document transformations, maintain lineage, and preserve historical states. If an auditor asks how a decision was made, the enterprise must be able to provide a clear answer.

This requires robust metadata management, dataset version control, and strict access controls. It also demands collaboration between engineering, legal, risk, and security teams.

By formalizing data lineage and embedding validation checkpoints directly into the pipeline architecture, we enabled compliance teams to trace outputs back to raw source systems within minutes rather than days. This significantly reduced audit preparation time and increased executive confidence in the integrity of AI-driven insights.

Too often, compliance is treated as an afterthought. A model is built first. Governance is layered on later. This approach rarely works at scale. Retrofitting auditability into an existing pipeline is expensive and disruptive. When data engineering incorporates compliance from the start, AI systems become more trustworthy. Stakeholders gain confidence. Regulators encounter fewer surprises. The organization avoids reputational risk.

In our road analogy, this is equivalent to building bridges that meet safety codes and to highways with clear signage. Without those elements, accidents are inevitable.

The Organizational Work No One Talks About

The technical hurdles are only part of the story. Enterprise data engineering also requires organizational alignment.

Data ownership must be defined. Teams must agree on shared definitions of metrics and entities. Funding must support long-term infrastructure investments rather than short-term experiments.

AI initiatives often begin as innovation projects within a single department. As they expand, they expose inconsistencies in enterprise data practices. What appeared to be a promising pilot becomes a lesson in fragmentation.

Across large enterprises, different business units often maintain their own definitions of core financial and operational metrics. This fragmentation makes it difficult to scale analytics consistently across departments. A key to solving this is to facilitate working sessions between engineering, analytics, and business stakeholder.

By aligning stakeholders around a unified platform strategy rather than isolated pipelines, the organization moved from siloed experimentation to a more cohesive enterprise data ecosystem capable of supporting AI initiatives at scale.

The Long-Term Payoff of Strong Foundations

When enterprises invest in scalable, auditable, cloud native data engineering, the impact extends far beyond AI.

Analytics accuracy improves because metrics are consistent and reliable. Compliance risk decreases because lineage and controls are embedded into the system. Operational performance stabilizes because pipelines are resilient and observable. Over time, the organization becomes more adaptive. New models can be deployed faster because the groundwork is already in place. Business units trust outputs because they understand how they were produced.

The engine finally has a road network in place to support it.

In the end, enterprise AI viability is less about breakthrough algorithms and more about disciplined engineering. The invisible work, the pipelines, the governance, the architecture, is what turns experimentation into sustained value.

Without strong roads, the engine goes nowhere. With them, enterprise AI becomes not just possible, but durable.

About the Author: Aniket Abhishek Soni is a senior data engineer and researcher with more than seven years of experience designing and leading large-scale data pipelines, cloud platforms, and AI-enabled solutions across highly regulated industries, including asset management, healthcare, financial services, and climate research. His work focuses on making enterprise data systems more reliable, governable, and performant to support advanced analytics and applied artificial intelligence in real-world environments.

Aniket Abhishek Soni is a Senior Data Engineer at a leading IT services and consulting company

The Latest

Two years ago, almost every customer conversation about AI started with the same questions: Which model should we use? What can it do? Is it ready for the enterprise? Today, those discussions have moved on. CIOs are far more interested in how to govern AI, integrate it with existing systems, prepare their workforce and make it part of everyday operations. The challenge is no longer to prove that AI can deliver value. It's instead about how to embed AI into the business in a way that's secure, scalable and delivers measurable outcomes ...

 

Two things happened to production incidents between 2023 and now, and they did not happen at the same speed. The first is that a class of dependency that barely existed three years ago now accounts for one incident in ten. Incidents disclosed by AI model and AI application providers rose from 1.7% of all disclosed unplanned incidents in 2023 to 10.7% in 2026 year to date, roughly a sixfold rise; that counts only incidents at AI companies themselves, so the true share is higher. The second is that the time to close an incident has not come down ...

When an AI assistant gives an incomplete or incorrect answer, teams often blame the model. They adjust prompts, switch models, increase context windows or test a new retrieval strategy. However the model may not be a problem. In many enterprise AI workflows, the problem begins inside the document-ingestion pipeline ...

If you talk to any security or observability teams right now, they're all fighting the same fire: their tooling was built to ingest X, but their sources are pumping Y and soon to be doing Z. The knee-jerk reaction is always the same: we need more platform. However, this reaction is wrong. Let me explain why, because the solution to this problem is foundational, not financial. Instead of hurling yet more money at the problem, make sure you've done what's needed upstream ...

Rapid AI adoption and the unique ways AI workloads operate is redefining the scope and structure of what these teams must deliver. This shift is forcing organizations to rethink how they manage scale, automation, and control, according to The State of SRE and Platform Engineering 2026, a new report from Dynatrace ...

AI is usually talked about as a software tool, but it also depends heavily on the network behind it. Whether a company is using AI for chatbots, automation, monitoring, analytics, or employee support, all of that information has to move across the network in a reliable and secure way. That means AI is not just an application decision. It is also an infrastructure decision. Before organizations rush into AI, they should ask a simple question: Is our network ready to support it? ...

Enterprise AI often lacks governed access to where business processes actually execute. Without that access, AI agents may be able to reason, but they cannot operate reliably across enterprise workflows. For AI agents to effectively carry out workflows, they will require integration-layer context and controls. Organizations can implement these prerequisites by providing AI with managed access to the middleware layer ...

Enterprise networks rarely behave the same way for very long. A routing adjustment in one region may unexpectedly alter application performance in another. A cloud migration may introduce hidden dependencies that go unnoticed until an outage occurs. All the while, the network is managed by several different teams, each of whom use different tool sets — and as a result, have different views of the network ... There’s usually an engineer who remembers why traffic fails over a certain way between sites, or which transparent firewall was added where. The problem is that human memory cannot scale alongside enterprise-scale networks ...

Ask an infrastructure team how confident they are in their ability to govern AI, and most will tell you they've got it handled. A recent survey of 406 IT decision-makers and platform engineering leaders found 86% expressing exactly that confidence. Ask the same group whether they have a formal written AI governance policy, and the number drops to 30%, according to Spacelift's Infrastructure Automation Report ...

In MEAN TIME TO INSIGHT Episode 27, Shamus McGillicuddy, EMA VP of Research, Network Infrastructure and Operations, and Parker Hathcock, EMA Research Director covering IT Service/Operations (ServiceOps), discuss observability unification in modern IT operations ...