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.
- Robust 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.

📌 Business Intelligence Specialist - Senior (Toronto)
🏢 Innosystech
📍 Toronto