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
  

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