Chris-Jay Mabalot
Profile
Finance analytics team lead who builds with AI. Aerospace engineering graduate, trained as a software and data engineer. I lead the Finance Analytics function at SquareTrade Europe, building the analytics engineering behind insurance and finance reporting across tens of millions of policies. In my own time I build LLM tools with evals, guardrails and cost limits. Looking for an AI engineering role.
Experience
- Lead the Finance Analytics function: manage one analyst, co-manage an offshore team, and run the monthly meeting with Financial Control.
- Delivered reporting for the move to becoming an insurer, including premium and claims reserves and data quality checks, validated with Financial Control.
- Own monthly reporting to insurers (claims, insurance premium tax) and to UK and EU regulators.
- Rebuilt the core policy data model in dbt, covering tens of millions of policies, so past months stay fixed and expired policies are handled correctly.
- Designed month-end reconciliation and exception reporting that improved inventory accuracy by over 10 percentage points.
- Automated 10+ reports, saving over 24 hours of manual work each reporting cycle; built AI-assisted validation workflows with GitHub Copilot.
- Built the internal app that produces our monthly insurer reports. Wrote the requirements for rebuilding it as modular, tested code, and am carrying out the rebuild with coding agents to make it more robust and more efficient.
- Led a data migration from legacy systems to a consolidated database model, with a weekly incremental ETL that made Tableau dashboards more efficient.
- Kept product financials accurate through a company-wide product consolidation.
- Built weekly performance reporting for a top-5 European account in SQL and Python.
- Built an NLP model to classify insurance claims, reaching 80% accuracy.
- Graduate software and data engineering programme at a B Corp training academy, starting as a trainee; then placed at SquareTrade Europe as a data analyst.
Selected projects
Skills
AI: Claude API, Claude Code, Codex, GitHub Copilot, MCP, evals and LLM judges, NLP, prompt design, cost control.
Engineering: Python, FastAPI, TypeScript, Deno, PostgreSQL, Supabase, Docker, Fly.io, test-driven development.
Data: SQL, dbt, Pandas, Tableau, data modelling, data quality, reporting pipelines, team leadership.