The Challenge
A digital lending platform needed to move from overnight batch processing to real-time analytics while maintaining complete audit trails for regulatory compliance.
Our Solution
We architected an event-sourced system using a modern data stack, enabling instant insights with perfect historical reconstruction.
Architecture. Implemented an immutable event log in ClickHouse capable of handling over 100,000 events per hour.
Transformation. Built 150+ dbt models with incremental processing to handle late-arriving events.
Analytics. Developed self-service analytics in Metabase with sub-second query performance.
Auditability. Enabled point-in-time reconstruction of any historical state for regulatory reviews.
Impact
The platform moved from a 24-hour reporting lag to real-time visibility into operations — average decision-making time fell by 60%, every event was captured with zero data loss, and the immutable log gave the team the ability to reconstruct any historical state on demand for regulators.