Business Intelligence Specialist - Oracle

Toronto, ON
On-site
Posted Oct 23, 2026
1 position

$90–$95 / hour

Opens LinkedIn

Employment type: Contract
Experience level: Senior · 5+ years
Posting language: English
Working hours: 40 hours per week
Seniority: Mid-Senior level
Application method: Direct apply is available

Job summary

Build and support data pipelines that extract, transform, validate, and load Oracle and application data into Amazon Redshift, using AWS Glue Python Shell jobs and AWS DMS where needed. Design dimensional reporting layers and develop Power BI models, reports, and dashboards for operational metrics, data quality, and stakeholder reporting.

Job details

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.

What you’ll do

Requirements

Requires senior-level experience with Oracle, Python, AWS Glue Python Shell, AWS DMS, complex SQL, data integration, and production support. Candidates must also have Redshift dimensional-modeling and performance-tuning experience, Power BI development expertise, and healthcare-data knowledge including the Ontario HRM Standard, FHIR, and HL7 v2.