Find work in Canada.

543,960 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 10 mins ago
C&
Business Intelligence Analyst - Data and Automation
Communications & Power Industries (CPI)
Georgetown, ON
- $86,000 CAD / year
- Full-time
We are looking for a Business Intelligence Analyst – Data and Automation to join our CPI Power Electronics team. This is a hands-on role responsible for turning business needs and data from…
Added 10 mins ago
Senior Analyst, Identity Lifecycle Management
Scotiabank
Toronto, ON
Supporting the business to understand their responsibilities with respect to logical access controls
Added 10 mins ago
Senior Data Analyst
Government of Alberta
AB
This position reports to the Manager, Data and Analytics within the Modernization and Business Intelligence unit of Motor Vehicle Modernization branch of Traffic Safety Services (TSS)…
Added 10 mins ago
VT
AI & Process Improvement Analyst (New Grad)
Valwell Technologies
AB · Edmonton, AB
- Full-time
Help connect our business systems so information flows without re-keying
Added 10 mins ago
CO
BUSINESS ANALYST 311 #67732
City of Toronto
Toronto, ON
- Full-time
Reporting to the Manager, Business Transformation & Sustainment, the Business Analyst supports the planning and delivery of complex projects and initiatives across the Customer Experience…
Added 10 mins ago
TM
Senior Regional Financial Analyst - 3+ months
The Mason Group - Strategic Search Partners
Guelph, ON
- $40 to $45 CAD / hour
- Contract
Our client is a leading consumer goods organization seeking a Senior Regional Financial Analyst to support one of its key regional business units (East, West, or Quebec). They are seeking a…
Added 10 mins ago
RS
Application Analyst - C / Sybase
Radiant Systems Solutions, Inc
AB · Edmonton, AB
- Contract
…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 25 mins ago
BUSINESS ANALYST 311
City of Toronto
Toronto, ON
Reporting to the Manager, Business Transformation & Sustainment, the Business Analyst supports the planning and delivery of complex projects and initiatives across the Customer Experience…
Added 25 mins ago
RB
Payment Analyst - GA
Royal Bank of Canada
Toronto, ON
- Full-time
As a Payment Analyst - GA will be reporting to the Manager, U.S. Payments Processing. In this role, you are primarily focused on providing professional, attentive service to the first point…
Added 25 mins ago
K
Senior Business Analyst
Klick
Toronto, ON
- Full-time
The Business Analyst, Omnichannel Enablement supports data-driven healthcare marketing initiatives by translating client and stakeholder needs into clear requirements, solution plans, and…
Added 40 mins ago
T
Cost Analyst
Thermon
Orillia, ON
- Full-time
The Cost Analyst is a member of the Business Group Finance team responsible for providing cost analysis, cost reporting, and productivity project analysis and planning support to…
Added 40 mins ago
K
Senior Business Analyst
Klick
Toronto, ON
- Full-time
The Business Analyst, Omnichannel Enablement supports data-driven healthcare marketing initiatives by translating client and stakeholder needs into clear requirements, solution plans, and…
Added 40 mins ago
EI
Human Resources Business Partner - Term Certain
Elk Island Public Schools
Sherwood Park, AB
- Full-time
Leverage data and analytics in collaboration with the ERP Business Analyst to build reports that inform HR practices and align with strategic goals.
Added 40 mins ago
TM
Senior Financial Analyst
The Mason Group - Strategic Search Partners
Burlington, ON
- $105,000 to $115,000 CAD / year
- Full-time
Our client is seeking a highly analytical and business-focused Senior Financial Analyst to join their Finance team. The Senior Financial Analyst is an integral part of the Corporate Finance…
Added 40 mins ago
AL
Accounts Payable Analyst
Air Liquide Healthcare
Mississauga, ON
- Full-time
Air Liquide Home Healthcare Canada Inc. is looking for a dynamic Accounts Payable Analyst to join our team. In this role, you will be a key player in ensuring the accuracy, timeliness, and…
Added 40 mins ago
FC
Analyste d'affaires – Finance
FOP Consultants
Montreal, QC
- Full-time
The Finance Business Analyst contributes to the design, validation and deployment of the Oracle Fusion Finance modules (General Ledger, Accounts Payable, Accounts Receivable, Fixed Assets,…
Added 40 mins ago
OD
Financial Analyst (School Support) - 1.0 Term Assignment
Ottawa-Carleton District School Board (OCDSB)
Ottawa, ON · Nepean, ON
- Internship
Reporting to the Team Manager - Financial Services, the Financial Analyst is responsible for reporting financial information to the District and the Ministry of Education; providing…
Added 40 mins ago
FC
Analyste d'affaires SCM
FOP Consultants
Montreal, QC
- Full-time
In order to meet the needs of its clients in the IT sector, FOP Consultants is looking for a Business Analyst – Procurement and Logistics (SCM) motivated to carry out mandates. The main…
Added 55 mins ago
O
Analyste financier
Onepoint
Montreal, QC
- Full-time
Aptitude à vulgariser l’information financière auprès des gestionnaires et des décideurs.
Added 55 mins ago
W
Analyste financier
Wepoint
Montreal, QC
- Full-time
Aptitude à vulgariser l’information financière auprès des gestionnaires et des décideurs.
Added 55 mins ago
VP
Canadian Business Immigration Lawyer
Vialto Partners
Vancouver, BC · Montreal, QC
- Full-time
To be the best in the business, we cultivate a dynamic, highly collaborative culture that fuels the growth of our people. We invite you to inquire boldly, learn deeply, and grow endlessly…
Added 55 mins ago
T
IT Operations Analyst II-Host Operations
TD
Toronto, ON
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 55 mins ago
T
IT Operations Analyst II
TD
Toronto, ON
- Full-time
Monitor resources to ensure availability associated with business applications and technology
Added 1 hour ago
IG
Business System Analyst
IMCS Group
ON · Ontario, Canada
- Contract
Job Title: Senior Business Systems Analyst (TSBI)
Added 1 hour ago
MP
IT Client Services Analyst
Manitoba Public Insurance
Winnipeg, MB
- Full-time
The IT Client Services Analyst is responsible for building and maintaining strong relationships with business units, external vendors, and Information Technology (IT) staff. The position is…

IMCS Group

Business System Analyst

ON, Canada
Ontario, Canada, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 29, 2026
Posting language: English
Posted: Oct 30, 2026

Original job description

Job Title: Senior Business Systems Analyst (TSBI)

Location: Toronto, ON -Hybrid (2 days onsite/week)

Duration: 06 Months of contract with possible extension

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.

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.

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, profile data using SQL, and document source-to-target mappings, transformation rules, and key processes. Design and support L2/L3 data models and mappings, collaborate with business and technology teams, and contribute to data governance and quality initiatives.

Requirements

Requires strong PL/SQL and T-SQL development and query optimization skills, data modeling experience, and knowledge of 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
Gap Analysis
Microsoft Visio
Data Warehousing
ETL
Source-to-Target Data Mapping
Requirements Gathering
Stakeholder Workshops
Data Analysis
Data Profiling
Legacy System Analysis
Technical Documentation
Data Governance

Visa sponsorship

Not detected in the job text

Keywords

PL/SQL
T-SQL
SQL
Query Optimization
Data Modeling
Gap Analysis
Microsoft Visio
Sybase PowerDesigner
Data Warehousing
ETL
Source-to-Target Mapping
Data Movement Model
Legacy Systems
Data Analysis
Data Profiling
L2/L3 Data Models
Data Governance
Data Quality
Surrogate Keys
Reference Data
Business Transformation Rules
Amazon AWS
Banking Data
Customer Data
Account Data
Transaction Data
Enterprise Data Warehouse
Requirements Gathering
Stakeholder Workshops
Technical Documentation

Report this job