Find work in Canada.

545,929 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 14 mins ago
S
Analyst, Credit
Sagard
Toronto, ON
- Full-time
We are looking for an Analyst to join the Sagard Credit team based in Toronto. The right candidate would join a collaborative team and have an opportunity to work on a range of public,…
Added 14 mins ago
AC
Analyste D'affaires Principal En Finance
Aston Carter
Montreal, QC
- $95 to $115 CAD / hour
- Contract
The Business Analyst will lead finance-focused business analysis initiatives within the Finance Transformation & Systems function. This role involves translating complex financial…
Added 14 mins ago
A
Scientifique De Données
Actalent
Longueuil, QC
- $43 to $66 CAD / hour
- Contract
The PMO is seeking a Power BI & Data Science Analyst who can turn program data into actionable decisions. The position is approximately 50% complex dashboard and BI engineering and 50% data…
Added 14 mins ago
A
Data Scientist
Actalent
Longueuil, QC
- $43 to $66 CAD / hour
- Contract
The PMO is seeking a Power BI & Data Science Analyst who can turn program data into actionable decisions. The position is approximately 50% complex dashboard and BI engineering and 50% data…
Added 14 mins ago
AS
Financial Analyst
AgileGrid Solutions
Canada
- Full-time
Vaco LLC is recruiting on behalf of a leading athletic company seeking a Senior Financial Analyst, FP&A. The organization operates in a dynamic, performance-focused industry and values…
Added 14 mins ago
T
Application Analyst
ThoughtStorm
AB · Alberta, Canada
- Contract
The System Analyst will be assigned requirements gathering & programming duties for application projects and enhancement tasks. The individual will also work closely with application…
Added 14 mins ago
D
Quality & Risk Analyst, Audit & Assurance
Deloitte
Toronto, ON
- Full-time
…people can find meaning and opportunity. It builds consumer and business confidence, empowers organizations to find imaginative ways of deploying capital, enables fair, trusted, and…
Added 14 mins ago
N
Application Analyst
NetworkPedia
AB · Edmonton, AB
- Contract
Job Title: Application Analyst – C / PowerBuilder / Sybase
Added 14 mins ago
BT
Senior Tax Analyst
Baker Tilly Canada
Peterborough, ON
- Full-time
We are looking for a Senior Tax Analyst to join our team - a role where your expertise will drive meaningful outcomes and your ambition will help shape what comes next. Here, you’ll…
Added 14 mins ago
C
Analyst, Client Onboarding & Service
CIBC
Winnipeg, MB · Regina, SK
- Full-time
As an Analyst in the Client Onboarding & Service team, your primary focus will involve supporting clients within your portfolio on all day-to-day service and support requests. You will be…
Added 14 mins ago
A
Senior Analyst, Compliance Monitoring – Load Settlement
AESO
Calgary, AB · KPMG Tower
- Full-time
Reporting to the Manager, Transmission Tariff & Load Settlements, the Senior Analyst, Compliance Monitoring - Load Settlement is a key member of a collaborative team responsible for…
Added 14 mins ago
AI
PLM Data Analyst
Aptino, Inc.
Mirabel, QC
- $50 to $55 CAD / hour
- Contract
We are looking for an experienced PLM Data Analyst to support product data quality, governance, and analytics across enterprise Product Lifecycle Management (PLM) systems.
Added 14 mins ago
B
Climate & Sustainability Analyst
BuzzClan
Calgary, AB
- $40 to $45 CAD / hour
- Contract
Job Title: Climate & Sustainability Analyst (Intermediate)
Added 14 mins ago
MR
Assistant Professor of Finance (Limited-Term)
Mount Royal University
Calgary, AB
- Part-time
The Department of Accounting and Finance offers Bachelor of Business Administration (BBA) degrees in both Accounting and Finance. The BBA - Finance major offers students three concentration…
Added 29 mins ago
IT Operations & CMDB Analyst
Purolator
ON · Mississauga, ON
The IT Operations & Configuration Management Database (CMDB) Analyst is responsible for ensuring the integrity and governance of the ServiceNow CMDB while supporting operational excellence…
Added 29 mins ago
B
Director, FP&A (Revenue)
Benevity
Remote, Canada
- Full-time
- Remote
…and giving executives a single, trusted view of the revenue business. You will lead a team that includes a Revenue Operations group and an FP&A analyst who owns accounting and reporting for…
Added 29 mins ago
B
Director, FP&A (Revenue)
Benevity
Remote, Canada
- $156,800 to $206,750 CAD / year
- Full-time
- Remote
…and giving executives a single, trusted view of the revenue business. You will lead a team that includes a Revenue Operations group and an FP&A analyst who owns accounting and reporting for…
Added 29 mins ago
AC
Analyste De Finance
Aston Carter
Montreal, QC
- $48 to $56 CAD / hour
- Contract
Expérience de travail avec des systèmes ERP tels que Business Central, Dynamics GP, SAP ou des plateformes similaires.
Added 44 mins ago
R
Analyst, Trade Support
RBC
Toronto, ON
- Full-time
RBC Capital Markets is hiring an Analyst to join the Middle Office Trade Support team within Operational Services, based in Toronto. In this role, you will support the timely and accurate…
Added 44 mins ago
FS
Business Analyst, Pension
Financial Services Regulatory Authority of Ontario (FSRA)
Toronto, ON
- Full-time
A minimum of 5 years’ experience working as a Business Analyst, preferably in a pension-related industry.
Added 44 mins ago
R
Analyst – Interest Rate Strategy
RBC
Toronto, ON
- Full-time
…mathematics), data/computer science, financial engineering, economics, business, finance,…
Added 44 mins ago
T
Cyber Security Intern/Co-op (Winter 2027)
TD
Mississauga, ON · Toronto, ON
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 44 mins ago
T
Senior Governance & Control Analyst
TD
Toronto, ON
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 44 mins ago
TE
Land Analyst
TC Energy
Calgary, AB
- Full-time
Plan and execute day-to-day Project land scope in alignment with Project and Business Unit objectives
Added 44 mins ago
M
Senior Analyst, Project Finance & Infrastructure Ratings
Morningstar
Toronto, ON
- Full-time
Morningstar DBRS is seeking a Senior Analyst to join its Project Finance & Infrastructure team in Toronto. This role offers an opportunity to contribute to credit ratings and research…

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