Business Intelligence Specialist - Senior

Job Title: Senior Business Intelligence Specialist

Location: Toronto, Ontario

Work Model: Hybrid

Duration: 8 months

Must Haves

• Senior experience designing and developing enterprise Business Intelligence and analytics solutions.
• Extensive experience developing Power BI dashboards, reports, semantic models, and datasets.
• Experience developing dimensional data warehouses using star and snowflake schemas.
• Experience developing ETL and ELT processes using Python and AWS Glue.
• Experience developing SQL for Amazon Redshift and relational databases.
• Experience integrating data from REST APIs, databases, cloud platforms, and enterprise applications.
• Experience with AWS analytics services including Redshift, Glue, S3, Athena, and CloudWatch.
• Experience integrating healthcare data using FHIR, HL7 v2, Smile CDR, AWS HealthLake, and healthcare APIs.
• Experience implementing secure data access using IAM, OAuth2/OIDC, and role-based security.
• Strong SQL, data modelling, analytics, and performance optimization experience.
• Experience evaluating AI accuracy, hallucination reduction, grounding, and response quality.
• Experience with Pexip and Zoom APIs and data structures
• Experience with NetIQ IAM APIs and data structures
• Experience with AWS Bedrock

Deliverables

• Enterprise Power BI dashboards supporting operational, executive, clinical, and business reporting.
• AI-assisted Power BI reports incorporating natural language insights, forecasting, anomaly detection, KPI analysis, and interactive analytics where appropriate.
• Amazon Redshift enterprise data warehouse including dimensional models, star schemas, fact tables, dimension tables, views, and semantic models.
• AWS Glue ETL pipelines developed using Python for automated ingestion, transformation, validation, and loading of enterprise data.
• Automated data extraction processes from NetIQ IAM, Pexip, Zoom, Smile CDR, AWS HealthLake, PHSD operational databases, Provider Registry, Master Data Management, application logs, and other approved data sources.
• Enterprise data quality validation, reconciliation, governance, and monitoring processes.
• Operational dashboards supporting platform utilization, provider activity, referral analytics, system performance, user adoption, and executive reporting.
• Documentation for data models, ETL processes, report definitions, data lineage, metadata, operational procedures, and deployment processes.
• Automated deployment pipelines, testing procedures, production implementation support, and operational transition documentation.

Experience & Skill Set Requirements

Evaluation Criteria

• Business intelligence, dashboard development, Power BI reporting, semantic models, executive reporting, KPI development, and AI-assisted analytics experience. 25 Points
• Enterprise data engineering experience including Amazon Redshift, AWS Glue, Python, SQL, dimensional modelling, ETL/ELT development, and enterprise data warehouse design. 25 Points
• Healthcare analytics and interoperability experience including Smile CDR, AWS HealthLake, FHIR R4/R4B, HL7 v2, NetIQ IAM, Pexip, Zoom, healthcare APIs, and enterprise healthcare data integration. 25 Points
• Experience working with digital health assets including PHSD, Hospital Report Manager (HRM), Enterprise Master Data Management, stakeholder engagement, documentation, and knowledge transfer. 25 Points

Desired Skills (unique - not duplicating Must-Haves)

• AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
• Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
• Python Glue shell experience
• Experience with Pexip and Zoom APIs, extracting data for analytics
• Data quality management, governance, reconciliation, validation, and operational reporting.
• Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

Required Skills (unique - not duplicating Must-Haves or Desired Skills)

• Advanced SQL development, query optimization, and performance tuning.

Responsibilities (unique capabilities not covered by Must-Haves)

• Develop AI-assisted dashboards utilizing Power BI Copilot, natural language queries, AI visualizations, forecasting, anomaly detection, and intelligent insights where appropriate.
• Develop automated data ingestion processes from NetIQ IAM, Pexip, Zoom, Smile CDR, AWS HealthLake, Provider Registry, Master Data Management, PHSD operational databases, application logs, and other provincial digital health assets.
• Develop data quality validation, cleansing, reconciliation, and governance processes supporting analytics accuracy.
• Optimize Redshift performance, partitioning, indexing strategies, query execution, and warehouse scalability.
• Develop operational KPIs, healthcare utilization metrics, provider activity reports, referral analytics, platform adoption reporting, and executive dashboards.
• Collaborate with business stakeholders to gather reporting requirements and develop meaningful analytics solutions.
• Develop deployment pipelines, documentation, operational procedures, and knowledge transfer materials.
• Support production implementation, troubleshooting, report optimization, and ongoing analytics enhancements.