Showcasing practical data and internal tools solutions
End-to-end data engineering pipeline on Databricks using a Medallion architecture (Bronze → Silver → Gold) with PySpark and Delta Lake. Transforms public economic datasets — Statistics Canada wages, CPI, and unemployment, plus Alberta Open Data rent — into a custom Affordability Index, surfaced through a multi-page Databricks SQL dashboard.
Tech: Databricks · PySpark · Delta Lake · SQL · Python · Databricks SQL Dashboards
AI-assisted build: developed with Claude, GitHub Copilot, and Cursor; all generated code reviewed and tested before use.
Internal portal built with Lovable (AI app builder) and a Supabase backend, replacing manual spreadsheet tracking of investors and founders. Designed the role structure — Super Admin, GP Admin, LP, Founder — so each user sees only what they should. Directed the AI build, and maintain and debug the application.
Tech: Lovable · Supabase (PostgreSQL) · Figma
Internal analytics dashboard for Technology Alberta's leadership, turning engagement data that previously needed manual effort into consistent, automated reporting.
Tech: Looker Studio · SQL