Find work in Canada.

549,996 jobs across our Canadian network. How we count

Jobs in Canada

Email me new jobs Save this search

Added 9 days ago
C
Data Integration Specialist
Croesus
Montreal, QC · Laval, QC
- Full-time
Experience with automation and scripting (Python, Bash, Airflow).
Added 9 days ago
Co-op/Intern/Temp (12-16 mo) - AI-Enabled Automation Engineering (Industrial Software Development)
Spartan Controls Ltd.
Calgary, AB
Develop and maintain applications using Python and other modern programming languages.
Added 9 days ago
AB
Data Scientist, Ricochet Anti-Cheat (Call of Duty)
Activision Blizzard
Vancouver, BC
- Other
Competence with Python, SQL, and PySpark for data analysis, data engineering, and production-scale workflows.
Added 9 days ago
P
Associate Director, Compliance
Purpose
Toronto, ON
- Full-time
…include Purpose Investments, Advisor Solutions by Purpose, and…
Added 9 days ago
Legal/Compliance - Associate Director, Compliance
Purpose Unlimited
Toronto, ON
…include Purpose Investments, Advisor Solutions by Purpose, and…
Added 9 days ago
3
Platform Data Engineer
360insights
Moncton, NB · Whitby, ON
- $93,500 to $108,500 CAD / year
Proficiency in Python and experience with PySpark or similar data transformation frameworks.
Added 9 days ago
II
Lead Data Engineer
Ipsos in Canada
Vancouver, BC
- Full-time
Proficiency in Python and advanced working knowledge of SQL.
Added 9 days ago
II
Senior Data Engineer
Ipsos in Canada
Vancouver, BC
- Full-time
Ingest and assemble data from various disparate sources using a variety of tools, including Python and SQL.
Added 9 days ago
JG
Sr. Software Developer
J&M Group
Canada
- Full-time
Microsoft Visual Studio (.NET) MVC, SQL Server (database creation and management) in Azure
Added 9 days ago
GV
Spécialiste digitalisation et configuration produit (Plateforme Genesis) / Product data specialist (Platform PLM Genesis)
GE Vernova
La Prairie, QC
- Full-time
Proficiency in SQL and Python for data automation and pipeline development.
Added 9 days ago
T
IT Ops Specialist – Kubernetes/GCP
TD
Toronto, ON
- Full-time
Knowledge of scripting languages and tools such as Python, JavaScript, Powershell, Bash.
Added 9 days ago
Data Platform Manager
Helcim Inc
Calgary, AB
Proficiency in SQL and Python, or related languages.
Added 9 days ago
P
Intermediate Software Engineer
PointClickCare
Mississauga, ON
- Full-time
At PointClickCare our mission is simple: to help providers deliver exceptional care. And that starts with our people. As a leading health tech company that’s founder-led and privately held,…
Added 9 days ago
T
Market Risk Manager, Trading Market Risk Stress Testing & Scenario Design (5111)
TD
Toronto, ON
- Full-time
TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at…
Added 9 days ago
Senior Data Scientist - Commercial Banking Data & Analytics, Toronto
Scotiabank
Toronto, ON
Advanced Python and SQL skills, with experience performing large-scale data analysis, feature engineering, and production support
Added 9 days ago
AI
Senior Forward Deployed AI Engineer (Python, Data & GenAI)
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Toronto, ON
- Full-time
Profile unfamiliar data using Python, pandas, PySpark, and SQL to assess coverage, quality, volumes, distributions, edge cases, and feasibility.
Added 9 days ago
TC
Technical Architect
Tata Consultancy Services
Toronto, ON
- $90,000 to $100,000 CAD / year
- Full-time
We are seeking a Technical Architect / Senior Developer – RPA & Automation to design, develop, maintain, and enhance enterprise automation solutions. The role will focus on UiPath,…
Added 9 days ago
PT
Senior Data Engineer – Capital Markets
Precision Technologies
Mississauga, ON
- Contract
We are looking for an experienced Senior Data Engineer with strong Capital Markets, SQL, Data Warehousing, and Snowflake expertise to join our technology team in Mississauga.
Added 9 days ago
SM
Business Systems Analyst
Smartrend Manufacturing Group
Winnipeg, MB
- $70,000 to $90,000 CAD / year
- Full-time
Working knowledge of SQL and relational databases, including data extraction, validation, and troubleshooting.
Added 9 days ago
T
Market Risk Manager, Trading Market Risk Stress Testing & Scenario Design (5111)
TD
Toronto, ON
- Full-time
TD is committed to providing fair and equitable compensation opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at…
Added 9 days ago
RT
Business Intelligence Specialist - Senior
Russell Tobin
Toronto, ON
- $85 to $95 CAD / hour
- Contract
Oracle, Python, AWS Glue Python Shell, and AWS DMS experience, including complex SQL, source-data analysis, extraction, transformation, incremental loading, validation, reconciliation, and…
Added 9 days ago
KR
AI Architect
KTek Resourcing
Vancouver, BC
- Contract
· AI / Development: Semantic Kernel, AutoGen, LangChain, CrewAI, .NET, Python, TensorFlow
Added 9 days ago
RT
Senior Software Engineer
Russell Tobin
Toronto, ON
- $75 to $95 CAD / hour
- Contract
Microsoft Visual Studio (.NET) MVC, SQL Server (database creation and management) in Azure
Added 9 days ago
T
Senior Software Developer – .NET, Python, AWS & Azure
ThoughtStorm
Toronto, ON
- Contract
We are hiring a Senior Software Developer for Public sector client to support its Drug Formulary and Genomics platforms.
Added 9 days ago
T
Business Specialist
ThoughtStorm
ON · Ontario, Canada
- Contract
Oracle, Python, AWS Glue Python Shell, and AWS DMS experience, including complex SQL, source-data analysis, extraction, transformation, incremental loading, validation, reconciliation, and…

ThoughtStorm

Business Specialist

ON, Canada
Ontario, Canada, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 20, 2026
Posting language: English
Posted: Oct 21, 2026

Original job description

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.

Job Title

RQ-2026-010035-Business Intelligence Specialist - Oracle - Senior for OCRE Development Project

Description

The Agency requires a Senior Business Intelligence Specialist with strong Oracle experience to support the Ontario Clinical Report Exchange (OCRE) project. The resource will develop the data integration and reporting capabilities needed to extract information from Oracle and OCRE application sources, load it into Amazon Redshift, and make reliable operational and business information available to OCRE 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 OCRE 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.

Required Experience:

Senior-level Oracle experience, including complex SQL, PL/SQL, data extraction, performance tuning, data profiling, and analysis of production data structures.

Hands-on experience developing AWS Glue Python Shell jobs and Python-based ETL processes that extract, transform, validate, and load data into Amazon Redshift.

Strong experience with Amazon Redshift, AWS DMS, dimensional modelling, star schemas, incremental data loads, reconciliation, and data-quality controls.

Strong Power BI experience, including semantic models, DAX measures, Power Query, report design, dashboard development, refresh processes, and performance optimization.

Practical experience interpreting the Ontario HRM Standard, FHIR data structures, and HL7 v2 data structures for healthcare reporting and analytics.

Responsibilities:

Work with OCRE business and technical stakeholders to define reporting requirements, business measures, data-quality indicators, acceptance criteria, and dashboard priorities.

Analyze Oracle schemas and OCRE application data sources to identify authoritative fields, relationships, business rules, data limitations, and extraction requirements.

Develop, test, and support AWS Glue Python Shell jobs that extract data from Oracle and OCRE application sources and load it into Amazon Redshift.

Configure or support AWS DMS replication and change-data-capture processes where they are used to move Oracle or application data into the reporting platform.

Implement full and incremental load patterns, transformations, validation rules, error handling, logging, reconciliation, restartability, and operational monitoring for data pipelines.

Design and maintain the Amazon Redshift reporting model, including staging structures, fact and dimension structures, keys, history handling, and star-schema relationships.

Create and optimize Redshift SQL views, materialized views, stored procedures, and queries that expose governed reporting datasets to Power BI.

Develop Power BI semantic models, DAX measures, Power Query transformations, reports, and dashboards for OCRE metrics, operational performance, and data quality.

Translate Ontario HRM, FHIR, and HL7 v2 data elements into consistent analytical definitions while preserving clinical meaning, traceability, and source-system context.

Profile source and target data, identify anomalies or gaps, implement data-quality rules, and reconcile dashboard results to Oracle and OCRE source data.

Tune Oracle queries, AWS Glue jobs, Redshift workloads, and Power BI models to meet agreed performance, refresh, scalability, and support requirements.

Prepare technical designs, source-to-target mappings, dimensional models, metric definitions, test evidence, deployment instructions, runbooks, and knowledge-transfer materials.

Desired Skills:

Experience designing dimensional models using fact tables, dimension tables, conformed dimensions, surrogate keys, slowly changing dimensions, and auditable metric definitions.

Experience with Redshift performance features such as distribution styles, sort keys, workload management, query plans, materialized views, and columnar data design.

Experience with Power BI row-level security, deployment pipelines, scheduled refresh, gateways, workspace governance, usage monitoring, and accessibility practices.

Experience supporting healthcare analytics solutions that require data lineage, privacy-aware access, auditability, reconciliation, production monitoring, and incident investigation.

Required Skills:

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.

Rated Criteria:

Oracle, Python, AWS Glue Python Shell, and AWS DMS experience, including source analysis, complex SQL, ETL development, incremental loading, validation, reconciliation, and production support. 25 points

Amazon Redshift and dimensional-modelling experience, including staging structures, fact and dimension models, star schemas, views or materialized views, SQL optimization, and workload performance. 25 points

Power BI experience, including semantic models, DAX, Power Query, dashboards, operational metrics, data-quality reporting, refresh, security, and performance optimization. 25 points

Ontario HRM Standard, FHIR, and HL7 v2 data-structure experience, including healthcare-data mapping, metric definition, traceability, and interpretation of clinical and operational data. 25 points

Total: 100 Points

Deliverables

Production-ready AWS Glue Python Shell jobs and supporting Python or SQL components that extract data from Oracle and OCRE application sources and load it into Amazon Redshift.

AWS DMS configurations, mappings, validation results, and operational documentation for replication or change-data-capture workflows assigned to the resource.

Amazon Redshift staging, ingestion, transformation, and reconciliation components supporting full and incremental data loads.

A governed Redshift star-schema reporting layer containing the required fact and dimension structures, relationships, history handling, and business definitions.

Optimized Redshift views, materialized views, stored procedures, and queries that provide Power BI with reliable and supportable reporting datasets.

Power BI semantic models, DAX measures, Power Query transformations, reports, and dashboards for OCRE metrics, operational monitoring, data quality, and stakeholder-defined reporting needs.

Documented metric definitions, source-to-target mappings, data-quality rules, validation controls, lineage, and reconciliation results.

Automated and manual test assets covering extraction, transformation, incremental loads, data completeness, data accuracy, report calculations, refresh, regression, and release validation.

Operational logging, monitoring, alerting, restart, recovery, incident-investigation, and support procedures for the data pipelines and reporting solution.

Technical designs, dimensional models, configuration notes, deployment instructions, runbooks,

Apply About employer

More about this job

Responsibilities

Develop and support data pipelines that extract, transform, validate, and load Oracle and OCRE application data into Amazon Redshift, including incremental loading and replication where needed. Design and optimize Redshift reporting models and Power BI dashboards, while ensuring healthcare data is accurately interpreted, reconciled, monitored, and documented.

Requirements

The role requires senior-level Oracle and SQL expertise, hands-on Python and AWS Glue ETL development, AWS DMS, Amazon Redshift, and dimensional modeling. It also requires strong Power BI development skills and practical experience interpreting the Ontario HRM Standard, FHIR, and HL7 v2 data structures for healthcare analytics.

Skills

Oracle
Python
AWS Glue Python Shell
Amazon Redshift
SQL
ETL
Dimensional Modeling
Power BI
DAX
Power Query
Healthcare Data
Ontario HRM Standard
FHIR
HL7 v2
Data Quality

Visa sponsorship

Not detected in the job text

Keywords

Oracle
Python
AWS Glue Python Shell
Amazon Redshift
Power BI
SQL
PL/SQL
ETL
Change Data Capture
Incremental Data Loads
Dimensional Modeling
Star Schema
Fact Tables
Dimension Tables
DAX
Power Query
Ontario HRM Standard
FHIR
HL7 v2
Healthcare Analytics
Data Quality
Data Reconciliation
Data Lineage
Performance Tuning
Semantic Models
Materialized Views
Data Validation
Production Support
Operational Monitoring

Report this job