I build Python, Django, SQL, and dbt analytics tools that transform raw
operational data into reliable, decision-ready outputs — KPI dashboards, BI-ready exports,
tested dbt models, and data-quality-checked reporting across FX and FinTech domains.
15 years UK operational experience. Full work authorisation. Available immediately.
The same five-stage architecture across every project. Source inspection first, clean SQL transformation, tested dbt models, curated marts, decision-ready exports — the pattern a production analytics team would recognise.
01Source
Raw Data
CSV Exports
APIs · Files · Logs
02Transform
Staging (SQL)
Clean & Standardise
Validate & Type
03Model
dbt Transform
Business Logic
Test & Document
04Curate
Mart Layer
Trusted · Consistent
Analytics Ready
05Deliver
Dashboards
Business Insight
BI-ready Exports
Every project is public, tested, and claim-safe — no overclaiming, no fake features. Each can be cloned and run by any reviewer.
dbt + DuckDB analytics engineering project transforming BakeOps Intelligence CSV exports into tested product-performance marts. Preserves the BakeOps signature insight across three implementations: Django → SQL evidence layer → dbt mart.
| Staging | stg_ordersstg_order_itemsstg_snapshot |
| Intermediate | int_product_revenueint_product_margins |
| Mart | mart_product_performancemart_rank_inversion |
| Tests | 26 passing · PASS=33 WARN=0 ERROR=0 |
| Release | v1.0.1 · local DuckDB · no cloud |
Signature insight
Birthday Classic is revenue rank #1, but drops to margin rank #4 after waste-adjusted margin — a rank inversion that challenges revenue-only product decisions.
Django analytics platform with KPI dashboards, gold-layer metric snapshots, and reviewer-verifiable BI exports.
Career intelligence and application-tracking platform with funnel metrics and document workflows.
Multi-source market data ingestion with ETL workflows and a read-only API layer.
Post-trade analytics with a 17-metric KPI engine and configurable Excel and PDF exports.
Market monitoring with severity-ranked signals, watchlists, and threshold alerts.
Pre-trade risk planning with Monte Carlo simulation and capital-preservation decision support.
Analytics Engineering
Data Processing
Backend & APIs
Reporting & BI
Delivery
Domain
Before the portfolio transition I worked across FX operations, money transfer, and software platform support — building an in-house multi-currency reconciliation system, producing monthly stakeholder KPI reports, and acting as the technical bridge between non-technical users and development teams.
That operational knowledge shapes every analytics project I build. When I model FX data or define a KPI, I understand what it means in practice — not just what the column contains.