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 hrsmss@smsoftconsulting.com 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. Strong 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 hrsmss@smsoftconsulting.com:

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.