Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 18 days ago
M
RQ00795 - Software Developer - Senior
Maarut
Toronto, ON
- Contract
The Senior Software Developer will support the Drug Formulary and Genomics team. Drug Formulary is a cancer drug and regimen resource for patients and healthcare professionals. It provides…
Added 18 days ago
M
RQ00812 - Business Intelligence Specialist - Oracle - Senior
Maarut
Toronto, ON
- Contract
Senior-level Oracle experience, including complex SQL, PL/SQL, data extraction, performance tuning, data profiling, and analysis of production data structures.
Added 18 days ago
M
Full Stack Developer contractor contigent req for Deepak Nangia
MDA
Brampton, ON
- Full-time
o Angular (must have)
Added 19 days ago
P
Senior Software Engineer - Java
PointClickCare
Mississauga, ON
- $142,000 to $158,000 CAD / year
- Full-time
Expertise in design, optimization, and scaling for relational (SQL) database
Added 19 days ago
S
Solutions Architect
Sigmoid
Toronto, ON
- Full-time
We are looking for a senior Engineering Leader / Solutions Architect to drive the design, modernization, and scale-out of enterprise data platforms within a cloud-native lakehouse…
Added 19 days ago
J
Senior Manager, Forecast Delivery, Personal and Commercial Operations
Jobgether
Canada
- Full-time
Proficiency in SQL and/or general-purpose programming languages such as Python to support data analysis, forecasting, and analytical problem-solving.
Added 19 days ago
GM
Actuarial Specialist
Gore Mutual Insurance
Cambridge, ON
- Full-time
Develop solutions using actuarial software, SQL, Python, R, Earnix, or other analytical tools.
Added 19 days ago
T
Manager - Stress Testing Data, Controls and Analytics
TD
Toronto, ON
- Full-time
The Manager, Stress Testing Data, Controls & Analytics is a senior hands-on delivery role within Aggregation & Control. The role combines stress testing subject-matter expertise, data…
Added 19 days ago
KD
Programme LEAP hiver 2027, Stagiaire – Analyste, Chaîne d’approvisionnement | Winter 2027 LEAP Intern – Supply Chain Analyst
Keurig Dr Pepper
Montreal, QC
- Full-time
Hybride; 3 jours au bureau · Hybrid; 3 days in office
Added 19 days ago
PC
Valuations Financial Instruments, Senior Manager
Pwc Canada
Toronto, ON
- Full-time
Experiences in common programming languages (e.g. Python/R/Visual Basic/SQL) will be an asset.
Added 19 days ago
KD
Programme LEAP hiver 2027, Stagiaire – Analyste, Chaîne d’approvisionnement | Winter 2027 LEAP Intern – Supply Chain Analyst
Keurig Dr Pepper Canada
Montreal, QC
- Full-time
Hybride; 3 jours au bureau · Hybrid; 3 days in office
Added 19 days ago
FV
Junior Database Administrator
Forum Ventures
Toronto, ON
- $70,000 to $80,000 CAD / year
- Full-time
We’re looking for a talented Junior Database Administrator to join our team and work alongside our senior DBA. You’ll help write and optimize SQL queries, monitor database performance, and…
Added 19 days ago
A
Senior Test Engineer
Actalent
Ottawa, ON · Nepean, ON
- $50 to $60 CAD / hour
- Contract
Proficiency with Python for scripting and programming in test environments.
Added 19 days ago
AB
Data Scientist, Ricochet Anti-Cheat (Call of Duty)
Activision Blizzard
Vancouver, BC
- Other
This role can be based in either our Sherman Oaks, CA or our Vancouver, BC office and follows an onsite work schedule of four days per week
Added 19 days ago
P
Associate Director, Compliance
Purpose
Toronto, ON
- Full-time
Prepare clear, decision-useful compliance reporting for senior management and governance forums.
Added 19 days ago
Legal/Compliance - Associate Director, Compliance
Purpose Unlimited
Toronto, ON
Prepare clear, decision-useful compliance reporting for senior management and governance forums.
Added 19 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 19 days ago
T
Market Risk Manager, Trading Market Risk Stress Testing & Scenario Design (5111)
TD
Toronto, ON
- Full-time
…risks are transparent to Risk Management, Business Leaders, and Senior…
Added 19 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 19 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 19 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 19 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 19 days ago
T
Market Risk Manager, Trading Market Risk Stress Testing & Scenario Design (5111)
TD
Toronto, ON
- Full-time
…risks are transparent to Risk Management, Business Leaders, and Senior…
Added 19 days ago
RT
Business Intelligence Specialist - Senior
Russell Tobin
Toronto, ON
- $85 to $95 CAD / hour
- Contract
Public Sector Experience: must have
Added 19 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

Russell Tobin

Business Intelligence Specialist - Senior

Toronto, ON, Canada

$85 to $95 CAD / hour · Contract

Apply on LinkedIn About employer

Applications open in a new tab.

Job details

Pay: $85 to $95 CAD / hour
Job type: Contract
Apply by: Nov 20, 2026
Posting language: English
Posted: Oct 21, 2026

Original job description

Russell Tobin & Associates is hiring on behalf of one of its esteemed clients.

Job Title: Business Intelligence Specialist

Location: Toronto, ON (Onsite – 5 days/week)

Duration: 124 Business Days

Client: Public Sector

Pay Rate: $85 - $95/hr [CAD]

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.

Public Sector Experience: must have

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.

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

If this opportunity matches your experience and career goals, please share your most updated resume for consideration.

Apply on LinkedIn About employer

More about this job

Responsibilities

Define reporting requirements and healthcare metrics with stakeholders, analyze source data, and build and support data pipelines from Oracle and application sources into Amazon Redshift. Design reporting models and Power BI dashboards, map healthcare data standards to analytical definitions, and ensure data quality, performance, documentation, and production support.

Requirements

The role requires experience with Oracle, Python, AWS Glue Python Shell, AWS DMS, complex SQL, incremental ETL, validation, reconciliation, and production support. It also requires Amazon Redshift and dimensional modeling, Power BI development, healthcare data experience with the Ontario HRM Standard, FHIR, and HL7 v2, and public sector experience.

Skills

Oracle
Python
AWS Glue Python Shell
AWS DMS
Amazon Redshift
Dimensional Modeling
SQL
ETL Development
Incremental Data Loading
Power BI
DAX
Power Query
Healthcare Data Mapping
FHIR
HL7 v2
Data Quality and Reconciliation

Visa sponsorship

Not detected in the job text

Keywords

Oracle
Python
AWS Glue Python Shell
AWS DMS
Amazon Redshift
Power BI
DAX
Power Query
SQL
ETL
Incremental Loading
Change Data Capture
Dimensional Modeling
Star Schema
Fact Tables
Dimension Tables
Materialized Views
Data Quality
Data Reconciliation
Data Lineage
Ontario HRM Standard
FHIR
HL7 v2
Healthcare Analytics
Semantic Modeling
Row-Level Security
Performance Optimization
Public Sector
Operational Reporting
Production Support

Report this job

Work requirements

Jobs in Canada