Business Intelligence Specialist

• 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 Cloud Watch.
• Experience integrating healthcare data using FHIR, HL7 v2, Smile CDR, AWS Health Lake, 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

Location:
Hybrid (onsite as needed)

Public Sector

Experience:

must have

# of submissions/supplier: 1

Job Title

Senior Business Intelligence Specialist for Virtual Products Development

The Agency is expanding the Provincial Health Services Directory (PHSD) to incorporate artificial intelligence capabilities that improve provider discovery, referral quality, and healthcare navigation across provincial digital health applications. The solution will utilize PHSD provider, practitioner, organization, healthcare service, specialty, location, and service metadata together with clinical referral context to provide intelligent recommendations while maintaining traceability to authoritative source data. AI agents will consume PHSD FHIR APIs, Smile CDR, AWS Health Lake, the Agency Master Data Management, and other provincial digital health assets to provide grounded responses rather than generative opinions.

The project includes development of reusable AI services, MCP servers, semantic search capabilities, vector-based retrieval, prompt orchestration, evaluation frameworks, and secure integration with SMART on FHIR applications and provincial healthcare systems. The implementation will emphasize explainability, auditability, privacy, security, and clinical confidence while supporting future AI-enabled healthcare workflows across the Agency.

• 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 Cloud Watch.
• Experience integrating healthcare data using FHIR, HL7 v2, Smile CDR, AWS Health Lake, 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

• Design, develop, and maintain enterprise Power BI dashboards supporting operational, executive, clinical, and business reporting.
• Develop AI-assisted dashboards utilizing Power BI Copilot, natural language queries, AI visualizations, forecasting, anomaly detection, and intelligent insights where appropriate.
• Design and implement enterprise data warehouse solutions using Amazon Redshift.
• Develop dimensional star schemas, fact tables, dimension tables, and semantic models supporting enterprise reporting.
• Develop AWS Glue ETL pipelines using Python to ingest, transform, validate, and load data into Amazon Redshift.
• Develop automated data ingestion processes from NetIQ IAM, Pexip, Zoom, Smile CDR, AWS Health Lake, 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 solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
• Enterprise data…