RQ00734-Senior Business Intelligence for VPD

Job Description

BI/Data Engineer – Provincial Health Services Directory (PHSD) AI Enhancement
On behalf of our client in the Healthcare Sector, PROCOM is looking for a BI/Data Engineer
BI/Data Engineer – Provincial Health Services Directory (PHSD) AI Enhancement
Job 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.

BI/Data Engineer – Provincial Health Services Directory (PHSD) AI Enhancement– Mandatory Skills 

• 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.
• 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.
• 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.
• Strong analytical, communication, documentation, stakeholder engagement, and knowledge transfer skills.

BI/Data Engineer – Provincial Health Services Directory (PHSD) AI Enhancement- Assignment Start Date     
ASAP – 9 months to start 
BI/Data Engineer – Provincial Health Services Directory (PHSD) AI Enhancement- Assignment Location     
Onsite as needed - Toronto

This employer uses both human and technology-assisted tools to support candidate screening and assessment. Final hiring decisions are made by people.