Position: Senior Business Intelligence Specialist Location: Toronto, Ontario, Canada (Hybrid Onsite as Needed) Office: 525 University Avenue Duration: 164 Business Days (with possible extension) Keywords: Power BI, Business Intelligence, AWS Redshift, AWS Glue, Python, SQL, ETL, ELT, Data Warehouse, Star Schema, Snowflake Schema, Healthcare Analytics, HL7, FHIR, Smile CDR, AWS Health

Lake, IAM, OAuth2, AI Analytics, Power BI Copilot, Data Modeling Job Description: Must Have: 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 Amazon Redshift, AWS 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 Solid SQL, data modeling, analytics, and performance optimization skills Experience evaluating AI accuracy, hallucination reduction, grounding, and response quality Public sector experience is required

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