Mostly Remote! Business Intelligence Specialist - Senior, 6 months contract

• Location: Toronto, Ontario

• Duration: 2026-11-23 to 2027-05-20 ( 124 days)

• Job Type: Mostly Remote

• Openings: 1

Requirements:

• Oracle, Python, AWS Glue Python Shell, and AWS DMS experience, including complex SQL, source-data analysis, extraction, transformation, incremental loading, validation, reconciliation, and production support.

• Amazon Redshift and dimensional-modelling experience, including staging layers, fact and dimension structures, star schemas, views or materialized views, SQL optimization, and reporting-layer performance tuning.

• Power BI development experience, including semantic modelling, DAX, Power Query, dashboards, operational metrics, data-quality reporting, refresh processes, security, and performance optimization.

• Healthcare-data experience involving the Ontario HRM Standard, FHIR data structures, and HL7 v2 data structures, including mapping source data to consistent analytical definitions and metrics.