Business Intelligence Specialist – Senior | Supply Ontario (Hybrid, Toronto, ON, Canada) We are hiring a Senior Business Intelligence Specialist to support Supply Ontario’s digital health analytics and artificial intelligence initiatives. This role requires advanced expertise in enterprise BI solutions, Power BI development, data engineering, AWS analytics services, healthcare interoperability, AI-enabled analytics, and enterprise data warehousing. The successful candidate will design and deliver analytics solutions supporting provincial healthcare platforms by leveraging healthcare data sources including FHIR APIs, HL7 v2, Smile CDR, AWS HealthLake, Provincial Health Services Directory (PHSD), NetIQ IAM, Pexip, Zoom APIs, and enterprise healthcare systems.
The role focuses on building secure, explainable, and scalable analytics capabilities that improve provider discovery, referral quality, healthcare navigation, and digital health operations.
Role Snapshot Job Details
Requisition ID RQ00734 Job Title Business Intelligence Specialist – Senior Client Supply Ontario Work Location 525 University Avenue, Toronto, Ontario, Canada Work Model Hybrid (Onsite as Required by Hiring Manager) Estimated Start Date August 31, 2026 Estimated End Date April 23, 2027 Contract Duration 164 Business Days Hours 7.25 Hours per Day (5 Days per Week) Public Sector Experience Mandatory Mandatory Documents Interested candidates should submit the following to
[email protected] by Wednesday, August 5, 2026, at 11:00 AM EST. Applications without all mandatory documents cannot be processed.
Updated
Resume in Word Format (Mandatory)
Skills Matrix and References (Mandatory)
Expected Hourly Rate (Mandatory)
Visa Status (Mandatory)
LinkedIn Profile URL (Mandatory) Role Summary The Senior Business Intelligence Specialist will support the development of advanced analytics and AI-enabled reporting solutions for provincial digital health platforms. The consultant will design enterprise reporting solutions, develop data warehouse architectures, build ETL/ELT pipelines, integrate healthcare data sources, and deliver secure analytics capabilities. The role requires strong experience with Microsoft Power BI, Amazon Redshift, AWS Glue, Python, SQL, healthcare interoperability standards, FHIR, HL7, AI-assisted analytics, and enterprise data governance.
Key Responsibilities Business Intelligence & Analytics Development (30%)
Design, develop, and maintain enterprise Power BI dashboards and reporting solutions.
Build operational, executive, clinical, and business analytics dashboards.
Develop Power BI semantic models, datasets, reports, and KPI frameworks.
Implement AI-assisted analytics capabilities including:
Natural language insights
Forecasting
Anomaly detection
Intelligent reporting
Power BI Copilot capabilities
Develop healthcare utilization metrics, referral analytics, provider activity reports, and adoption dashboards.
Enterprise Data Engineering & Data Warehouse Development (30%)
Design and implement enterprise data warehouse solutions using Amazon Redshift.
Develop dimensional data models including:
Star schemas
Snowflake schemas
Fact tables
Dimension tables
Semantic models
Develop ETL/ELT pipelines using
Python
AWS Glue
SQL
Optimize Redshift performance, scalability, and query execution.
Perform advanced SQL development, tuning, and performance optimization.
Healthcare Data Integration & Interoperability (20%)
Integrate healthcare data from
FHIR APIs
HL7 v2 interfaces
Smile CDR
AWS HealthLake
NetIQ IAM
Pexip
Zoom APIs
Provider Registry
Enterprise Master Data Management systems
Support healthcare interoperability using:
FHIR R4/R4B
SMART on FHIR
HL7 messaging standards
Develop analytics solutions using clinical, provider, referral, and operational data.
Ensure healthcare data integration supports secure and traceable AI-driven recommendations.
AWS Analytics & Cloud Data Services (10%)
Develop analytics solutions using AWS services including:
Amazon Redshift
AWS Glue
Amazon S3
Amazon Athena
CloudWatch
AWS IAM
Build automated data ingestion and transformation processes.
Support cloud-based analytics monitoring and operational reporting.
Data Governance, Documentation & Support (10%)
Develop data quality validation, reconciliation, and governance processes.
Create technical documentation including:
Data models
ETL processes
Data lineage
Metadata documentation
Report definitions
Deployment procedures
Support production implementation, troubleshooting, optimization, and knowledge transfer.
Required Skills &
Experience Skill / Experience Required Enterprise Business Intelligence Solution Design Required Microsoft Power BI Dashboards, Reports &
• Semantic Models Required Enterprise Data Warehouse Design Required Dimensional Modelling (Star/Snowflake Schemas) Required Python, AWS Glue ETL/ELT Development Required Amazon Redshift &
• Advanced SQL Development Required REST API, Cloud &
• Enterprise Data Integration Required Healthcare Data Integration (FHIR, HL7 v2) Required Smile CDR &
• AWS HealthLake Experience Required AI-Assisted Analytics &
• Quality Evaluation Required IAM, OAuth2/OIDC &
• Role-Based Security Required Data Quality, Governance &
• Reporting Required Technical Expertise Required Microsoft Power BI:
Dashboards
Reports
Semantic models
Datasets
AI-assisted reporting
Enterprise data engineering
Amazon Redshift
AWS Glue
Python
SQL
ETL/ELT pipelines
Healthcare analytics
FHIR R4/R4B
HL7 v2
SMART on FHIR
Smile CDR
AWS HealthLake
Data integrations
REST APIs
Healthcare APIs
NetIQ IAM APIs
Pexip APIs
Zoom APIs
Security
IAM
OAuth2/OIDC
Role-based access controls
AI analytics
Power BI Copilot
Natural language analytics
Forecasting
Anomaly detection
AI response quality evaluation
Desired Skills Experience supporting digital health platforms and provincial healthcare systems.
Experience with PHSD,
Hospital Report Manager (HRM), and Enterprise Master Data Management.
Experience extracting and analyzing data from Pexip and Zoom APIs.
Experience with AWS Bedrock.
Python AWS Glue Shell experience.
Experience developing healthcare operational dashboards.
Solid documentation, communication, stakeholder engagement, and knowledge transfer skills.
Evaluation Criteria Evaluation Area Weight
Power BI, BI Reporting, Semantic Models, KPI Development & AI-Assisted Analytics 25 Points Enterprise Data Engineering, Redshift, AWS Glue, Python, SQL & Data Warehousing 25 Points Healthcare Analytics, FHIR, HL7, Smile CDR, AWS HealthLake, IAM, Pexip & Zoom Integration 25 Points Digital Health Platforms, PHSD, Master Data Management, Documentation & Knowledge Transfer 25 Points Key Deliverables The Successful Consultant Will Deliver Enterprise Power BI dashboards supporting:
Operational reporting
Executive reporting
Clinical analytics
Business intelligence
AI-assisted Power BI reports with:
Natural language insights
Forecasting
Anomaly detection
KPI analytics
Amazon Redshift enterprise data warehouse solutions:
Data models
Star schemas
Fact tables
Dimension tables
Semantic models
AWS Glue ETL pipelines using Python.
Automated data extraction processes from:
NetIQ IAM
Pexip
Zoom
Smile CDR
AWS HealthLake
PHSD databases
Provider Registry
Master Data Management systems
Data quality, reconciliation, governance, and monitoring processes.
Healthcare analytics dashboards supporting:
Provider activity
Referral analytics
Platform utilization
Adoption reporting
Executive insights
Documentation covering
Data lineage
Metadata
Data models
ETL processes
Deployment procedures
Production support, testing, and operational transition documentation.
Additional Terms Contract duration: 164 Business Days.
Engagement may be extended for unused Business Days at the Agency’s discretion.
Hybrid work arrangement with onsite attendance as required by the Hiring Manager.
Consultant must comply with Agency policies and procedures.
Agency laptop will be provided.
Consultant must provide
Additional monitor
External keyboard
Mouse
Home office requirements
Private workspace
Hard-wired internet connection
Adequate bandwidth
Agency systems cannot be accessed outside Ontario without prior written approval.
Agency equipment cannot be removed from Ontario without authorization.
How To Apply Please submit the following by Wednesday, August 5, 2026, at 11:00 AM EST to
[email protected]: Updated Resume in Word Format (Mandatory)
Skills Matrix and References (Mandatory)
Expected Hourly Rate (Mandatory)
Visa Status (Mandatory)
LinkedIn Profile URL (Mandatory) Applications missing any of the mandatory documents cannot be processed. If this opportunity is not the right fit for you, feel free to share it with experienced Senior Business Intelligence Specialists, BI Developers, Data Engineers, or Analytics Architects with expertise in Power BI, AWS analytics, Redshift, Glue, Python, healthcare interoperability, FHIR, HL7, AI analytics, and digital health platforms.
📌 Business Intelligence Specialist - Senior (Toronto)
🏢 S M Software Solutions
📍 Toronto