Keep the source attached.
A derived value should retain the snapshots, computation version and publication event that made it true. Fast current state sits on top of durable evidence—not instead of it.
source → evidence → computation → currentAI data engineering / Finland
I design and operate AI-ready data foundations where every value keeps its source, time and trust state—from ingestion and validation to models and production decisions.
Latest source-backed counts.
Each figure has its own system scope.
01 Operating principles
The work is not complete when a table exists. It is complete when the data has a defined meaning, a valid time, a visible trust state and a recoverable operating path.
A derived value should retain the snapshots, computation version and publication event that made it true. Fast current state sits on top of durable evidence—not instead of it.
source → evidence → computation → currentTraining and evaluation only use information available at the decision point. Point-in-time gates, walk-forward splits and replayable snapshots turn leakage from a promise into a test.
observed_at ≤ decision_atComparable sources that disagree are not silently reconciled. The evidence stays visible, the derived value leaves decision paths, and an explicit review restores or rejects it.
retain evidence · mask influence · reviewFreshness, missingness, retry exhaustion and structural absence need different states. An SLO must describe what the pipeline is doing—not become greener by excluding hard rows.
fresh · late · exhausted · unresolved02 Selected data systems
Three systems that treat evidence, timing and refusal as product capabilities—not implementation details hidden below the interface.
01 Operational intelligence
A private analytical system built around a deliberate split: a fast current projection for operators, with append-only event, snapshot and computation history underneath it. Conflicting comparable evidence is quarantined rather than silently overwritten.
A rebuildable football data and modelling platform. Raw API responses are retained before parsing; evaluation is point-in-time and walk-forward; a cutoff validator removes future matches, refits, and requires identical historical ratings.
A real-time measurement system that timestamps complete frames at the socket boundary on one monotonic clock and pairs only exact one-to-one state transitions. Ambiguity is classified, never patched with a convenient heuristic.
03 Delivery method
The same sequence works whether the destination is a dashboard, a forecast, an AI assistant or a model-training set. The output changes; the trust obligations do not.
Start with the decision, user and acceptable delay. Technology follows the consequence of being wrong or late.
decision / owner / latencyFix the grain, identifiers, timestamps, allowed states and source of truth before building a transformation.
grain / keys / semanticsStore original responses and load metadata so parser fixes, backfills and audits are reproducible rather than hand-patched.
source / loaded_at / versionValidate freshness, completeness, uniqueness, reconciliation and point-in-time correctness before data reaches a model or decision surface.
tests / quarantine / publishUse walk-forward evaluation, uncertainty estimates and shadow operation before automating a consequential decision.
as-of / replay / shadowTreat retries, backfills, ownership, lineage and reason-coded SLOs as product behavior—not post-launch cleanup.
observe / explain / recover04 Tooling
Tools are selected around data grain, recovery needs and operational consequence—not around a fixed platform diagram.
Production services and data paths
Reproducible analysis and quality gates
Source collection, durable history and replay
Faster delivery with evidence and review
REBUILD WITHOUT GUESSWORK
05 Engineering boundaries
I use AI to shorten implementation and review loops. The production boundary remains unchanged: people own semantics, publication rules, security and release consequences.
06 Contact
Let's design the source trail, validation gates and operating record before the model becomes the most convincing part of the system.
Start a conversation