Data science, systems engineering and applied research.

Christian Camille

A data and systems engineer with a passion for gaining a better understanding of the world through data. With a background in cybersecurity, I specialise in designing and implementing end-to-end data solutions that drive informed decision-making. My work spans across various domains, including public policy, geospatial intelligence, and financial data analysis.

Selected work

Highlighted Projects

  1. 01

    United Kingdom Policy Tracker

    UK Policy Tracker is a full-stack data product that links GOV.UK publications to parliamentary activity so a policy topic can be tracked in one place. It ingests raw source data from multiple public APIs, normalises it into a relational model, enriches it with NLP-based entity matching, and projects the result into a graph layer for exploration.

  2. 02

    Leeds Crime Intelligence Platform

    A comprehensive geospatial intelligence platform for the Leeds metropolitan area. This project combines a robust ETL pipeline with an interactive web dashboard to visualise over 1,000,000 crime records spanning 2017–2025. You can explore the data interactively on the Live Dashboard. It integrates data from the UK Police API, Leeds City Council, and ONS, providing hyper-local insights through heatmaps, ward-level choropleths, postcode-radius search, and a dedicated analytics workspace for trend and seasonality analysis.

  3. 03

    Cryptocurrency Market Data Warehouse

    An ELT pipeline to ingest high-frequency cryptocurrency trade data into a PostgreSQL data warehouse. This project dumps raw JSON data from the CoinGecko API into a staging table in PostgreSQL. It then uses SQL Stored Procedures to parse, clean, and transform this data into a Star Schema (Fact and Dimension tables) for analysis.