Find work in Canada.

604,752 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 3 mins ago
F
Senior Business immigration Analyst
Fragomen
ON · Ontario, Canada
- Full-time
About the Role: Fragomen’s Senior Business Immigration Analyst position will provide you with the opportunity to make an immediate impact on our business, as well as offer training,…
Added 3 mins ago
WC
Senior Analyst, Specialty Compliance and Ethics
Walmart Canada
Mississauga, ON
- Full-time
Demonstrates and encourages respect for others; drives a positive associate and customer experience for all; embraces differences in people, cultures, ideas, and experiences; supports…
Added 3 mins ago
RP
Intermediate - Senior Business Analyst
RECRUITMENT PARTNERS INC.
AB · Edmonton, AB
- Full-time
…of our team of consultants, who come with practical business experience, a strong network of professional contacts, and are focused on what is best for both clients and candidates. We will…
Added 3 mins ago
RP
Senior Data Conversion Analyst
RECRUITMENT PARTNERS INC.
AB · Edmonton, AB
- Full-time
Experience leading or coordinating data conversion workstreams, including oversight of project activities and analyst deliverables, would be highly desirable
Added 3 mins ago
OT
Analyste en modélisation et simulation électrique / Electrical Modeling and Simulation Analyst
OPAL-RT TECHNOLOGIES
Montreal, QC
- Full-time
Connaissances et expérience requises : Solides connaissances en modélisation et en dynamique des réseaux électriques, notamment en simulation électromagnétique transitoire (EMT) et dans le…
Added 3 mins ago
TI
Technical Product Owner
Tecsys Inc.
Remote, Canada
- Remote
Experience presenting to external audiences, such as user conferences, webinars or analyst briefings.
Added 33 mins ago
AS
Business Data Analyst
Apex Systems
Toronto, ON
- $65 to $70 CAD / hour
- Contract
Apex Systems is seeking a Business Data Analyst to join a leading financial services organization in Toronto. This role sits within a business process analytics team in a banking line of…
Added 33 mins ago
PB
Risk & Compliance Analyst / Auditor
Pacific Blue Cross
Burnaby, BC
- Full-time
We're looking for an experienced Risk & Compliance Analyst / Auditor who can help us strengthen how we identify, assess, and manage risk across Pacific Blue Cross.
Added 33 mins ago
B
Senior Financial Analyst
BGIS
Markham, ON
- Full-time
The Senior Financial Analyst provides complex transactional support for a process within a full accounting cycle and is involved in full accounting cycle for a client contract (s) or…
Added 33 mins ago
FH
Senior Business Analyst
Fraser Health
Surrey, BC
- Full-time
We are hiring a Relief Full Time Senior Business Analyst to join our team in Surrey, B.C.
Added 48 mins ago
TH
Replenishment Analyst
The Home Depot
Canada
- Full-time
The Replenishment Analyst has responsibility for the tactical execution of category replenishment strategy, providing a high level of service to its Merchandising, Store Operations and…
Added 48 mins ago
AC
Marketing Manager - Cargo
Air Canada
Toronto, ON · Dorval, QC
- Full-time
Demonstrated experience developing and executing integrated marketing and brand strategies, campaigns, and programs across multiple channels and customer touchpoints.
Added 1 hour 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 1 hour ago
C(
Compliance Analyst
Clarity (formerly Hiive)
Vancouver, BC
- Full-time
As a Compliance Analyst at Clarity, you will support the day-to-day work that keeps our broker-dealer and investment adviser compliant. You will start with defined, process-driven tasks and…
Added 1 hour ago
IS
Business Intelligence Specialist
Irving Shipbuilding
Dartmouth, NS
- Full-time
2 to 5 years of experience in a business intelligence or data analyst role, ideally within the manufacturing sector.
Added 1 hour ago
BI
Bilingual BMO Insurance Service Centre Analyst
BMO Insurance
Toronto, ON
- Full-time
The Bilingual BMO Insurance Service Center (BISC) Analyst will play a key role in supporting the bank's purpose of "Boldly Grow the Good in Business and Life.” As an integral member of the…
Added 1 hour ago
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 1 hour ago
HT
Senior Financial Analyst - Corporate Accounting
Husky Technologies
Bolton, ON
- Full-time
Title: Senior Financial Analyst - Corporate Accounting
Added 1 hour ago
B
Bilingual BMO Insurance Service Centre Analyst
BMO
Toronto, ON · YNG
- Full-time
The Bilingual BMO Insurance Service Center (BISC) Analyst will play a key role in supporting the bank's purpose of "Boldly Grow the Good in Business and Life.” As an integral member of the…
Added 1 hour ago
Entry-Level Finance Analyst - Kiewit Nuclear Canada
Kiewit
Oakville, ON
The Financial Analyst is an entry level role focused on supporting a project in accounting and finance related functions. Each project at Kiewit is run like a small business, with the…
Added 1 hour ago
LD
Ecommerce Data Insights Analyst
London Drugs Limited
Richmond, BC
- $33.18 to $34.89 CAD / hour
- Other
…operated retailers, we're committed to delivering exceptional customer experiences across both our stores and digital channels. Our teams work collaboratively to solve problems, drive…
Added 1 hour ago
C
Compliance Analyst
Clarity
Vancouver, BC
- $75,000 to $100,000 CAD / year
- Full-time
As a Compliance Analyst at Clarity, you will support the day-to-day work that keeps our broker-dealer and investment adviser compliant. You will start with defined, process-driven tasks and…
Added 1 hour ago
S
Application System Analyst ( 6 months contract )
Sobeys
AB · Greater Edmonton Metropolitan Area
- Contract
…have a 6 months contract opportunity for a Application System Analyst. This role can be based out of one of our main offices including: Stellarton, NS, Dartmouth, NS, Mississauga, ON,…
Added 1 hour ago
VB
Credit and Collections Analyst
Vaco by Highspring
Waterloo, ON
- $65,000 to $70,000 CAD / year
- Full-time
Manage a portfolio of customer accounts, ensuring compliance with credit policies and proactive risk management.
Added 1 hour ago
AE
Senior Demand Forecast Analyst - NAM
Arc'teryx Equipment
North Vancouver, BC
- Full-time
…drives aligned decisions that support growth, profitability, and customer experience across Demand Planning, Inventory Planning, and…

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: Dec 5, 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 source-to-target data flows, document business transformation rules, and develop technical designs and mappings for L2/L3 data models. Coordinate with business, architecture, data science, and IT teams to support data pipeline integration, data governance, data quality, and project delivery.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization skills, and expertise in data modeling, data warehousing, ETL, and source-to-target mapping. Candidates should have experience gathering requirements, facilitating stakeholder workshops, analyzing and profiling legacy data, and producing technical documentation for large-scale data initiatives.

Skills

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

Visa sponsorship

Not detected in the job text

Keywords

PL/SQL
T-SQL
SQL
Query Optimization
Data Modeling
Data Warehousing
ETL
Source-to-Target Mapping
Data Movement Model
L2/L3 Data Models
Legacy Systems
Data Analysis
Data Profiling
Business Analysis
Solution Architecture
Functional Architecture
Requirements Gathering
Stakeholder Workshops
Business Transformation Rules
Surrogate Keys
Reference Data
Data Governance
Data Quality
MS Visio
Sybase PowerDesigner
Amazon AWS
Banking Data
Enterprise Data Warehouse
ignio AIOps
TSBI

Report this job