Jobs in Canada

Group jobs by employerEmail me new jobs Save this search

Added 18 days ago
IF
Senior Actuarial Advisor, Life Insurance
iA Financial Group
Montreal, QC · Quebec, QC
- Full-time
Has experience working with tools such as AXIS and Excel; knowledge of SQL and Python is considered an asset;
Added 18 days ago
TI
Python Backend Developer
Tekgence Inc
Toronto, ON
- Full-time
Java and Python, we are seeking a skilled Backend Developer with 5 to 8 years of experience in designing, developing, and maintaining scalable backend applications. The ideal candidate will…
Added 18 days ago
S
Technology Manager
Stellantis
Mississauga, ON
- Full-time
Develop and enhance Warehouse Management Systems using SQL/Java/http programming
Added 18 days ago
ES
Python Full Stack Developer – GenAI
Enterprise Solutions Inc.
Montreal, QC
- Contract
We are seeking an experienced Full Stack Developer with strong Python development skills, React experience, and exposure to Generative AI technologies. The ideal candidate will build…
Added 18 days ago
M
RQ00795 - Software Developer - Senior
Maarut
Toronto, ON
- Contract
Visual Studio .NET development with MVC, SQL Server. 40 points
Added 18 days ago
M
RQ00812 - Business Intelligence Specialist - Oracle - Senior
Maarut
Toronto, ON
- 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 18 days ago
M
Full Stack Developer contractor contigent req for Deepak Nangia
MDA
Brampton, ON
- Full-time
o Angular (must have)
Added 18 days ago
NB
Corporate Finance Internships
National Bank of Canada
Montreal, QC
- Full-time
Programming knowledge, e.g. Python, SQL or VBA.
Added 18 days ago
GC
AI Engineer
GEI Consultants, Inc.
Kitchener, ON
- $110,000 to $150,000 CAD / year
- Full-time
Proficiency in at least one programming language such as Python, PySpark, R, or SQL.
Added 18 days ago
P
Senior Software Engineer - Java
PointClickCare
Mississauga, ON
- $142,000 to $158,000 CAD / year
- 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 19 days ago
S
Solutions Architect
Sigmoid
Toronto, ON
- Full-time
…open source. Some of the world’s largest data producers engage with Sigmoid to solve complex business problems. Sigmoid brings deep expertise in data engineering, predictive analytics,…
Added 19 days ago
Ads Threat Intelligence
Google
Waterloo, ON
Experience with programming languages such as Python, Go, C++, or Java.
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
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Must have Class 5 driver’s license
Added 19 days ago
J
Actuary
Jobgether
Canada
- $115,000 to $145,000 CAD / year
- Full-time
Technical skills: Strong analytical, mathematical, and quantitative abilities, with advanced proficiency in SQL and Microsoft Excel. Experience with R and/or Python is highly desirable.
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
J
Actuary
Jobgether
Canada
- $115,000 to $145,000 CAD / year
- Full-time
Technical skills: Strong analytical, mathematical, and quantitative abilities, with advanced proficiency in SQL and Microsoft Excel. Experience with R and/or Python is highly desirable.
Added 19 days ago
T
Manager - Stress Testing Data, Controls and Analytics
TD
Toronto, ON
- Full-time
· Use Python, SQL and Databricks notebooks to profile data, validate transformations, reconcile outputs, automate repeatable analysis and support production readiness.
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
…work alongside our senior DBA. You’ll help write and optimize SQL queries, monitor database performance, and support the day-to-day work that keeps our databases secure and reliable,…
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
E
Co op Agentic AI Development
Ericsson
Ottawa, ON
- Full-time
Strong scripting and automation background (Python, Bash, SQL)
Added 19 days ago
C
AI Product and Automation Tool Developer
Croesus
Montreal, QC · Laval, QC
- Full-time
…partners, and employees and to positively impact the community. With more than 200 employees in its Montréal, Toronto, and Geneva offices, Croesus has won several industry awards for being…

Maarut

RQ00812 - Business Intelligence Specialist - Oracle - Senior

Toronto, ON, Canada

Contract

Apply on maarutinc.zohorecruit.com About employer

Applications open in a new tab.

Job details

Job type: Contract
Posting language: English
Posted: Oct 22, 2026

Original job description

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

Requirements

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, demonstrations, defect fixes, release support, and knowledge-transfer materials.

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.

Apply on maarutinc.zohorecruit.com 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 loads, reconciliation, and production monitoring. Design governed dimensional reporting models and Power BI dashboards, define healthcare metrics using Ontario HRM, FHIR, and HL7 v2 data, and provide technical documentation and operational support.

Requirements

Requires 10+ years of experience and strong hands-on expertise in Oracle, Python, AWS Glue Python Shell, AWS DMS, Amazon Redshift, dimensional modeling, and Power BI. Healthcare data experience interpreting the Ontario HRM Standard, FHIR, and HL7 v2 structures is also required, along with data validation, reconciliation, performance tuning, and production support.

Skills

Oracle
SQL
PL/SQL
Python
AWS Glue
AWS DMS
Amazon Redshift
Dimensional Modeling
ETL
Power BI
DAX
Power Query
Healthcare Data
FHIR
HL7 v2
Data Quality

Visa sponsorship

Not detected in the job text

Keywords

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

Report this job

Work requirements

Jobs in Canada