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 31 mins ago
C
Apps Dev Intmd Programmer Analyst
Citi
Mississauga, ON
- Full-time
Drive Global Impact: Be part of a team building a mission-critical system that will streamline and automate key operational workflows across the firm, directly impacting business efficiency.
Added 31 mins ago
C
Apps Dev Intmd Programmer Analyst
Citi
Mississauga, ON
- Full-time
Address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks.
Added 31 mins ago
JI
Junior Data Analyst
J.D. Irving, Limited
NS · Dartmouth, 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 31 mins ago
C
Project Analyst Co-op- Winter 2027
CIBC
Toronto, ON
- Full-time
You’ll join CIBC’s Enterprise Project Office (EPO), part of the Planning, Analytics and Platform team, where we support enterprise project and portfolio management through data, insights,…
Added 31 mins ago
Senior Analyst, NAV Solutions and Oversight (18-Month Contract)
Scotiabank
Toronto, ON
o Provide detailed reporting and analytics to SGAM NAV Solutions, portfolio managers, and business partners.
Added 46 mins ago
DI
Business Systems Analyst-Guidewire
Definity Insurance Company
Toronto, ON
- Full-time
This role is responsible for bridging business and technology teams by gathering, analyzing, and translating business requirements into clear user stories, acceptance criteria, and…
Added 1 hour ago
Financial Analyst - Team Lead
City of Edmonton
AB
…Infrastructure Services department is seeking a collaborative Financial Analyst - Team Lead to guide a dedicated team responsible for project setup and financial transaction processing. In…
Added 1 hour ago
RB
Equity Derivative Operations Analyst
Royal Bank of Canada
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 1 hour ago
M
Talent & Rewards Consulting Analyst
Mercer
Toronto, ON
- Other
As a Compensation Analyst in the Workforce and Rewards practice, you will work with a broad range of clients and industries in a stimulating environment, participating as an integral member…
Added 1 hour ago
SV
Financial Analyst
Starshot Ventures
Toronto, ON
- Full-time
Review recurring and memorized QuickBooks reports to confirm direct project costs are allocated to the correct customer and job, and operating expenses to the correct GL accounts.
Added 1 hour ago
SI
Quality Assurance Analyst
Spait Infotech
Canada
- Full-time
Collaborate with developers, business analysts, and project managers to resolve defects.
Added 1 hour ago
Q
Senior GRC Analyst
Quantexa
Ottawa, ON
- $116,000 to $146,000 CAD / year
- Full-time
Quantexa is looking for an experienced Senior GRC Analyst to support our growing business. This role will be based in Toronto/Ottawa and will require travel to customer sites and other…
Added 1 hour 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 1 hour 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 1 hour ago
Q
Senior GRC Analyst
Quantexa
Toronto, ON
- $116,000 to $146,000 CAD / year
- Full-time
Quantexa is looking for an experienced Senior GRC Analyst to support our growing business. This role will be based in Toronto/Ottawa and will require travel to customer sites and other…
Added 1 hour 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 1 hour ago
GR
Customer Success Operations Analyst
Global Relay
Vancouver, BC
- Full-time
The Customer Success Operations Analyst plays a vital role in ensuring the seamless transition of data, applications, and systems across data archiving platforms. This position requires…
Added 1 hour ago
Information Systems Analyst
Hatch
Mississauga, ON
The Project Information Management group is seeking an Information Management Analyst new graduate with interests in Technology & Innovation, Digital Delivery and Advanced Data Management.…
Added 1 hour ago
E
Business Analyst Specialist I - Marketing & Risk Management
Enbridge
Calgary, AB
- Full-time
Bring five or more years of progressive experience in IT support, systems analysis, business analysis, demand management, project coordination, or technology delivery.
Added 1 hour 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 2 hours ago
R|
Clinical Trial Financial Control Analyst, Oncology Portfolio
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Full-time
We are seeking a Clinical Trial Financial Control Analyst to provide independent financial control and reconciliation for Oncology-sponsored clinical research studies. Reporting within the…
Added 2 hours ago
TG
Process Analyst Student Intern
TMX Group
Toronto, ON
- $20 to $23 CAD / hour
- Full-time
The TMX Project Management Office (PMO) enables and supports the successful delivery of business value. This is done by partnering with Clusters, Squads, Shared Services, Corporate…
Added 2 hours ago
XS
Security Analyst / Engineer / Architect
XChange Software Inc
Mississauga, ON
- Contract
· Influence technology and business stakeholders at director and executive levels.
Added 2 hours ago
RI
Senior Business Analyst
Raas Infotek
AB · Edmonton, AB
- Contract
Minimum five (5) years of experience in a Business Analyst role.
Added 2 hours ago
PC
Accounting Analyst, Master Data New Grad
PETRONAS Canada
Calgary, AB
- Full-time
We have an exciting opportunity for an early-career Accounting Analyst to join the Master Data Management and Capital Accounting team in Calgary. Reporting to the Team Lead, Master Data &…

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