Data pipelineIn progress
Accounting data, near real time
Accounting changes reach a PostgreSQL warehouse within a minute. The reporting model is versioned in Git and shared by every client, each seeing only their companies.
- Role
- Architecture and lead
- Client
- Accounting firm, Paris
- Year
- 2026
- from source to warehouse
- ≤ 1 min
- companies in the pilot group
- 73
- ledger lines
- 2.1M
Context
Reports were refreshed from files synced through an office PC with a slow connection.
What I built
- 01Incremental sync from the accounting API's change logs
- 02One versioned Power BI model with per-client security
- 03Targeted refresh of only the months that changed
Key decisions
Measure before choosing
Real data showed 7% of corrections land on months older than the last two, so a simple rolling refresh would have silently missed them.
Outcome
In rollout, one client group first.