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 6 mins ago
Programmer Analyst Advisory(Mainframe Developer)
Scotiabank
Toronto, ON · Scarborough, ON
…applications. The successful candidate will work closely with business partners, project teams, and technology stakeholders to deliver high-quality solutions that support critical lending…
Added 6 mins ago
HB
Business Analyst
HomeEquity Bank
Toronto, ON
- Full-time
The Business Analyst is a detail-oriented, highly motivated individual with excellent analytical, organizational, interpersonal, and communication skills. They are deadline oriented with a…
Added 21 mins ago
BF
Financial Analyst – Permanent, FT, Day
Burnbrae Farms
Winnipeg, MB
- Full-time
Burnbrae Farms’ Vision is to grow into a world-class egg business using the strength of our people to develop leading edge products and processes. Through our commitment to quality, health,…
Added 21 mins ago
S
Systems Analyst, Clinical Solutions, IMITS
Sanya’k̓ula
Vancouver, BC
- Full-time
The Systems Analyst, Clinical Solutions reports to the Manager or designate in this professional level job that works with independence within a multi-site health care environment. The…
Added 21 mins ago
CI
Talent Acquisition Specialist
Calian in Space & Technology
Ottawa, ON
- Full-time
We create innovative solutions that tackle complex challenges and help organizations and communities stay resilient, informed, and connected. If you’re driven by purpose and energized by…
Added 21 mins ago
KR
Senior Business Analyst
KTek Resourcing
Toronto, ON
- $90,000 to $1,000,000 CAD / year
- Full-time
Role: Business Analyst with banking experience
Added 21 mins ago
IE
Analyst, Business
IMAX Enhanced | Streaming & Consumer Technology
Mississauga, ON
- Full-time
IMAX is seeking a Business Analyst to bridge business functions, technology teams, data teams, project management, and senior leadership in defining and delivering technology-enabled…
Added 21 mins ago
H
Junior Cyber Incident Response Analyst
Hootsuite
Ottawa, ON
- Full-time
Hootsuite’s Security team is looking for a Junior Cyber Incident Response Analyst to assist the team in securing our product, services and IT infrastructure. You’ll work to identify and…
Added 36 mins ago
B
Senior Analyst, Data Analytics & Automation Solutions
BMO
Toronto, ON · FCP
- Full-time
The successful candidate will leverage automation, AI and analytics to solve business problems for our Wealth stakeholders. Understands and articulates the business case of business…
Added 36 mins ago
KR
Senior Business Analyst
KTek Resourcing
AB · Edmonton, AB
- Contract
Minimum 5 years of experience in a Business Analyst role.
Added 36 mins ago
T
Business System Analyst
TechDoQuest
Brampton, ON
- Full-time
They will play a critical role in identifying, analyzing, and delivering AI-enabled business solutions that improve productivity, automate processes, enhance decision-making, and generate…
Added 51 mins ago
TC
Aexeo Onboarding - Vice President
The Citco Group Limited
Halifax, NS
- Full-time
Standard – Stakeholder / Business Analyst / Testing
Added 1 hour ago
C
Analyst, Mid-Market Investment Banking
CIBC
Toronto, ON
- Full-time
As an Analyst, you will assist senior bankers in executing all facets of the group’s mandates. This will include researching industries, potential buyers and public valuation metrics;…
Added 1 hour ago
A
Finance - Senior Financial Analyst/Financial Analyst, Business Finance
Aritzia
Vancouver, BC
- Full-time
Aritzia is growing and our Business Finance team is growing with it. This is a unique opportunity to be part of the team responsible for producing insightful financial analysis, effectively…
Added 1 hour ago
IP
Financial Analyst - Senior
Independence Pet Group
Oakville, ON · IPG_OFFICE_Oakville
- Full-time
…and Canada and provides well-being, safety, resources, and business solutions to the pet industry, including microchip identification and an online pet registry. Job Summary:Independence…
Added 1 hour ago
AI
BSA TSB
Apptoza Inc.
Toronto, ON
- Contract
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
Financial Analyst
ATS Automation
Cambridge, ON
The Financial Analyst supports the Life Sciences Service business by providing financial and operational support to Service Leadership and Project Management teams. The role focuses on…
Added 1 hour ago
WF
Master Data Control Analyst
West Fraser
Toronto, ON
- Full-time
Reporting to the Master Data Control Manager, the Master Data Control Analyst is responsible for working with business users and IT to provide hands-on support for enterprise master data…
Added 1 hour ago
Junior Cyber Incident Response Analyst
Hootsuite
Vancouver, BC · Toronto, ON
Hootsuite’s Security team is looking for a Junior Cyber Incident Response Analyst to assist the team in securing our product, services and IT infrastructure. You’ll work to identify and…
Added 1 hour ago
H
Junior Cyber Incident Response Analyst
Hootsuite
Vancouver, BC
- Full-time
Hootsuite’s Security team is looking for a Junior Cyber Incident Response Analyst to assist the team in securing our product, services and IT infrastructure. You’ll work to identify and…
Added 1 hour ago
H
Junior Cyber Incident Response Analyst
Hootsuite
Toronto, ON
- Full-time
Hootsuite’s Security team is looking for a Junior Cyber Incident Response Analyst to assist the team in securing our product, services and IT infrastructure. You’ll work to identify and…
Added 1 hour ago
H(
Manager, Investment Financial Planning & Analysis and Data Analytics
HOOPP (Healthcare of Ontario Pension Plan)
Toronto, ON · CA ON Toronto
- $86,000 to $131,000 CAD / year
- Full-time
our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic…
Added 2 hours ago
TO
Specialist, Cybersecurity and Resilience
Town of Caledon
Caledon, ON
- Full-time
…required. CompTIA certifications such as Security+, Cybersecurity Analyst (CySA+), Certified Business Continuity Professional (CBCP), or Certified in Risk and Information Systems Control…
Added 2 hours ago
Senior Actuarial Analyst, High Net Worth Pricing
Aviva
Markham, ON
Partner with Product, Underwriting, Data Science, and Distribution teams to deliver innovative solutions that support customer and business objectives.
Added 2 hours ago
Senior Actuarial Analyst
Swiss Re
Toronto, ON
…ownership of Swiss Stat reporting for the US Traditional Life business. This is an opportunity to combine strong actuarial analysis with effective stakeholder communication, turning complex…

Apptoza Inc.

BSA TSB

Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 27, 2026
Posting language: English
Posted: Oct 28, 2026

Original job description

BSA TSBI*

Toronto, ON Hybrid (4 days per week in-person at Toronto office preferred)

Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights : ignio AIOps

Years Experience: 8-10

Job Responsibilities:

Analyze of Legacy System

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.

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.

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 mappings, document business transformation rules, and prepare technical designs for L2/L3 data models. Collaborate with business, architecture, data science, and IT teams to deliver data pipelines, governance, and data quality improvements.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization, and experience with data modeling, data warehousing, ETL, and source-to-target mapping. Candidates should have experience gathering requirements across business and technology teams and conducting data analysis, profiling, legacy system analysis, and technical documentation.

Skills

Business Analysis
SQL
PL/SQL
T-SQL
Data Modeling
Data Profiling
Data Analysis
ETL
Data Warehousing
Source-to-Target Mapping
Gap Analysis
MS Visio
Stakeholder Workshops
Data Governance
Data Quality
Solution Architecture

Visa sponsorship

Not detected in the job text

Keywords

Business Analysis
Solution and Functional Architecture
Data Analytics
Ignio AIOps
SQL
PL/SQL
T-SQL
Query Optimization
Data Modeling
Gap Analysis
MS Visio
Data Warehousing
ETL
Source-to-Target Mapping
Data Profiling
Legacy System Analysis
Data Governance
Data Quality
L2/L3 Data Models
Surrogate Keys
Reference Data
Business Transformation Rules
Sybase PowerDesigner
Amazon AWS
Banking Data
Customer Data
Account Data
Transaction Data
Data Pipelines
Technical Documentation

Report this job