A National-Scale Public Health Intelligence Platform for Canada: End-to-End Data Engineering, Analytics, Alerting, and Business Intelligence

Public health decision-making increasingly depends on timely, explainable, and reproducible analytics. However, national health data pipelines are often fragmented, retrospective, and inaccessible to decision-makers. This paper presents a top-tier, end-to-end Public Health Intelligence Platform designed for Canada that integrates automated Extract–Transform– Load (ETL) pipelines, a dimensional PostgreSQL data warehouse, a FastAPI-based analytics and alerting layer, and an executive Power BI dashboard. The platform supports longitudinal health surveillance, explainable alerting, and interactive analytics with full auditability. Experimental evaluation demonstrates efficient query performance, reliable alert execution, and effective visualization for policy-oriented decision support. The system is production-ready, extensible, and suitable for adoption by public health agencies and research institutions