At a glance
- Client
- An investment management firmName withheld for confidentiality
- Industry
- Banking
- Service
- Data & Analytics
- Scope
- Risk data platform, calculation engine and dashboards
The challenge
Risk data for equities, fixed income and derivatives lived in separate systems. Analysts built Value at Risk reports overnight in spreadsheets, so risk managers always looked at yesterday's positions.
During volatile markets, the firm could not see its combined exposure when it mattered most.
Our approach
Model risk data once
Positions, market data and reference data were brought into one consistent model.
Stream changes
Trades and market moves flow into the platform as they happen.
Calculate continuously
A scalable engine recalculates VaR and exposures across all asset classes.
Show it clearly
Dashboards let risk managers drill from firm level down to individual positions.
The solution
Risk managers now see firm-wide exposure and Value at Risk updated throughout the day, across every asset class, from one trusted source.
The overnight spreadsheet process has been retired, and the same data feeds regulatory reporting.
Results
- One source of truth for positions and market data
- Intraday risk instead of overnight reports
- Drill-down from firm level to single positions
- Spreadsheet-based risk reporting retired
Technology used
- Kafka
- Apache Spark
- Python
- Cloud data warehouse
- Risk dashboards
Facing a similar challenge?
Tell us what you are working on. We will walk you through how we would approach it, with no obligation.

