Data engineering for AI: Why your AI project needs a data foundation first

By Henry LyUpdated:
  • AI Development
  • Healthcare
Data engineering for AI: Why your AI project needs a data foundation first

AI projects often start with the same question: Which model should we use? But the model is rarely the first thing you need to solve. Behind every reliable AI system is a data foundation that makes data available, clean, structured, and usable. As AI applications become more data-intensive, fragmented data, poor data quality, and disconnected systems can quickly become bottlenecks. This is where data engineering for AI comes in. 

In Singapore, AI development is focused on building AI solutions powered by large volumes of data. Also, the AI innovation team has grown from just a few staff into a strong network of engineering teams. This guide is written for data professionals, AI engineers, and technical teams looking to build reliable data foundations for AI projects. We’ll explore why AI needs a strong data foundation, what an AI-ready data architecture looks like, and how to prepare data for AI.  

Key takeaways 

  • AI starts with data, not the model. A strong data foundation makes data reliable, accessible, governed, and ready for AI. Gartner (2025) predicted that organizations will abandon 60% of AI projects through 2026 if they are not supported by AI-ready data. 

  • In Singapore, AI development is focused on building AI solutions powered by large volumes of data. 

  • Not every AI project needs a complex data engineering setup from day one. A simple dataset, API, or manually curated data may be enough for an initial PoC.  

  • Raw data is data collected directly from source systems, while AI-ready data is data prepared for a specific AI purpose. 

  • 25% of organizations identified data complexity as one of the key barriers to AI deployment, while 43% of chief operations officers identified data quality issues as their most significant data priority.  

  • In Singapore, GovTech introduced AIDE (AI for Data Engineering) in 2026, a framework that uses AI to support the development of data pipelines. 

AI projects failed because of data, not the model  

When an AI project underperforms, the first instinct is often to question the model. But in many cases, data is the bigger problem. A better AI model cannot compensate for bad data. A model can only perform as well as the data it receives, whether that data is used for training, retrieval, fine-tuning, or real-time inference. When data is fragmented, contains missing or inconsistent values, lacks context, or cannot be accessed reliably, the model has a weak foundation to learn from. 

Gartner (2025) found that 63% of organizations either do not have or are unsure whether they have the right data management practices for AI. Gartner also predicts that through 2026, organizations will abandon 60% of AI projects that are not supported by AI-ready data. The same pattern appears in GenAI adoption. Deloitte (2024) reported that 55% of surveyed organizations had avoided certain GenAI use cases because of data-related issues, while 75% had increased their investment in data management because of GenAI. Organizations were also investing in data quality, security, and governance to address these gaps. 

The takeaway is simple: AI projects do not just need a better model. They need better data foundations. Without reliable, accessible, governed, and AI-ready data, even a powerful model can struggle to deliver consistent results in production. 

Understanding Data Engineering for AI  

What is data engineering?  

Data engineering is the practice of designing, building, and maintaining the systems that collect, process, transform, store, and deliver data for business and technical use. In an AI project, data engineering turns raw and fragmented data into reliable, accessible, and AI-ready data. 

Why is data engineering important for AI initiatives  

Data engineering provides the foundation between raw data and AI systems. It brings data from different sources together, cleans and transforms it, validates data quality, and makes it accessible in the format AI systems need. 

Key responsibilities include:  

  • Improve AI accuracy: Clean, consistent, and high-quality data gives AI models a more reliable foundation for generating accurate outputs.  

  • Break down data silos: Data engineering connects data from databases, applications, APIs, documents, and other sources, giving AI access to a more complete context.  

  • Scale AI workloads: Automated pipelines make it easier to process growing volumes of data without relying on manual data preparation.  

  • Keep data fresh and reliable: Data pipelines can continuously ingest, transform, validate, and update data so AI systems work with relevant information.  

  • Support security and governance: Data engineering helps implement access controls, data lineage, privacy, and other governance requirements for sensitive data.  

  • Move AI from PoC to production: Reliable pipelines, monitoring, and scalable infrastructure provide the foundation needed to operate AI systems consistently in production. 

When an AI project needs data engineering 

Not every AI project needs a complex data engineering setup from day one. A small proof of concept may work with a simple dataset, API, or manually curated data. 

Data engineering becomes more important when an AI project needs to combine multiple data sources, process large or frequently changing datasets, maintain data quality, or handle sensitive information. It also becomes critical when moving from a PoC to production, where reliability, scalability, monitoring, and governance are required. 

In simple terms, the more an AI system depends on large, diverse, dynamic, or business-critical data, the more important its data engineering foundation becomes. 

What data engineering includes  

Ingestion  

Data ingestion is the first step, bringing data from different sources into the data environment. These sources can include databases, APIs, business applications, cloud services, logs, documents, or external datasets. Depending on the use case, data can be ingested in batches or continuously through real-time/streaming pipelines. 

Pipeline  

Pipelines define how data moves and changes from its source to where it will be used. They automate tasks such as extraction, cleaning, transformation, enrichment, and loading. For AI, well-designed pipelines help ensure that training, retrieval, or inference data is delivered consistently and updated when needed. 

Warehouse/ Lakehouse  

Once ingested, data needs a scalable place to be stored and accessed. A data warehouse is typically designed for structured, processed data and analytics, while a data lake can store large volumes of structured and unstructured data. A data lakehouse combines capabilities from both, providing a unified architecture that can support analytics and AI workloads. 

Quality  

AI needs data that is accurate, complete, consistent, relevant, and fresh. Data engineering therefore includes validation and quality checks to detect missing values, duplicates, inconsistencies, outdated records, or unexpected changes in data. This is particularly important for AI because poor-quality input data can directly affect model outputs. 

Governance 

AI systems often work with sensitive, proprietary, or regulated data. Data governance defines who can access data, how it can be used, where it is stored, and how it is tracked throughout its lifecycle. It can include access controls, data lineage, metadata management, privacy, retention, and compliance requirements. 

Data readiness assessment  

Before building data pipelines or choosing an AI architecture, teams need to understand the current state of their data and identify the gaps that could affect the AI project. A data readiness assessment provides this baseline by looking at where data comes from, how reliable and accessible it is, and whether it is suitable for the intended AI use case. 

Data availability & coverage 

Start by mapping all data sources relevant to the AI use case, including databases, APIs, applications, documents, and external datasets. Check whether the required data exists, how much historical data is available, and whether it covers the key users, scenarios, and time periods. For example, a customer-support AI may need to assess whether it has enough historical conversations across different customer issues, rather than simply counting how many documents are available. 

Data cleaning & quality  

Sample the actual datasets and measure common quality issues such as missing values, duplicate records, inconsistent formats, invalid values, outdated records, and anomalies. Define quality thresholds based on the use case, for example, how complete customer records need to be or how fresh transaction data must be before it can be used by an AI system. This turns “data quality” from a general requirement into measurable criteria. 

Data accessibility & integration 

Map where each required dataset lives and how it can be accessed. Check whether data is available through APIs, database connections, files, or other interfaces, and whether different sources can be connected using common identifiers. If customer information sits in a CRM while transaction data sits in an ERP with no consistent customer ID, the integration gap needs to be addressed before the AI system can build a complete view. 

Data structure & AI compatibility 

Examine whether the existing data format matches the selected AI approach. For ML, this may mean checking whether there are usable features and sufficient historical records. For RAG, assess whether documents are machine-readable, well-structured, and suitable for chunking and retrieval. For AI agents, check whether the required business data and APIs can provide structured, real-time information. 

Data labeling & metadata 

For Machine Learning projects, assess whether enough data is correctly labeled and whether labels are consistent across the dataset. For RAG and other GenAI applications, evaluate whether documents have useful metadata such as source, date, document type, topic, access permissions, and version. Missing or inconsistent metadata can make it harder to filter, retrieve, and govern data effectively. 

AI-ready data checklist  

Raw data vs. AI-ready data  

Raw data is data collected directly from source systems before it has been properly processed for an AI use case, while AI-ready data is data prepared for a specific AI purpose. 

Raw data comes from databases, APIs, applications, documents, logs, or external datasets. At this stage, data may contain duplicates, missing values, inconsistent formats, outdated information, or irrelevant records. AI-ready data goes a step further. It has been cleaned, transformed, validated, structured, and enriched based on what the AI system needs. 

What should the data look like before AI uses it?  

Once the data gaps are identified, the next step is to determine whether the data meets the requirements for the intended AI workload. IBM reported that 25% of organizations identified data complexity as one of the key barriers to successful AI deployment. Also, 43% of chief operations officers identify data quality issues as their most significant data priority, highlighting the importance of AI-ready data.  

AI-ready data should not simply be “clean”; it should be fit for purpose. 

Valid & reliable 

Data should follow defined rules, come from trustworthy sources, and remain consistent enough to support reliable AI outputs. Invalid records, corrupted values, or unreliable sources can introduce errors into the AI system. 

Representative 

Data should reflect the population, scenarios, and conditions that the AI system is expected to work with. If the dataset does not adequately represent the target use case, AI outputs may not perform reliably across different users or situations. 

Accurate & complete 

Data should accurately reflect the underlying information and contain enough relevant records to support the AI task. Teams should identify issues such as incorrect values, missing fields, duplicates, and incomplete records before the data reaches the AI system. 

Secure & governed 

Data should have appropriate access controls and governance policies, particularly when it contains personal, confidential, or business-critical information. Teams should define who can access, modify, and use the data and how it should be protected throughout its lifecycle. 

Traceable & documented 

Teams should be able to understand where data comes from, how it has been processed, which version is being used, and how it is being used by the AI system. Clear metadata, documentation, and data lineage make the data easier to manage, audit, and troubleshoot. 

Preparing data for AI 

Data collection 

The first step is data collection for AI training. Identify the data required for the AI use case and where it currently exists. Data may come from transactional databases, CRM or ERP systems, APIs, applications, logs, cloud storage, documents, or external sources. Teams then establish ingestion mechanisms to bring this data into the data environment. Batch ingestion may be sufficient for periodically updated datasets, while streaming or event-driven ingestion may be required for the use cases that depend on real-time data. 

Data cleaning & preprocessing  

After the data collection for AI training, the next step is to clean and process the data to remove errors, inconsistencies, duplicates, and irrelevant information. Raw data often contains missing values, duplicate records, incorrect values, inconsistent naming conventions, or outdated information. These issues need to be identified and handled before the data is used by AI. For unstructured data, preprocessing can also involve extracting text from PDFs, converting files into machine-readable formats, removing unnecessary content, or standardizing documents. The objective is to reduce noise without removing information that is important to the AI use case. 

For machine learning, this may involve cleaning and labeling an AI training dataset, handling missing values, removing duplicates, and standardizing data formats before training. 

Data transformation and integration  

Data from different systems rarely follows the same schema or format. One system may identify a customer by an email address while another uses a customer ID. Data engineering pipelines transform fields, standardize formats, map identifiers, and combine related datasets into a consistent structure. This integration allows an AI system to work with a more complete view of the underlying business data rather than isolated sources. 

Data integration brings data from different systems into a consistent structure that AI applications can use. For example, in healthcare, EMR/EHR integration is a common data engineering challenge because patient information is often distributed across multiple systems, such as electronic health records, laboratory systems, pharmacy platforms, and medical imaging systems. 

Data enrichment and contextualization  

Clean data may still lack the context AI needs to interpret it correctly. Teams can enrich datasets with metadata, labels, business rules, classifications, or information from additional sources. For example, a RAG system may need documents to be split into meaningful chunks and enriched with metadata such as document type, source, date, version, and access permissions. This additional context helps the AI system retrieve and interpret information more effectively. 

Data validation and quality checks  

Data quality should be checked throughout the pipeline rather than only before the initial AI deployment. Automated validation can check for missing fields, duplicate records, schema changes, unexpected data volumes, invalid values, and data freshness. Quality thresholds can also be defined for different datasets so that problematic data is detected before it reaches training, retrieval, or inference workflows. 

Data security and governance  

AI projects may process personal, confidential, or business-critical information, making governance part of the data preparation process. Teams need to identify sensitive data, apply appropriate access controls, mask or remove information when necessary, and maintain data lineage. Governance policies should also define how data can be accessed, used, retained, and audited throughout its lifecycle. 

Data serving  

Once data has been prepared and validated, it needs to be delivered to the AI workload in a usable form. Structured data may be served through a warehouse, lakehouse, or feature store, while unstructured knowledge for RAG may be indexed in a vector database or search system. AI agents may require APIs or real-time pipelines to access operational data. The serving layer therefore depends on how the AI system consumes data and how frequently that data needs to be updated. 

Tools, frameworks, and platforms for Data Engineering 

A typical AI data engineering stack combines technologies for data ingestion, processing, storage, orchestration, and AI data serving. For example, Kafka is widely used for real-time data ingestion, while Apache Spark supports large-scale data processing. dbt is commonly used for data transformation, and Airflow helps orchestrate and schedule data pipelines. For storage and analytics, platforms such as Databricks, Snowflake, and Google BigQuery provide scalable data warehouse or lakehouse capabilities. AI applications may then use vector databases, search engines, or APIs to access AI-ready data, depending on the use case. The right stack depends on the AI workload, but the goal remains the same: move data reliably from raw sources to clean, governed, and usable data for AI systems.  

In Singapore, GovTech introduced AIDE (AI for Data Engineering) in 2026, a framework that uses AI to support the development of data pipelines. Rather than handling requirements to data engineers to build manually, data users can work with an AI assistant throughout the pipeline development process. The AI can translate business requirements into a data contract, generate automated tests to validate the defined rules, and then create the corresponding data pipeline. The pipeline is tested against these requirements and refined when issues are detected. Data engineers remain involved as reviewers, validating the generated pipeline and test results before the solution is approved for production use. 

Compliance considerations when preparing data for AI in Singapore  

Singapore has been building a trusted environment for AI adoption, with data protection and responsible AI practices becoming important considerations for organizations developing and deploying AI systems. As AI applications increasingly rely on personal, business, and cross-border data, compliance needs to be considered from the data preparation stage, not only after the AI system is built. 

For teams building AI solutions in Singapore while processing data through engineering teams or infrastructure in other countries, two areas require particular attention: how data is collected and stored under the PDPA, and where data is transferred and processed across borders. 

AI Governance framework 

Singapore's Model AI Governance Framework, released by the Personal Data Protection Commission (PDPC) in 2020, provided practical guidance for organizations developing and deploying AI responsibly. It covers areas that are closely connected to data engineering, including accountability, data management and protection, transparency, and risk management. 

For data engineering teams, this means governance should be considered throughout the data lifecycle. Teams need to understand where data comes from, how it is processed and accessed, what controls are applied, and how data quality and security are maintained before it is used by an AI system. 

PDPA: Collect and store data responsibly 

When AI systems use personal data, organizations need to consider their obligations under the Personal Data Protection Act (PDPA). This includes how personal data is collected, used, disclosed, protected, retained, and managed throughout its lifecycle. 

For data engineering, this can translate into practical measures such as maintaining data inventories and data-flow maps, applying appropriate access controls, limiting data retention, and using anonymization or de-identification where appropriate. The PDPC also provides tools and guidance to help organizations assess their data protection practices. 

Data residency: Managing cross-border data processing 

Data residency becomes particularly relevant when a Singapore-based AI project uses data engineering teams, cloud infrastructure, or processing environments outside Singapore, such as Vietnam. The PDPA does not generally require all personal data to remain physically in Singapore. Instead, organizations transferring personal data overseas must take appropriate steps to ensure that the recipient provides a level of protection comparable to that required under the PDPA. This can be addressed through legally enforceable obligations such as contracts, binding corporate rules, or recognized certifications. 

For an AI data pipeline, teams should therefore map where data is collected, stored, processed, and accessed, identify whether personal data crosses borders, and establish the appropriate contractual and technical safeguards before transferring it to an overseas engineering or cloud environment. 

Final thoughts  

AI projects do not start with the model. They start with the data foundation behind it. Data engineering determines whether data is reliable and usable enough to support AI in production. Singapore's growing AI adoption also highlights the broader need for strong AI development. According to IMDA (2025), AI adoption among SMEs in Singapore more than tripled from 4.2% in 2023 to 14.5% in 2024, while adoption among non-SMEs increased from 44% to 62.5%.  

For businesses planning their next AI initiative, the next step is not necessarily choosing a more advanced model. Start by assessing your current data: What data do you have? Where does it live? Is it reliable, accessible, secure, and fit for the AI use case? From there, define the right data architecture, build the required pipelines, and introduce quality and governance controls before scaling the AI application. 

Looking for a trusted AI development company for data engineering   

Adamo Asia Pacific (Adamo APAC) is the Singapore office of Adamo Software, delivering custom AI solutions for mid-market and enterprise companies across APAC. Our approach combines AI development with secure, production-ready engineering, with each AI and data project incorporating secure development practices, PDPA-aligned data handling, and full IP transfer from day one. 

In healthcare, data engineering can turn operational data into real-time insights that support faster decisions, better resource allocation, and more efficient service delivery. My Emergency Doctor is a healthcare solution where we built an automated data pipeline to support end-to-end healthcare work, from consultation intake to outcome. The pipeline processes consultation data for SLA tracking, response-time dashboards, and billing-ready reports for hospitals and B2B healthcare clients, while also providing operational insights for workforce planning and doctor allocation. 

FAQs  

01. Does every AI project need data engineering? 

Not every AI project needs a complex data engineering setup from day one. A small proof of concept may work with an existing dataset, API, or manually prepared data. However, data engineering becomes increasingly important when a project needs to integrate multiple data sources, process large or frequently changing datasets, maintain data quality and security, or scale from a PoC to production. 

02. How do you ensure data security and compliance for AI? 

Our AI development practices are aligned with IMDA’s key AI governance principles. Depending on the project, we document model decisions, perform bias and risk assessments, implement human-in-the-loop controls, and maintain clear data lineage throughout the AI lifecycle. For projects involving autonomous AI agents, we also take into account Singapore’s Agentic AI Governance Framework.  

Also, we hold ISO 27001 and ISO 9001:2015 certifications, with IP and source code transfer to the client from day one.  

03. How do you scale a data pipeline from an AI PoC to production? 

First, we assess the PoC’s data flow, quality, and infrastructure to identify production gaps. We then automate ingestion and transformation, introduce data quality checks, monitoring, security, and governance, and scale the infrastructure based on data volume and workload requirements. This approach allows us to move from a working PoC to a reliable, production-ready data pipeline without introducing unnecessary complexity. 

Share:
Author

About Our Author

Henry Ly

Henry Ly

Head of Digital Transformation, CTO

Henry Ly is Head of Digital Transformation and CTO at Adamo Software (Vietnam development centre of Adamo APAC). He leads the effort to design robust cloud architectures, standardize DevOps pipelines, and guide digital transformation initiatives to ensure scalability, reliability, and operational efficiency across projects.

With a solid background spanning Linux, networking, AWS, automation pipelines, programming languages, databases, and containerization, Henry is committed to driving innovation and delivering world-class digital solutions at Adamo APAC.


Related Articles

View All