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 just now
Territory Manager
Spartan Controls Ltd.
Edmonton, AB
Coordinate internal resources to deliver customer solutions and achieve business objectives
Added just now
A
Senior Human Resources Manager
Acciona
Mississauga, ON · CAN - Mississauga Office
- Full-time
…make a difference, promote sustainable development, and find solutions to the biggest global challenges including climate change, overpopulation, and water scarcity? Come and join us in…
Added just now
A
Director, Business Development – Construction (Canada)
Acciona
Mississauga, ON · CAN - Mississauga Office
- Full-time
…make a difference, promote sustainable development, and find solutions to the biggest global challenges including climate change, overpopulation, and water scarcity? Come and join us in…
Added just now
T
Personal Banking Associate - O'Brien, Ville Saint Laurent (Part-time, 18.75h/week)
TD
Montreal, QC
- Part-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added just now
T
Trade Compliance Manager
Thales
Ottawa, ON · Montreal, QC
- Full-time
Location: Ottawa, CanadaIn fast changing markets, customers worldwide rely on Thales. Thales is a business where brilliant people from all over the world come together to share ideas and…
Added just now
T
Senior Finance Analyst
TD
Toronto, ON
- Full-time
This role is positioned under Protect Platform within the Global Technology and Solutions (GTS) Finance team supporting the Corporate Technology Portfolio. The GTS Finance team provides…
Added just now
T
Personal Banking Associate Trainee (Full time)- St-Sauveur
TD
Saint-Sauveur, QC
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added just now
T
Applied Machine Learning Scientist I
TD
Toronto, ON · Montreal, QC
- Full-time
…primarily focused on Generative AI, including LLM-based and agentic solutions, while also offering opportunities to work on predictive machine learning use cases. You'll contribute across…
Added just now
T
Senior Counsel
TD
Toronto, ON
- Full-time
Support development and/or implementation of policies, procedures, and solutions that mitigate risk and enable the achievement of business/enterprise priorities.
Added just now
T
Personal Banking Associate Trainee - Mandarin or Cantonese Language Skills
TD
Richmond, BC
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added just now
C
Financial Planning Consultant
CIBC
Richmond, BC · Vancouver, BC
- Full-time
As a member of the Personal and Business Banking Team, you’ll manage and grow a complex client portfolio through self-sourced leads, provide dedicated relationship management, in-depth…
Added just now
C
Client Engagement Representative
CIBC
Vancouver, BC
- Full-time
As a member of the Personal and Business Banking Team, you'll work in a fast-paced Banking Centre, leveraging your knowledge of financial services products to support clients with their…
Added just now
C
Financial Services Representative II
CIBC
Vancouver, BC
- Full-time
As a member of the Personal and Business Banking team, you’ll work in a fast-paced Banking Centre where you’ll make a meaningful difference in our clients’ lives. As a Financial Services…
Added just now
C
Associate Consultant
Curinos
Toronto, ON
- Full-time
…exposed to a diverse set of teams that collaborate to deliver solutions to clients. You will work across different subject areas and functional domains, developing a well-rounded skillset…
Added just now
A-
Insurance Advisor Level 1
AMA - Alberta Motor Association
Lethbridge, AB
- Full-time
You’re passionate about finding the right solutions to fit client needs.
Added just now
H
Field Service Representative
Hitachi
Kelowna, BC · (HE)Office_BC_Kelowna NEW
- Full-time
The scope and depth of any background or security review will be determined based on the nature of the role and business necessity, and will always be conducted in compliance with…
Added just now
Retail Seasonal Sales Associate, Kildonan Place
Bell
Winnipeg, MB
Build a connection with customers to find the right solutions for them
Added 15 mins ago
'
Sr Functional Engineer, SAP - 12 month contract
''
Toronto, ON
- Full-time
- Temporary
Strong analytical capabilities, including the ability to evaluate data, develop alternative solutions, and make recommendations that support business outcomes.
Added 15 mins ago
'
Associate Cloud Engineer
''
Florenceville-Bristol, NB
- Full-time
…experiences - together. With a customer-first mindset, we make doing business with McCain…
Added 15 mins ago
'
Master Data Management Engineer
''
Toronto, ON
- Full-time
Experience implementing master data management solutions across multiple organizations, business units, or technology environments.
Added 29 mins ago
LM
Assistant Vice President, Executive Underwriter, Property
Liberty Mutual Canada
Vancouver, BC
- Full-time
…We offer a broad suite of commercial insurance products and solutions to mid-size and large Canadian companies with Canadian, North American and/or multinational risks. Liberty Mutual…
Added 29 mins ago
CS
Management Consultant - Analyst, Associate, Senior Associate
Cascadia Strategy Consulting Partners
Victoria, BC
- $68,000 to $135,000 CAD / year
- Full-time
Our work focuses on five practice areas: Business Strategy, Operations Management, Digital Transformation, Policy & Economics, and Data Analytics & AI. We serve clients in industries such…
Added 29 mins ago
KS
Founding Growth & Go-to-Market Associate
Kintora Solutions
Calgary, AB
- Full-time
Someone interested in startups, sales, business development, or healthcare technology.
Added 29 mins ago
KS
Outside Sales Representative - Electrical Utilities
Kinetic Search Group
Quebec, QC
- Full-time
…relationships within an assigned territory, identifying new business opportunities, and promoting a comprehensive portfolio of electrical utility and infrastructure products. Working…
Added 29 mins ago
S
Data & AI Solution Architect
SaskTel
Regina, SK
- Contract
Evaluates the impact of changing business drivers on IT solutions and advises enabling and client areas on focus areas for new requirements or changes.

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