Reliable high-stakes pipeline architecture
The resultRisk & portfolio data
OMERS: Risk and portfolio data infrastructure
One of Canada's largest pension funds needed reliable financial data flowing from Bloomberg, MSCI, and SQL systems into a unified data warehouse that risk and portfolio teams could actually trust.
I built and maintained the ETL pipelines handling that data flow, created a Streamlit dashboard giving portfolio managers live visibility into risk data, and led a full migration of the orchestration layer from Apache Airflow to Prefect, all without disrupting daily operations.
The result: A pipeline architecture that has run reliably handling high-stakes financial data, with full visibility built in for the teams who depend on it.
- Python
- PostgreSQL
- Bloomberg
- Prefect
- Streamlit