Business Intelligence Specialist - Oracle - Senior
Start Date
2026-11-23
End Date
2027-05-20
Location: Onsite as needed basis
Public Sector Experience: must have
Office Location
525 University Avenue
Overview: Senior Business Intelligence Specialist with strong Oracle experience to support a Clinical Reporting and Data Exchange Program. The resource will develop the data integration and reporting capabilities needed to extract information from Oracle and application data sources, load it into Amazon Redshift, and make reliable operational and business information available to stakeholders. The role will build AWS Glue Python Shell jobs and supporting SQL to extract, transform, validate, and load data into Amazon Redshift, while using AWS Database Migration Service (AWS DMS) where replication or change-data-capture capabilities are required. In Redshift, the resource will design a star-schema reporting layer with fact and dimension structures, views, or materialized views appropriate to the reporting workload. The resource will then develop Power BI semantic models, reports, and dashboards for operational metrics, data-quality monitoring, and other reporting needs defined by business stakeholders. The work requires an understanding of the Ontario HRM Standard, FHIR data structures, and HL7 v2 data structures so that clinical and operational data is interpreted and modelled correctly.
Must Haves:
- 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.
Note: AI-enabled tools may be used to sort applications based on job-related criteria. All AI generated results are vetted by our team and the decision of which candidates move forward is always made by a human.
