Career & Experience
7 years turning messy financial data into reliable, queryable systems — from fixed income databases at Bloomberg to pension analytics at Mercer. I architect things from scratch, ship pipelines that don't wake people up at night, and break things on purpose in a homelab so I don't break them at work.
7+
Years in data
325k+
Bloomberg users
0→1
Infra builds
5
Certifications
Work
-
Sep 2024 — Present
Data Engineer — Workplace Savings
Mercer Ltd · London
- Built the data infra from zero. Designed the Databricks architecture for the Workplace Savings division — Asset Bundles for deployment, self-hosted GitHub Actions runners for CI/CD. Nothing existed before.
- dbt pipelines the finance team trusts. Modelled and shipped analytics for the Head of DC Pensions and Finance groups — the kind of reports that go straight to leadership without a sanity check.
- Python CLI that replaced a mess of scripts. Wrote a comprehensive CLI application for data preprocessing — one command instead of six manual steps stitched together with hope.
- Investment tooling. Portfolio rebalancing monitor and fund performance tracker that gave the Investment team meaningful capacity back.
-
Aug 2021 — Aug 2024
Data Analyst — Workplace Savings
Mercer Ltd · London
- Automated the manual stuff. Python scripts replaced repetitive MI reporting processes — less copy-paste, more actual analysis.
- Sales Pipeline Tracker. Built and maintained the Power BI dashboard that the sales team actually uses — one of those that gets printed and put on walls.
- Data quality processes. Implemented controls to ensure accuracy and auditability of financial data — because in regulated finance, "probably right" isn't good enough.
-
Nov 2017 — Jul 2021
Data Management Analyst
Bloomberg LP · London
- Fixed Income database at scale. Managed the end-to-end data lifecycle for a securities database relied on by 325,000+ traders, analysts, and portfolio managers globally. It had to be right.
- Automated validation and reconciliation. Designed rules and processes to catch data quality issues before they propagated — global bond data, zero tolerance for drift.
Projects
-
Side project
Investor Reporting App
Streamlit · Python
- Financial data visualisation app built with Streamlit — fast to iterate, useful for exploring portfolio metrics without spinning up a BI tool.
-
Open source
Selene
GitHub · Python
- Open-source data project. Available on GitHub.
-
Ongoing
Home Lab
Ubuntu Server · Docker · Self-hosted
- Personal Ubuntu Server running self-hosted tooling, infrastructure experiments, and whatever new stack I'm currently breaking. Treated like production — because that's how you learn.
Certifications & Education
Financial Modelling & Valuation Analyst (FMVA)
CFI
Certificate in Discretionary Investment Management
CII
Investment Operation Certificate
CISI
Certificate in Business Accounting
CIMA
SQL for Business Analysts
DataCamp