RQ00734 - Business Intelligence Specialist - Senior

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
  

Responsibilities:

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

Desired Skills:

• Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  
• Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  
• ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  
• Advanced SQL development, query optimization, and performance tuning.
  
• Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  
• Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  
• AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  
• AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  
• 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:

• Business intelligence solution design, dashboard development, and enterprise reporting using Microsoft Power BI.
  
• Enterprise data warehouse design including dimensional modelling, star schemas, fact tables, dimension tables, and semantic models.
  
• ETL and ELT development using Python, AWS Glue, SQL, and Amazon Redshift.
  
• Advanced SQL development, query optimization, and performance tuning.
  
• Data integration from REST APIs, FHIR APIs, Smile CDR, AWS HealthLake, NetIQ IAM, Pexip, Zoom, Provider Registry, Master Data Management, and enterprise databases.
  
• Healthcare analytics using FHIR R4/R4B, HL7 v2, SMART on FHIR, and healthcare interoperability standards.
  
• AI-assisted analytics including Power BI AI capabilities, natural language insights, forecasting, anomaly detection, and intelligent reporting.
  
• AWS analytics services including Amazon Redshift, AWS Glue, S3, Athena, IAM, CloudWatch, and related cloud services.
  
• Data quality management, governance, reconciliation, validation, and operational reporting.
  
• Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.
  

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
  

Requirements

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.
  

Must Haves:

• 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