Projects

Data engineering work — pipelines, frameworks, and analytical tooling.

PySpark · Databricks · Azure · Snowflake

Data Engineering Framework

A reusable PySpark library for standardising how pipelines are written — multi-source ingestion, Informatica-style transformations, regression testing, and Delta Lake write-back.

Snowflake · Cortex Analyst · Semantic Views

Snowflake Cortex Analyst

Natural language analytics layer over a real estate portfolio data model — plain English questions resolved to auditable, SQL-backed answers via Cortex Analyst and Semantic Views.

SQL · Multi-dialect · Analytics

SQL Practice Suite

Advanced SQL problems with worked solutions covering window functions, recursive CTEs, SCD modelling, and query optimisation across SQL Server, Snowflake, and Spark SQL.