Sep 2025 — Present
Revenue & Taxation
Data Analysis Coordinator
City of Kawartha Lakes
- Designed and built the department's data platform from the ground up — layered Python libraries with canonical dataset contracts and repository adapters over the iCity SQL Server system, replacing a legacy monolith with documented, test-covered packages.
- Automated recurring reporting with scheduled Luigi pipelines and a reusable report-runner framework, producing versioned datasets and Excel reports with auditable run logs.
- Delivered a weekly payment-analysis pipeline publishing curated Parquet data to Power BI dashboards that track property tax and utility billing payments.
- Productionized the platform on a Linux automation server — systemd services, file-drop watchers, and offline release bundles for locked-down municipal IT — and authored a full handbook and architecture map for role handoff.
- Python
- pandas
- SQL Server
- Luigi
- Power BI
- Docker