Find work in Canada.

539,780 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 4 mins ago
Q
Conversation Bot Engineer - Dialogflow CX
Quantiphi
Toronto, ON
- $140,000 to $150,000 CAD / year
- Full-time
…Fortune 1000 organizations transform bold ideas into measurable business impact. We go beyond building innovative AI technologies - we solve the problems that matter most to our…
Added 4 mins ago
MC
Manager, Business Banking Credit
Meridian Credit Union
Guelph, ON
- $79,100 to $110,000 CAD / year
- Full-time
Reporting to the Director, Sales & Service, the Manager, BBC Business Banking Credit role interfaces closely with Business Banking Centre (“BBC”) management and Business Credit Department…
Added 4 mins ago
MD
Production Control Analyst - Electronic Data Processing Operations Technician 3
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
- Full-time
…critical systems running smoothly. As a Production Control Analyst with MNIT, you’ll oversee complex batch processing cycles using CA-7 and Appworx, ensuring jobs start on time, finish…
Added 4 mins ago
RS
Senior Analyst, Ecommerce & Digital
Rogers Sports & Media
Mississauga, ON
- Full-time
Senior Analyst, Ecommerce & Digital Analytics
Added 20 mins ago
Analyst, Marketing - Strategy and Business Intelligence
Reliance Home Comfort
Toronto, ON
By joining Reliance as an Analyst, Marketing - Strategy and Business Intelligence, you’ll become an important Team Member and will be provided with the tools you need to succeed. We have…
Added 20 mins ago
AP
Cash Flow & Reporting Analyst | Calgary
Aspen Properties
Calgary, AB
- Full-time
…for our team and community through ownership, management, and development…
Added 20 mins ago
N
Customer Success Technical Coordinator - Bilingual (FR/EN)
Numeris
Toronto, ON
- Full-time
required. The Coordinator also works closely with the Customer Success Insights Analyst to manage recurring,
Added 20 mins ago
MC
Manager, Business Banking Credit
Meridian Credit Union
Guelph, ON
- $79,100 to $110,000 CAD / year
- Full-time
Reporting to the Director, Sales & Service, the Manager, BBC Business Banking Credit role interfaces closely with Business Banking Centre (“BBC”) management and Business Credit Department…
Added 35 mins ago
T
Treasury Analyst, Liquidity Measurement - Analytics & Reporting
TD
Toronto, ON
- Full-time
…opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been…
Added 35 mins ago
T
Sr. Product Solution Analyst, TD Securities
TD
Toronto, ON
- Full-time
…opportunities to all colleagues. Growth opportunities and skill development are defining features of the colleague experience at TD. Our compensation policies and practices have been…
Added 35 mins ago
Business Analyst - Systems
The St. Lawrence Seaway Management Corporation
Cornwall, ON
Professional development, a wellness program, and several other benefits!
Added 50 mins ago
MD
Data Analyst - Management Analyst 3
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
- Full-time
As a Data Analyst at PERA, you will collect, validate, analyze, and report on data used across the organization to support business operations, strategic planning, and decision-making. This…
Added 50 mins ago
Instructional Design Specialist
Government of Alberta
AB
…provides strategic leadership for the ongoing enhancement and development of 1GX applications to meet the GoA’s evolving mission and continually changing business…
Added 50 mins ago
M
Senior Functional Analyst - Cross-Functional Data Integration
Maarut
Montréal-Est, QC · Montreal /Quebec, Quebec
- Contract
▸ Business analyst profile whose resume shows business
Added 50 mins ago
AI
Data Business Analyst - PL/SQL, T-SQL & Data Warehousing
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Toronto, ON
- Full-time
The business team is responsible for the creation of the L2 Model, supported by the Project Business Analyst, Solution Architect, and TSBI.
Added 50 mins ago
I-
Research Analys
IE - Career Portal
Canada
- Full-time
We are seeking a highly analytical and detail-oriented Research Analyst to conduct research, analyze data, identify trends, and generate insights that support strategic business decisions.…
Added 50 mins ago
AP
Test Analyst
Aulton Pharmaceuticals
Canada
- Full-time
We are seeking a detail-oriented and quality-focused Test Analyst to ensure the reliability, functionality, and performance of software applications. This role is responsible for designing…
Added 50 mins ago
R&
Senior Business Analyst - Finance Transformation
Robertson & Company Ltd.
Toronto, ON
- Contract
Senior Business Analyst – Finance Transformation (Oracle)
Added 50 mins ago
W
Junior Data Analys
Workpal.id
Canada
- Full-time
We are seeking a detail-oriented and analytical Junior Data Analyst to support data collection, reporting, and business intelligence initiatives. This role is ideal for recent graduates or…
Added 50 mins ago
RI
Business System Analyst- AI deliver and solution
Raas Infotek
Brampton, ON
- Contract
We are seeking a highly motivated Business Systems Analyst (BSA), AI Delivery to join the Corporate Applications AI Solution Delivery Team.
Added 1 hour ago
C
Revenue Analyst
CAPREIT
Toronto, ON
- Other
Position Summary: The Revenue Analyst closely with the Operations Team and Sr. Revenue Analyst at the Regional offices to ensure accurate rent rolls, A/R, Tenant Profiles, inclusive of…
Added 1 hour ago
B
Senior Analyst, FP&A
BRP
Montreal, QC · Greater Montreal Metropolitan Area
- Full-time
We are looking for a Senior Analyst, FP&A to support the financial modeling and planning needs of our Ecommerce business. The Senior Analyst will report to the Global Finance Manager for…
Added 1 hour ago
W
Venture Capital Analyst
Workpal.id
Canada
- Full-time
We’re looking for a highly analytical and driven Venture Capital Analyst to support our investment team across deal sourcing, market research, due diligence, and portfolio analysis. This…
Added 1 hour ago
NI
Information Security Specialist
Nityo Infotech
Toronto, ON
- Contract
SUMMARY Senior security analyst needed to develop stakeholder-driven SoD policies for IAM/RBAC audit remediation. Strong SoD expertise and business analysis skills are essential; SailPoint…
Added 1 hour ago
P
Sr. HRIS Analyst
PointClickCare
Mississauga, ON
- Full-time
…significant percentage of our revenue back into research and development, ensuring our employees have the resources to innovate and make a lasting impact. Recognized by Forbes as a top…

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