Data Lineage Is a Practical AI Bottleneck
Published
6 minNobody gets excited talking about data lineage. It’s the least glamorous phrase in finance transformation, right up there with “master data governance,” and it’s usually the thing that gets deprioritized in favor of the part everyone actually wants to talk about—which model, which agent, which vendor.
One recurring risk in AI-enabled finance is unclear metric provenance: nobody can answer, with confidence, “where does this number come from, and does it mean the same thing in the system the AI reads as it does in the report a human signs off on?”
What this looks like in practice
Hypothetical: A natural-language BI tool is asked for revenue by region. It returns a polished answer, but “region” is defined differently in the sales system and the finance consolidation. The question is ambiguous, and the tool has no reason to know the definitions differ.
This happens constantly, and it’s almost never framed as a data lineage problem in the postmortem—it gets framed as “the AI got it wrong,” which lets the actual root cause quietly survive to cause the next incident.
Why this is worse with AI than it was before
Before, if a report used the wrong region definition, it usually showed up somewhere obviously wrong—a total that didn’t tie, a chart that looked off. Slow, manual processes had friction built in that occasionally caught these mismatches by accident. A fluent AI-generated answer doesn’t have that friction. It reads exactly as confident and clean whether the underlying definition was right or wrong, which means the errors that used to get caught by process friction now sail through, dressed in better prose than the mistake deserves.
The unglamorous fix, which is the only fix
There isn’t a shortcut here. The organizations that get real value from AI tooling on top of their data are the ones that did the boring work first: a documented, current data dictionary for the metrics that actually get used in decisions, an explicit mapping of where each metric is defined and whether the definitions agree across systems, and an owner for each metric who’s accountable when it drifts.
If I had to pick one thing to fix before spending another dollar on an AI tool layered on top of your data, it’s this. Not because it’s exciting—it’s the opposite of exciting—but because every downstream tool, whether it’s a natural-language BI layer, an anomaly detector, or an agent drafting commentary, inherits whatever ambiguity already exists in your metric definitions, and makes that ambiguity sound more confident than it deserves to.
AI tools are easier to evaluate when metric definitions, source mappings, and ownership are already documented. When that foundation is missing, the first work is data stewardship, not model selection.
Author-reviewed. AI tools may have assisted with outlining or line edits; thesis, conclusions, and factual claims were checked by the author before publication. Colophon
Tie-Out
Occasional notes on controls, economics, and judgment in corporate finance. No fixed cadence.
By subscribing, you agree to receive email updates. Unsubscribe at any time.
~Pedro Alizo