A Facebook discussion about Malta’s receipt lottery made me want to look at the data. Were there repeat winners across different draws? How much had they won? And were the winning receipts for small everyday purchases, larger amounts, or a mixture?

First, I needed to bring the data together.

I built a scraper to collect the publicly available PDFs from the VAT site, then used OCR to extract their contents into CSV files. From there, I started exploring the data in Jupyter notebooks.

I’m also building a site to present the results, taking inspiration from The Pudding’s approach to visual storytelling. I want to make the analysis something people can follow and explore.

The scraper runs daily through GitHub Actions to check for new source documents.

Next up is finishing the checks and publishing the results on the site.

A Facebook debate sent me into Malta’s lottery data

What I've Built

Lakehouse Data Platform Rebuild

Elantil

Leading the ground-up rebuild of a B2B iGaming data platform — Kafka streaming into AWS Glue, Apache Iceberg tables, Athena, and dbt Bronze/Silver/Gold layers. Shifted decision-making from gut-feel to evidence-based, presented directly to C-level and key clients.

59.5% higher throughput vs original platform 10.4% faster execution vs original platform

Data Migration Framework

Gaming Innovation Group (GiG)

Designed and delivered a migration solution that enabled GiG to onboard large, established operators with existing customer bases. A representative run migrated 20,000+ customer records in under 30 minutes.

20,000+ records < 30 min migration
Read the case study → Referenced in GiG's Q1 2024 earnings call →

Broker CRM — Real-Time Pipeline

Gaming Innovation Group (GiG)

Built a real-time CRM data pipeline delivering live player events to platforms like Symplify, enabling multiple operator clients to trigger personalised actions based on real-time behaviour.

300k events/hour multiple operator clients
Read the case study →

6TB Data Warehouse Migration

SpinCity Solutions

Delivered analytical access to 6+ TB of historical data in under three months using S3 and self-hosted ClickHouse. Complex historical queries completed in under 20 minutes.

6+ TB migrated < 20 min query time
Read the case study →

Where I've Worked

Elantil

Leading the data platform rebuild · 2024–Present

Leading a lakehouse rebuild using open table formats, streaming ingestion, and transformations for analytical use.

SpinCity Solutions

Data Architect · 2024

Built a historical analytics platform with S3 and self-hosted ClickHouse, separating analytical workloads from production databases.

Gaming Innovation Group

Data Engineer → Senior · 2019–2024

Progressed from Data Engineer in Test to Senior Data Engineer, working on player migrations and shared real-time data products.

Bit8

QA Engineer · 2018–2019

First iGaming role. Built the platform's test automation foundation.

Verticals I've Worked Across

Casino Sports Betting Lottery Crypto Gambling Affiliate Marketing Player Acquisition B2B Platform B2C Operator

What I Build With

Streaming & ingestion

Kafka · Apache NiFi

Storage & query

Apache Iceberg · Amazon S3 · Athena

Transformation

dbt · AWS Glue

Layering

Bronze / Silver / Gold lakehouse

Let’s talk about your next project.

Need help with a data platform, pipeline, or migration? Get in touch.