Find work in Canada.

545,929 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 5 mins ago
MC
Embedded Software Architect, User Terminals (36137)
Myticas Consulting
Ottawa, ON
- Full-time
We are seeking a Software Architect – User Terminals to define and lead software architecture for military and government satellite communications terminal solutions. This role provides…
Added 20 mins ago
A
Firmware Engineer
Actalent
Montreal, QC
- $45 to $60 CAD / hour
- Contract
Implanter des solutions en C embarqué bare metal et, au besoin, des conceptions basées sur un RTOS.
Added 20 mins ago
RI
Senior Full Stack Java Developer - Capital Markets
Rose International
Mississauga, ON
- Full-time
Prior experience as a Forward Deployed Engineer, Solutions Architect, or Technical Consultant embedded within financial institutions.
Added 20 mins ago
W
Security Specialist – Security Architect
Workiy
Edenwold No. 158, SK · Regina East, Saskatchewan
- Contract
We are seeking for a seasoned Senior Security Specialist / Security Architect to join their Intelligent Networks & Infrastructure team. In this role, you will combine high-level security…
Added 20 mins ago
A
Microelectronics Process Engineer
Actalent
Ottawa, ON · Kanata, ON
- $110,000 to $160,000 CAD / year
- Full-time
Own key processes end to end, acting as a process architect by allocating process elements to be developed and maintained across the team.
Added 20 mins ago
AP
Tech Lead
Accommodations Plus International
Markham, ON
- $130,000 to $140,000 CAD / year
- Full-time
…initiatives. This is a senior, hands-on role: you’ll help set technical direction and architect solutions while staying technically involved yourself. You’ll also bring strong, practical AI…
Added 20 mins ago
S
Product Manager - SOTI MobiControl
SOTI
Mississauga, ON
- $110,000 to $130,000 CAD / year
- Full-time
Prior experience as a software developer, engineer, solutions architect or similar hands on role is a strong plus.
Added 20 mins ago
S
Account Development Representative II
Samsara
Ottawa, ON · Kanata, ON
- Full-time
…and be on a team that’s shaping an exciting array of product solutions, including Video-Based Safety, Vehicle Telematics, Apps and Driver Workflows, and Equipment Monitoring. As part of a…
Added 20 mins ago
S
Account Development Representative II
Samsara
Calgary, AB
- Full-time
…and be on a team that’s shaping an exciting array of product solutions, including Video-Based Safety, Vehicle Telematics, Apps and Driver Workflows, and Equipment Monitoring. As part of a…
Added 20 mins ago
S
Account Development Representative II
Samsara
Ottawa, ON
- Full-time
…and be on a team that’s shaping an exciting array of product solutions, including Video-Based Safety, Vehicle Telematics, Apps and Driver Workflows, and Equipment Monitoring. As part of a…
Added 20 mins ago
S
Account Development Representative II
Samsara
Quebec, QC
- Full-time
…and be on a team that’s shaping an exciting array of product solutions, including Video-Based Safety, Vehicle Telematics, Apps and Driver Workflows, and Equipment Monitoring. As part of a…
Added 35 mins ago
C
Customer Delivery Architect
Cisco
Montreal, QC
- Full-time
We partner with customers, sales teams, and engineering groups to deliver comprehensive solutions. We work alongside internal and external partners to deploy Cisco services, maintaining…
Added 35 mins ago
DC
Junior/Intermediate Architect
Dillon Consulting Limited
Ottawa, ON
- Full-time
We are currently seeking a Junior to Intermediate Architect to join our Architectural technical group in Ottawa. In this role, you will collaborate with a multidisciplinary team of…
Added 50 mins ago
B
Security Architect
BuzzClan
Regina, SK
- Contract
Provide security specialist/architect expertise with operational experience to advise and support Operations in addressing identified security gaps. The resource will help contextualize and…
Added 50 mins ago
AI
Service Delivery Manager (French)
Apptoza Inc.
Montreal, QC
- Full-time
Microsoft Certified: Azure Solutions Architect Expert.
Added 1 hour ago
AP
Full Stack Team Lead
Accommodations Plus International
Markham, ON
- $130,000 to $140,000 CAD / year
…initiatives. This is a senior, hands-on role: you’ll help set technical direction and architect solutions while staying technically involved yourself. You’ll also bring strong, practical AI…
Added 1 hour ago
AW
Senior DevSecOps Engineer
Aviso Wealth
Remote, Canada
- $120,000 to $135,000 CAD / year
- Full-time
- Remote
…Engineer Professional/Expert, Azure Administrator Associate, Azure Solutions Architect Expert, or equivalent cloud/DevSecOps…
Added 1 hour ago
D
Senior Salesforce Developer
Docebo
Remote, Canada
- $90,800 to $121,000 CAD / year
- Full-time
- Remote
Design and build. Deliver production-quality solutions in Apex, Lightning Web Components, Flow and platform configuration, from a clear problem statement through solution design, build,…
Added 1 hour ago
CB
Senior Java Developer
Conduent Business Services Canada, Inc.
Canada
- Full-time
- Other
Provide support to Product Management/Solutions Architect during project estimation as needed
Added 1 hour ago
BR
Senior Applications Architect
BITS Recruiting
Toronto, ON
- $110 to $120 CAD / hour
- Contract
We are seeking an experienced Senior Applications Architect to lead the design and implementation of enterprise application architecture solutions within a large, complex technology…
Added 1 hour ago
H
Senior Architect
Hays
Toronto, ON
- $80 to $90 CAD / hour
- Contract
We are seeking an experienced Azure AI Architect to lead the design and architecture of enterprise-scale Artificial Intelligence (AI) and Generative AI solutions on Microsoft Azure. This…
Added 1 hour ago
H
Cloud Architect
Hays
Toronto, ON
- Contract
We are seeking a Senior Azure AI Architect to lead the architecture and design of enterprise-scale AI and Generative AI solutions on Microsoft Azure.
Added 1 hour ago
FS
Security Professional
Focus Systems Inc.
Regina, SK
- Contract
The Security Specialist - Security Architect (Intermediate) will identify security gaps in current and proposed architectures, prioritize improvements based on existing controls and…
Added 1 hour ago
FS
Salesforce Consultant
Futran Solutions
Toronto, ON
- Full-time
Architect and design robust and scalable Salesforce Data Cloud solutions based on client requirements and industry best practices.
Added 1 hour ago
PI
Security Professional
Pantheon Inc
Regina, SK
- Full-time
We are looking for an experienced Security Solution Architect / Specialist to support Operations teams in identifying and addressing infrastructure security gaps. The role involves…

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!

Data Business Analyst - PL/SQL, T-SQL & Data Warehousing

Toronto, ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Nov 27, 2026
Experience: Years of Experience: 8–10 years
Posting language: English
Posted: Oct 28, 2026

Original job description

Data Business Analyst - PL/SQL, T-SQL & Data Warehousing

Location: Toronto, ON
Work Arrangement: Hybrid (2 days per week in-person at Toronto office preferred)
Years of Experience: 8–10 years
Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps

Job Responsibilities

1. Analysis of Legacy Systems

For each use case, analyze the mapping document of target tables to determine operational objectives by studying business functions, gathering information, and evaluating output requirements.
Track the target field mapping back to the original data element in the source system.
Strong knowledge of SQL to perform data analysis and data profiling on different legacy systems.
Document the existing source-to-target data flow for each table, including:
- Business transformation rules applied.
- Key-cutting implemented to identify surrogate keys defined as unique identifiers in a table.
- Reference data used to enhance the context and validity of target data elements.
For tables where mapping documentation is not available, TSBI and ETL leads must jointly review the code to extract business rules and capture them in the requirements document.

2. L2/L3 Model

The business team is responsible for the creation of the L2 Model, supported by the Project Business Analyst, Solution Architect, and TSBI.
Collaborate with data scientists, business analysts, and IT teams to integrate advanced L2/L3 models into the data pipeline.

3. Mapping Design of New L2/L3

Prepare technical design and mapping (Data Movement Model) for the new L2 Model by working with Project Business Analysts and Solution Architects.
Review the key-cutting process to be implemented on the L2 model and obtain approval from L2 Schema Owners.
Only BORT system data will be populated into the L2 schema; other reference and tactical data will be directly consumed by L3 processes.
L2-to-L3 mapping will contain business transformation rules for each target table.
A custom surrogate key process will be implemented on L3 tables, which will contain different keys than L2 tables.
Any system with one-off tables holding business data will be loaded into the L3 schema for target table processing.
Spearhead the implementation of robust data governance policies and procedures, ensuring compliance with industry regulations and standards, resulting in a 20% reduction in data security incidents.
Collaborate with cross-functional teams to design and implement data quality frameworks, improving data accuracy and integrity while reducing errors.

Role and Responsibilities

Determine operational objectives by studying business functions, gathering information, and evaluating output requirements and formats.
Design solutions, analyze requirements, and design modifications.
Define project requirements by identifying project milestones, phases, and elements, and forming project teams.
Monitor project progress by tracking activities, resolving problems, publishing progress reports, and recommending actions.
Provide references for users by writing and maintaining mapping documentation.
Maintain user confidence and protect operations by keeping information confidential.
Prepare technical design and mapping through data collection, analysis, and profiling.
Maintain professional and technical knowledge through workshops and continuous learning.
Work with business and technology teams to fulfill data requirements.
Prepare data models and technical design documentation according to standards.
Assess intake requests for new projects and change requests.
Strong knowledge of SQL and analysis of data from different product systems.

5 Mandatory Must-Have Skills and Experience

Strong PL/SQL and T-SQL development and query optimization skills.

Experience in Data Modelling using industry-standard modeling tools, Gap Analysis, and MS Visio.

Strong understanding of Data Warehousing concepts, ETL processes, and source-to-target data mapping.

Proven experience conducting requirement-gathering sessions and stakeholder workshops across business and technology teams.

Experience in data analysis, data profiling, legacy system analysis, and technical documentation within large-scale data initiatives.

5 Nice-to-Have Skills and Experience

Knowledge of banking domain data, including customer, account, and transaction data.

Experience with Sybase PowerDesigner for data modeling.

Knowledge of cloud technologies such as Amazon AWS.

Familiarity with data governance and data quality frameworks.

Experience supporting L2/L3 data models and enterprise data warehouse environments.

Apply About employer

More about this job

Responsibilities

Analyze legacy systems and data flows, document source-to-target mappings and business transformation rules, and design technical mappings for L2/L3 data models. Collaborate with business, architecture, data science, and IT teams to define requirements, monitor project progress, and improve data governance and quality.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization skills, and experience with data modeling, data warehousing, ETL, and source-to-target mapping. Candidates must also have experience gathering requirements, facilitating stakeholder workshops, analyzing and profiling legacy-system data, and producing technical documentation.

Skills

PL/SQL
T-SQL
SQL Query Optimization
Data Modeling
Data Warehousing
ETL
Source-to-Target Data Mapping
Business Analysis
Data Analysis
Data Profiling
Legacy System Analysis
Requirements Gathering
Stakeholder Workshops
Data Governance
Data Quality
MS Visio

Visa sponsorship

Not detected in the job text

Keywords

PL/SQL
T-SQL
SQL
Data Warehousing
ETL
Data Modeling
Source-to-Target Mapping
Data Movement Model
L2/L3 Data Models
Legacy Systems
Data Analysis
Data Profiling
Business Transformation Rules
Surrogate Keys
Reference Data
Data Governance
Data Quality Frameworks
Requirements Gathering
Stakeholder Workshops
Gap Analysis
MS Visio
Sybase PowerDesigner
Amazon AWS
Banking Data
Customer Data
Account Data
Transaction Data
Solution Architecture
ignio AIOps
BORT

Report this job