Find work in Canada.

A simpler way to find your next job.

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 9 mins ago
EC
Accounting Analyst - Hybrid
Encore Canada
Brampton, ON
- Full-time
The Accounting Analyst plays a key role in supporting the accuracy, integrity, and timely reporting of financial information for Encore Canada. Reporting to the Controller, this position is…
Added 9 mins ago
SV
Financial Analyst
Starshot Ventures
Toronto, ON
- Full-time
Added 9 mins ago
R
Equity Derivative Operations Analyst
RBC
Toronto, ON
- Full-time
As an Equity Derivatives Operations Analyst, you will ensure the timely and accurate completion of the primary responsibilities detailed below to support Equity Derivatives Businesses…
Added 24 mins ago
CT
Senior BI Analyst
Canadian Tire Corporation
Oakville, ON · Toronto, ON
- Full-time
As a Senior BI Analyst, you will play a key role in transforming data into actionable business insights. You will work across the full analytics lifecycle, partnering with business…
Added 24 mins ago
AL
Contract & Sales Analyst
Air Liquide
Calgary, AB · AB · Coquitlam, BC · Richmond, BC · Winnipeg, MB
- Full-time
Air Liquide Canada is seeking a Contract & Sales Analyst to join our team, specifically supporting the Life Sciences division with a focus on Healthcare / Medical Gases.
Added 39 mins ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Under the direction of the designated IT Manager, the Application and Integration Technical Analyst is a technical lead responsible for system architecture, data strategy, and integration…
Added 39 mins ago
SG
FIC Font Office Dev Analyst
Societe Generale
Montreal, QC
- Full-time
Added 39 mins ago
KL
Specialized Information Technology Analyst (Infrastructure)
Kativik llisarniliriniq
Montreal, QC
- Full-time
Under the supervision of the Computer Systems Coordinator, the Specialized Information Technology Analyst is responsible for analyzing, implementing, coordinating, and managing projects…
Added 39 mins ago
S
Senior Security Analyst
SAP
Toronto, ON
- Full-time
Added 39 mins ago
HT
Master Data Mgmt Analyst
Husky Technologies
Bolton, ON
- Full-time
Added 39 mins ago
GR
Customer Success Operations Analyst
Global Relay
Vancouver, BC
- Full-time
Added 39 mins ago
D&
Financial Analyst, Commercial FP&A
Day & Ross
Somerville, NB
- Full-time
…revenue strategy and financial rigour. As a Commercial Finance Analyst, you will serve as the financial partner to our sales organisation - translating pipeline activity, customer wins and…
Added 39 mins ago
Information Systems Analyst
Hatch
Mississauga, ON
…better world through positive change. With more than 70 years of business and technical expertise in mining, energy, and infrastructure, our 10,000 colleagues in 150 countries tirelessly…
Added 39 mins ago
E
Business Analyst Specialist I - Marketing & Risk Management
Enbridge
Calgary, AB
- Full-time
In this role, you will join the Enterprise Marketing and Risk Management systems team and serve as a trusted partner to business stakeholders, providing systems analysis, application…
Added 39 mins ago
M
RQ11656 - Systems Testing/QA Specialist - Senior
Maarut
Toronto, ON
- Contract
Sr Quality Assurance(QA) Analyst, is responsible for overseeing and managing the quality assurance (QA) processes for both manual and automated testing efforts. This role involves leading a…
Added 54 mins ago
MF
AI Automation & Platform Analyst (Senior Analyst)
Mackenzie Financial Corporation
Toronto, ON · Greater Toronto Area, ON
- Other
Mackenzie Investments, founded in 1967, is a key part of IGM's business model, serving as a comprehensive asset-management partner for Canadian f
Added 1 hour ago
R-
Allocation Analyst
RCL - Reitmans Canada Ltd/Ltée
Montreal, QC
- Full-time
Added 1 hour ago
T
Fraud Detection Analyst
Tangerine
Toronto, ON
- Full-time
Added 1 hour ago
TG
Process Analyst Student Intern
TMX Group
Toronto, ON
- $20 to $23 CAD / hour
- Full-time
Added 1 hour ago
QM
Senior Analyst, Capital Markets Operations
Quantum Management Services Ltd.
Toronto, ON
- $40 CAD / hour
- Contract
Position: Senior Analyst, Capital Markets Operations
Added 1 hour ago
R|
Accounts Receivable Analyst
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Full-time
Added 1 hour ago
RI
Senior Business Analyst
Raas Infotek
AB · Edmonton, AB
- Contract
Discovery/Design Sessions – Supporting EPCOR and the Systems Integrator as we embark on 700+ global design workshops in 2027 to form our foundation prior to starting the phased project.
Added 1 hour ago
B
Contract Payroll Analyst
Brunel
Calgary, AB
- $43 to $53 CAD / hour
- Contract
Brunel is currently seeking a Contract Payroll Analyst to support a Human Resources team in Calgary. Reporting to the Payroll Manager, you will bring a strong payroll background and help…
Added 1 hour ago
R
Payroll Analyst
Raise
Calgary, AB
- Contract
Raise is currently hiring a Payroll Analyst on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader.…
Added 1 hour ago
PC
Accounting Analyst, Master Data New Grad
PETRONAS Canada
Calgary, AB
- Full-time

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