Senior Business Intelligence Specialist – Oracle

BITS Recruiting; Toronto; Sur place; CAD 90 000 - 130 000; Plein temps

Résumé du poste

BITS Recruiting seeks an experienced Senior BI Specialist to lead data integration and reporting for a healthcare program in Toronto. The role focuses on building ETL pipelines, modeling data in Redshift, and delivering Power BI dashboards for operations and executives.

The candidate will implement data quality checks, optimize performance, and work with Ontario HRM, FHIR, and HL7 v2 standards. Public sector experience is mandatory and project duration is a finite contract.

Qualifications

• Extensive Oracle, SQL, Python, and AWS Glue Python Shell experience.
• Hands-on AWS DMS and Redshift data modeling skills.
• Proficient in Power BI, DAX, Power Query and dashboard optimization.
• Experience with healthcare data standards (Ontario HRM Standard, FHIR, HL7 v2) is required.

Responsabilités

• Develop Python-based ETL processes using AWS Glue to extract, transform, validate, and load data.
• Work with Oracle databases, complex SQL, and AWS DMS.
• Design and optimize Amazon Redshift data models, including star schemas, fact tables, and dimension tables.
• Develop Power BI semantic models, dashboards, reports, DAX measures, and Power Query transformations.
• Implement data-quality checks, incremental loading, data reconciliation, and performance optimization.
• Work with healthcare data standards and support technical documentation and knowledge transfer.

Connaissances

Oracle

SQL

Python

AWS Glue Python Shell

AWS DMS

Power BI

DAX

Power Query

Data modeling

Data quality checks

Outils

AWS Glue

AWS DMS

Amazon Redshift

Oracle databases

Power BI semantic models

Description du poste

Contract: November 23, 2026 – May 20, 2027

We are seeking an experienced Senior Business Intelligence Specialist to support a healthcare data integration and reporting initiative. The successful candidate will build data pipelines, develop reporting models, and deliver Power BI dashboards that provide reliable operational and business insights.

Key Responsibilities:

• Develop Python-based ETL processes using AWS Glue to extract, transform, validate, and load data.
• Work with Oracle databases, complex SQL, and AWS Database Migration Service (AWS DMS).
• Design and optimize Amazon Redshift data models, including star schemas, fact tables, and dimension tables.
• Develop Power BI semantic models, dashboards, reports, DAX measures, and Power Query transformations.
• Implement data-quality checks, incremental loading, data reconciliation, and performance optimization.
• Work with healthcare data standards and support technical documentation and knowledge transfer.

Required Qualifications:

• Strong Oracle, SQL, Python, AWS Glue Python Shell, and AWS DMS experience.
• Hands-on experience with Amazon Redshift and dimensional data modelling.
• Strong Power BI development skills, including DAX, Power Query, and dashboard optimization.
• Healthcare data experience involving the Ontario HRM Standard, FHIR, and HL7 v2.
• Previous public sector experience is mandatory.
• Strong analytical, problem-solving, and communication skills.

If you have the technical expertise and healthcare data experience to deliver complex data integration and reporting solutions, we’d love to hear from you!

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.