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 19 mins ago
SM
GOAPRDJP000001055 – Application Analyst – Intermediate
S M Software Solutions Inc
AB · Edmonton, AB
- Internship
A System Analyst applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies. The focus is to ensure…
Added 19 mins ago
SM
RQ11717 – Business Analyst – Senior
S M Software Solutions Inc
Toronto, ON
- Internship
We are seeking a highly experienced Senior Business Analyst with over 10 years of experience in business analysis, requirements gathering, business process re-engineering, business case…
Added 1 hour ago
Senior Systems Analyst (Power Platform Developer)
Office of the Chief Information Officer
St. John's, NL
Reporting to the Design & Delivery Manager (DevOps), the Senior Systems Analyst will work within a fast-paced, dynamic environment in designing, developing, implementing, and maintaining…
Added 1 hour ago
A
Analyst, Pricing (Bangkok Based, relocation provided)
Agoda
Vancouver, BC
- Full-time
…priorities, and drive decisions to closure; Coordinate cross-functional execution across Commercial, Product, Data Science, Marketing, and operations…
Added 1 hour ago
NS
IMIT Business Analyst - Registration, Switchboard & Data Quality
Nova Scotia Health Authority
NS · Nova Scotia, Canada
- Full-time
Reporting to the IM/IT Business Program Manager, Registration, Switchboard & Data Quality, the IM/IT Business Analyst will be committed to a high standard of performance and is responsible…
Added 2 hours ago
TI
Technical Product Owner
Tecsys Inc.
Remote, Canada
- Remote
…customers through demos, webinars, user conference sessions and analyst…
Added 3 hours 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
Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps
Added 3 hours ago
AG
Director, Growth & Innovation Operations
Altus Group
Toronto, ON
- Full-time
…hands-on, player-coach role. You will directly lead a Senior Analyst and work with resources across the organization to strengthen accountability, improve visibility into performance, and…
Added 3 hours ago
LD
Ecommerce Data Insights Analyst
London Drugs Limited
Richmond, BC
- $33.18 to $34.89 CAD / hour
- Other
As an Ecommerce Data Insights Analyst, you'll play a key role in shaping the future of our digital business by transforming data into actionable insights that drive performance. You'll…
Added 3 hours ago
N
Enterprise Architect
Nutrien
Calgary, AB
- Full-time
Lead application portfolio assessments using functional fit, technical fit, lifecycle risk, duplication, integration complexity, strategic alignment and validated cost inputs
Added 4 hours ago
AF
Analyst, SAP
Alberta-Pacific Forest Industries Inc.
Boyle, AB
- Full-time
Alberta-Pacific Forest Industries Inc. (Al-Pac) is seeking a Analyst, SAP to work out of our Mill Site, St. Albert location near Athabasca, Alberta or our office in St. Albert, Alberta. The…
Added 4 hours ago
AF
Analyst, Applications
Alberta-Pacific Forest Industries Inc.
Boyle, AB
- Full-time
Alberta-Pacific Forest Industries Inc. (Al-Pac) is seeking a Analyst, Applications to work out of our Mill Site location near Athabasca, Alberta. The successful candidate will be…
Added 4 hours ago
R
Junior Business Analyst
Raise
Calgary, AB
- Full-time
The Junior Business Analyst (IT Performance & Observability) in this role is a key operational support role within our clients IT Performance and Observability team. Working under the…
Added 4 hours ago
RI
Application Systems Analyst (C#, .NET, Microsoft SQL Server & Agile)
Rose International
AB · Edmonton, AB
- Full-time
…application support, maintenance and enhancements. A System Analyst applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or…
Added 4 hours ago
O
Senior SAP Functional Analyst - Warehouse Management (EWM)
Olymel
Boucherville, QC
- Full-time
At Olymel, we believe in innovation, quality, and sustainable growth. We are looking for an Senior SAP Functional Analyst - Warehouse Management (EWM) to join our dynamic team. If you are…
Added 4 hours ago
TC
Systems Analyst - Enterprise Applications
The Corporation of The City of Victoria
Victoria, BC
- Other
We are seeking a Systems Analyst – Enterprise Applications to join our Workday Implementation Project Team, with a primary focus on systems integration and data conversion. In this role,…
Added 4 hours ago
CO
Associate, Strategy Analyst - New Grad 2027
Capital One
Toronto, ON
- Full-time
As a Strategy Analyst, you’ll develop and apply analytical rigour, problem solving skills and critical thinking from day one. Embedded within a cross-functional team, you’ll bring your…
Added 4 hours ago
T
Sr. IT Data Analyst
TD
Toronto, ON
- Full-time
…with Data concepts, translating business requirements into Functional specifications, Implementing Data Controls (including Data Quality and ETL controls), Investigating data issues across…
Added 4 hours ago
S
Director, Technology & Digital Transformation
Sunpan
Toronto, ON · Scarborough, Ontario
- Full-time
Own the SAP landscape strategy, working with the business analyst, functional leads and implementation partners.
Added 4 hours ago
O
Senior Product Marketing Manager
OpenText
Waterloo, ON
- Full-time
Coordinate cross-functional readiness across Product Management, enablement, campaigns, web, analyst relations, customer marketing, and field teams.
Added 4 hours ago
O
Senior Product Marketing Manager
OpenText
Richmond Hill, ON
- Full-time
Coordinate cross-functional readiness across Product Management, enablement, campaigns, web, analyst relations, customer marketing, and field teams.
Added 5 hours ago
M
Strategy Analyst
Manulife
Toronto, ON · Waterloo, ON
- Full-time
The Strategy Analyst, is a key part of the Manulife Bank Strategy, Governance and Controls team and will contribute to the successful delivery of the overall strategic mandate. This role…
Added 5 hours ago
L
Senior Analyst, PMO
LCBO
Toronto, ON
- Full-time
…and application administration and support. The Senior PMO Analyst will to ensure projects are running smoothly on budget. Additionally, you will collaborate with project team members to…
Added 5 hours ago
TI
Project & Reporting Analyst
telMAX Inc.
Markham, ON
- $20 to $25 CAD / hour
- Full-time
PROJECT AND REPORTING ANALYST CO-OPYour Position & How You Will Contribute:
Added 5 hours ago
B
Systems Analyst – Senior (Microsoft Dynamics 365 F&O / SCM/Procure-to-Pay, Order-to-Cash exp)
Bevertec
Toronto, ON
- Contract
5–8 years of experience as a Systems Analyst, Functional Consultant, or in a similar IT role. Strong hands-on Microsoft Dynamics 365 F&O / SCM experience with solid functional and system…

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