Project Overview Ontario's current medical triage algorithm plays a crucial role in prioritizing emergency medical calls. The Ministry of Health is implementing the Medical Priority Dispatch System (MPDS), a gold-standard solution used in communication centres globally. This aligns with Patients First and Enhanced Emergency Services Ontario. CSIMB will integrate required new data feeds into the Ministry's data environment to support seamless reporting, system monitoring, and analytics. Key Responsibilities Data architecture for ADDS Power BI solution (representing 40% of time) Solution Architecture Document Data Flow Diagrams Conceptual/Logical/Physical Data Models Databricks Lakehouse Design Power BI Semantic Model Design Role model and security design,



including Row-Level Security Design Data Governance Framework Data Lineage Documentation Performance & Capacity Plan Workplace and Continuous Integration and Continuous Delivery (CI/CD) pipeline design Non-Functional Requirements Architecture review and Sign-Off Package Hands on Power BI development for reports (representing 60% of time) Design and develop Power BI semantic models Connect and integrate Databricks data sources Implement DAX measures and KPIs Build dashboards and reports Configure security and RLS Optimize performance Support testing and deployment, and provide technical documentation and knowledge

📌 Business Intelligence Specialist (Toronto)
🏢 GovTech Talent Solutions
📍 Toronto