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 just now
WS
Senior Finance Analyst, Operations Finance & Analytics
Wolf Steel Ltd
Barrie, ON
- Full-time
Napoleon leads the way with innovative engineering, advanced manufacturing techniques, unsurpassed customer service and remarkable product quality. Our award-winning products offer a…
Added just now
HT
Master Data Mgmt Analyst
Husky Technologies
Bolton, ON
- Full-time
Husky TechnologiesTM a company with a strong foundation built on innovation, close customer relationships, a strong sense of community and a unique culture and values. We are looking for…
Added just now
ST
Senior Financial Analyst
Securitas Technology Canada
Montreal, QC · Greater Montreal Metropolitan Area
- Full-time
We are seeking a highly driven and experienced Senior Financial Analyst to join our Finance team. This role is ideal for someone who thrives in a fast-paced, dynamic environment, takes…
Added 1 min ago
FI
Junior Data Analyst
Fleetway Inc.
Halifax, NS
- Full-time
As a Jr. Data Analyst (Crewing), you will support the development of reliable data assets that help teams make informed decisions, improve processes, and solve complex business challenges.…
Added 30 mins ago
TS
TDS Operations Analyst III
TD Securities
Toronto, ON
- Full-time
…and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary…
Added 30 mins ago
TS
TDS Operations Analyst II
TD Securities
Toronto, ON
- Full-time
…and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary…
Added 30 mins ago
T
Fraud Detection Analyst
Tangerine
Toronto, ON
- Full-time
You have customer service experience, preferably within the financial services industry.
Added 30 mins ago
MC
Data Analyst – Power BI Microsoft Fabric (35903)
Myticas Consulting
Ottawa, ON
- Full-time
This is an excellent opportunity for a junior-to-mid-level Data Analyst with strong Power BI, SQL and Microsoft data technologies experience who enjoys turning data into meaningful…
Added 30 mins ago
C
Développeur Microsoft Dynamics 365 CE / Power Platform
CGI
Montreal, QC
- Full-time
Minimum of 2 years of experience as a business analyst, designer, or developer
Added 46 mins ago
AM
Sr. Business Planning Analyst
Advanced Micro Devices, Inc
Markham, ON
- Full-time
AMD is seeking a Business Analyst with an engineering background to support the Memory Business Unit, a dynamic organization responsible for managing critical technical commodities across…
Added 1 hour ago
T
Application Analyst
ThoughtStorm
AB · Alberta, Canada
- Contract
…an experienced C, PowerBuilder and Sybase application system analyst, that preferably has experience with Oil and Gas…
Added 1 hour ago
PV
Treasury Analyst
Pet Valu
Markham, ON
- Full-time
The Treasury Analyst reports to the Manager, Treasury and plays a key role in the various aspects of Treasury including cash management activities, bank account management, month end…
Added 1 hour ago
C
Analyst, Client Onboarding & Service
CIBC
Winnipeg, MB · Regina, SK
- Full-time
As an Analyst in the Client Onboarding & Service team, your primary focus will involve supporting clients within your portfolio on all day-to-day service and support requests. You will be…
Added 1 hour ago
IT Operations & CMDB Analyst
Purolator
ON · Mississauga, ON
The IT Operations & Configuration Management Database (CMDB) Analyst is responsible for ensuring the integrity and governance of the ServiceNow CMDB while supporting operational excellence…
Added 1 hour ago
B
Director, FP&A (Revenue)
Benevity
Remote, Canada
- Full-time
- Remote
…a team that includes a Revenue Operations group and an FP&A analyst who owns accounting and reporting for…
Added 1 hour ago
B
Director, FP&A (Revenue)
Benevity
Remote, Canada
- $156,800 to $206,750 CAD / year
- Full-time
- Remote
…a team that includes a Revenue Operations group and an FP&A analyst who owns accounting and reporting for…
Added 1 hour ago
T
Cyber Security Intern/Co-op (Winter 2027)
TD
Mississauga, ON · Toronto, ON
- Full-time
…and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been designed to allow colleagues to progress through the salary…
Added 1 hour ago
M
Senior Analyst, Project Finance & Infrastructure Ratings
Morningstar
Toronto, ON
- Full-time
Morningstar DBRS is seeking a Senior Analyst to join its Project Finance & Infrastructure team in Toronto. This role offers an opportunity to contribute to credit ratings and research…
Added 1 hour ago
PI
IT Operations & CMDB Analyst
Purolator Inc.
Mississauga, ON
- Full-time
The IT Operations & Configuration Management Database (CMDB) Analyst is responsible for ensuring the integrity and governance of the ServiceNow CMDB while supporting operational excellence…
Added 1 hour ago
AG
SAP MM/EWM Support Analyst
Addmore Group
Calgary, AB
- Contract
We are seeking an experienced SAP MM / EWM Support Analyst with Coupa Procurement experience for a contract opportunity. The successful candidate will support SAP supply chain and…
Added 1 hour ago
RI
Pricing & Sales Analyst
Richardson International
Winnipeg, MB
- Full-time
…possibility. We currently have an opportunity for a Pricing & Sales Analyst in our Winnipeg office. The Pricing & Sales Analyst will be responsible for supporting the sales team in…
Added 1 hour ago
M
Winter Co-Op 2027 - Taxation Analyst
Manulife
Waterloo, ON
- Full-time
At Manulife John Hancock, we believe in investing in the future – starting with you. Our Taxation Analyst Winter Co-op is an opportunity to gain hands-on experience within our Canadian Tax…
Added 1 hour ago
CI
Accounting Assistant (Part-Time)
Candor Industrial Supply, Inc.
ON · Ontario, Canada
- $16 to $22 USD / hour
- Part-time
Experience: Previous experience in office administration, customer service, or basic bookkeeping is a plus, but not required.
Added 2 hours ago
Senior IT Business Systems Analyst
The Canada Life Assurance Company
Winnipeg, MB · London, ON · Toronto, ON
We are hiring a Senior IT Business Systems Analyst. This is a hybrid role located in London, Toronto or Winnipeg.
Added 2 hours ago
ML
Sr. Finance Analyst - Fixed Assets (Contract)
Maple Leaf Foods Inc
Mississauga, ON
- $71,000 to $103,000 CAD / year
- Contract
As a member of the fixed assets team the Senior Finance Analyst, Fixed Assets will report to the Manager, Finance - Fixed Assets. The individual will play a key role in the reporting,…

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