Find work in Canada.

540,807 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 6 mins ago
O
Associate Director, Search
OMD
Toronto, ON
- Full-time
…Bing Ads, Amazon Search Ads, ensuring activation aligns with business objectives and drives measurable…
Added 6 mins ago
A
Transportation/Execution Manager
ADM
Windsor, ON
- Full-time
Synchronize business execution with operations for seamless workflow and enhanced efficiency
Added 6 mins ago
RL
Growth Manager
Royal LePage
Vancouver, BC · Greater Vancouver Metropolitan Area
- Full-time
Exposure to Real Estate, Rental, fintech, AI, partnerships, sales, and business development.
Added 6 mins ago
GE
Internal Auditor, Technology Audit & Data Analytics
Gibson Energy
Calgary, AB
- Full-time
…technology audits and supports the development of the function’s data analytics and continuous monitoring programs, strengthening audit coverage and providing value-added business…
Added 6 mins ago
Senior Finance Business Partner
D2L
Vancouver, BC · Winnipeg, MB · Kitchener, ON · Toronto, ON
Reporting to the Manager, Corporate Financial Planning & Analysis, the Senior Finance Business Partner position will partner with the Professional Services and Support (PS&S) organizations…
Added 6 mins ago
LC
Product Manager, Digital Health (14 month contract)
Loblaw Companies Limited
Toronto, ON
- Full-time
● Contribute to the product strategy and roadmap, translating customer insights, business priorities and performance data into clear product requirements and priorities.
Added 6 mins ago
Director, Sales & Commercial Effectiveness, Western Canada and Southwestern Ontario
Right Time Group of Companies
Canada
Use data-driven insights to continuously refine sales strategies, processes, and tactics to enhance sales outcomes and close performance gaps.
Added 7 mins ago
V
Order Management Coordinator - Brampton, ON
Victaulic
Brampton, ON · Toronto, ON · Ontario - Toronto
- Full-time
This role is ideal for an Excel expert who loves working with data and thrives in a fast-paced environment. You’ll turn complex pricing information into clear reports and insights that help…
Added 21 mins ago
OH
Program Manager, Performance, Accountability & Funding Allocation
Ontario Health
Chatham-Kent, ON · Hamilton, ON · London, ON · Owen Sound, ON · Sarnia, ON · St. Catharines, ON · Stratford, ON · Waterloo, ON · Windsor, ON
- Full-time
Transform complex quantitative and qualitative information into meaningful insights, performance metrics, and practical recommendations.
Added 22 mins ago
CT
Senior BI Analyst
Canadian Tire Corporation
Oakville, ON · Toronto, ON
- Full-time
As a Senior BI Analyst, you will play a key role in transforming data into actionable business insights. You will work across the full analytics lifecycle, partnering with business…
Added 22 mins ago
B
Director, Intraday Liquidity Risk Oversight
BMO
Toronto, ON · FCP
- Full-time
Analyzes data and information to provide insights and recommendations.
Added 22 mins ago
B
Manager, Digital Strategy & Insights
BMO
Toronto, ON · BMOPLACE
- Full-time
We are seeking a strategic and data-driven Manager, Digital Strategy & Insights to lead digital transformation initiatives and drive business growth through actionable insights. This role…
Added 22 mins ago
AL
Contract & Sales Analyst
Air Liquide
Calgary, AB · AB · Coquitlam, BC · Richmond, BC · Winnipeg, MB
- Full-time
Reporting & Analytics: Prepare and distribute accurate reports tailored for the District Manager, providing insights into sales performance, pipeline health, and strategic business trends.…
Added 36 mins ago
CO
Director, Health, Safety, & Organizational Resilience
City of Saint John
Saint John, NB
- Full-time
Drive measurable improvements in safety performance, leveraging data, trends, leading and lagging indicators, risk assessments, and organizational insights to identify priorities and…
Added 36 mins ago
HA
Senior Data Analyst
HR Associates
Toronto, ON
- Temporary
This opportunity is ideal for someone with strong hands-on experience in data analytics, statistical analysis and business intelligence who can turn complex data into meaningful insights to…
Added 36 mins ago
SI
Data Analyst
Spait Infotech
Canada
- Full-time
Analyze large datasets to identify trends, patterns, and business insights.
Added 36 mins ago
HT
VP, Accounting & Controllership (Husky)
Husky Technologies
Bolton, ON
- Full-time
Translate financial information into actionable business insights that improve profitability, working capital, cash flow, and operational performance.
Added 36 mins ago
HT
Director, Finance (CSM)
Husky Technologies
Bolton, ON
- Full-time
Present clear financial results and business insights to senior leadership
Added 36 mins ago
HT
Financial Manager - PLM (Product Line Mgmt)
Husky Technologies
Bolton, ON
- Full-time
This role sits at the heart of the business, providing forward-looking insights, challenging assumptions, and driving performance across the business. You will play a critical role in…
Added 36 mins ago
HT
Applications Engineer
Husky Technologies
Bolton, ON
- Full-time
Apply a data-driven, first-principles approach, leveraging scientific modeling, experimentation, and advanced analytics to understand, predict, and optimize complex physical phenomena.
Added 36 mins ago
A
Sales Development Representative
Assemble
Toronto, ON
- $50,000 to $75,000 CAD / year
- Full-time
We’re Assemble - a company built to serve the vast majority of business leaders that struggle to make important decisions with certainty. We help enterprise leaders cut through the noise…
Added 36 mins ago
TE
Sales Manager
Talentfoot Executive Search
Montreal, QC
- Full-time
…sales team, strengthen commercial execution, and accelerate new business…
Added 36 mins ago
FL
Account Manager
Fuze Logistics Services Inc
Montreal, QC
- Full-time
Strategic Planning: Develop and implement account strategies to drive business growth, ensuring alignment with the overall company goals. Schedule pick-ups and deliveries, provide updates…
Added 36 mins ago
HO
Team Lead, Safety and Health
Harvest Operations Corp.
Calgary, AB
- Full-time
…compliant, and risk-based H&S requirements into all aspects of the business, including operations, projects, maintenance, field execution, contractor activities, emergency response, and…
Added 37 mins ago
M
P&O Business Partner
Mars
Bolton, ON · BOL-Mars Canada Inc.
- Full-time
Ability to interpret data, identify trends, and provide insights that support business decision-making.

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