Find work in Canada.

536,774 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 44 mins ago
RB
Financing Specialist
Royal Bank of Canada
Langley (District), BC · LANGLEY, British Columbia
- Full-time
…contribute to an exceptional client experience by providing superior business, financial and credit advice. Your contribution to the Client’s Relationship Team, and strategic partner to the…
Added 59 mins ago
Senior Network Analyst
Affinity Credit Union
Saskatoon, SK
As a Senior Network Analyst, you will play a key role and have a hands-on approach to a wide range of technologies, including: NGFW Solution deployed with central management environment,…
Added 2 hours ago
M
Analyst – Product & Accounting Control
mthree
Montreal, QC
- $50,000 to $53,000 CAD / year
- Contract
Added 2 hours ago
A
People & Culture - Senior Analyst/Analyst, Workforce Engineering
Aritzia
Vancouver, BC
- Full-time
…for responsible for planning and scheduling talent to match business needs and to support an incredible employee and client experience. As the Senior Analyst / Analyst, Workforce…
Added 2 hours ago
M
RQ11734 - Business Analyst - Senior
Maarut
Toronto, ON
- Contract
clear future-state requirements. The Senior Business Analyst elicits, analyzes,
Added 2 hours ago
RB
Bilingual Commercial Mortgage Analyst, Commercial Credit Adjudication
Royal Bank of Canada
Montreal, QC
- Full-time
Provide quality business and financial analysis for existing clients and improve turn around on credit requests
Added 2 hours ago
RB
Network Operations Analyst
Royal Bank of Canada
Toronto, ON
- Full-time
The Network Operations Analyst is responsible for monitoring and supporting RBC's global network environment on a 24/7/365 basis while leveraging artificial intelligence capabilities and…
Added 2 hours ago
AI
SAP IS-U Functional Business Analyst
Apptoza Inc.
Calgary, AB
- Full-time
We are seeking an experienced ISU Business Analyst (L2 Senior) to bridge business requirements and technology solutions. The candidate will work closely with stakeholders, analyze business…
Added 2 hours ago
AT
Lead Data Analyst
Altis Technology
Ottawa, ON · Greater Ottawa Metropolitan Area
- Contract
Are you a data-driven leader who enjoys turning complex information into meaningful insights? We're seeking a Data Analyst to join a national association supporting Canada's electricity…
Added 2 hours ago
A
eCommerce Operations Analyst, Order and Vendor Support. [AQ-24494]
Aquent
Toronto, ON
- $25 to $30 CAD / hour
- Contract
…to find an organized, detail-oriented eCommerce Operations Analyst for a one-year contract supporting its growing eCommerce operations…
Added 2 hours ago
RC
Business Analyst
Randstad Canada
Toronto, ON
- $75 to $90 CAD / hour
- Contract
Business Analyst – Finance | Toronto | 3–6 Month Contract
Added 2 hours ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
Under the direction of the designated IT Manager, the Application and Integration Technical Analyst is a technical lead responsible for system architecture, data strategy, and integration…
Added 3 hours ago
A
People & Culture - Senior Analyst/Analyst, Workforce Engineering
Aritzia
Vancouver, BC
- $50,000 to $150,000 CAD / year
- Full-time
…for responsible for planning and scheduling talent to match business needs and to support an incredible employee and client experience. As the Senior Analyst / Analyst, Workforce…
Added 3 hours ago
R|
Clinical Trial Financial Control Analyst, Oncology Portfolio
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Full-time
We are seeking a Clinical Trial Financial Control Analyst to provide independent financial control and reconciliation for Oncology-sponsored clinical research studies. Reporting within the…
Added 3 hours ago
R|
Accounts Receivable Analyst
RI-MUHC | Research Institute of the MUHC | #rimuhc
Montreal, QC
- Full-time
We are looking for an Accounts Receivable Analyst to join our Finance team and support the organization’s end-to-end receivables operations.
Added 4 hours ago
MN
Analytics and Insights Analyst (CPG)
Mosaic North America
Mississauga, ON
- Full-time
…translate findings into actionable insights and compelling business…
Added 4 hours ago
M
RQ11731 - Business Analyst - Senior
Maarut
Toronto, ON
- Contract
clear future-state requirements. The Senior Business Analyst elicits, analyzes,
Added 4 hours ago
CC
Technical Support Analyst
Colas Canada Inc.
St. Albert, AB
- Full-time
Colas IS Support is the information technology arm of the North America business for Colas and is based in Denver, Colorado. Colas ISS strives to make Colas an industry leader through…
Added 5 hours ago
M
Senior Quantitative Analyst
Manulife
Halifax, NS · Toronto, ON · Waterloo, ON · Montreal, QC
- Full-time
Reporting to the AVP, Quantitative Analytics, the Senior Quantitative Analyst is accountable for the development and implementation of quantitative models to support business growth.
Added 5 hours ago
R
Bilingual Commercial Mortgage Analyst, Commercial Credit Adjudication- EN
RBC
Montreal, QC
- Full-time
Provide quality business and financial analysis for existing clients and improve turn around on credit requests
Added 5 hours ago
N
Analyst, Continuous Improvement
Nutrien
Saskatoon, SK
- Full-time
Nutrien is a leading provider of crop inputs and services, and our business results make a positive impact on the world. Our purpose, Feeding the Future, is the reason we come to work each…
Added 6 hours ago
QP
Analyst, Investments
QuadReal Property Group
Toronto, ON
- Full-time
The Analyst, Investments, will report to the Director, Investments and will support QuadReal’s Investments team. This important role is responsible for contributing to the preparation of…
Added 6 hours ago
T
University of Victoria Networking Event - October 29 2026
TD
Victoria, BC
- Full-time
…job-related knowledge, geographic location, and other specific business and organizational…
Added 6 hours ago
LI
Sr. Business Analyst - Training and Change Management
Lotus IT Solutions
Toronto, ON
- Contract
The Government Services Integration Cluster, Ministry of Public and Business Service Delivery and Procurement, is seeking a Senior Business Analyst with expertise in training development…
Added 6 hours ago
LI
Senior Business Analyst
Lotus IT Solutions
Toronto, ON
- Contract
Document business and system requirements, user stories, acceptance criteria, business rules, process models, and data needs

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 27, 2026
Experience: Experience Required: 8–10 Years
Posting language: English
Posted: Oct 28, 2026

Original job description

Job Description – Business System Analyst

Location: Toronto, ON

Work Model: Hybrid – 2 days per week in person at the Toronto office preferred

Experience Required: 8–10 Years

Role Summary

We are seeking an experienced BSA TSBI professional with strong expertise in business analysis, SQL development, data modelling, data analysis, and source-to-target data mapping. The role involves analyzing legacy systems, documenting business transformation rules, preparing technical designs, and supporting L2/L3 data models within large-scale data initiatives.

Key Responsibilities

Legacy System Analysis and Data Mapping

Analyze legacy systems and review target table mapping documents to determine operational objectives, business functions, and output requirements.
Trace target field mappings back to the original data elements in source systems.
Perform data analysis and data profiling across different legacy systems using SQL.
Document source-to-target data flows for each table, including business transformation rules, key-cutting processes for surrogate keys, and reference data used to enhance target data.
Collaborate with TSBI and ETL leads to review code and document business rules when mapping documentation is unavailable.
Maintain mapping documentation and technical requirements.

L2/L3 Data Models and Mapping Design

Support the business team in creating the L2 Model in collaboration with Project Business Analysts, Solution Architects, and TSBI.
Collaborate with data scientists, business analysts, and IT teams to integrate L2/L3 models into data pipelines.
Prepare technical designs and data movement mappings for new L2 Models.
Review key-cutting processes for the L2 Model and obtain approval from L2 Schema Owners.
Ensure only BORT system data is populated into the L2 schema, while other reference and tactical data is consumed directly by L3 processes.
Document business transformation rules for each target table in L2-to-L3 mapping.
Support the implementation of custom surrogate key processes for L3 tables, with keys different from those used in L2 tables.
Ensure systems with one-off tables containing business data are loaded into the L3 schema for target table processing.

Business Analysis and Technical Documentation

Determine operational objectives by analyzing business functions, gathering information, and evaluating output requirements and formats.
Analyze requirements, design solutions, and identify required modifications.
Define project requirements, milestones, phases, and deliverables, and support project team formation.
Monitor project progress, resolve issues, prepare progress reports, and recommend actions.
Conduct requirement-gathering sessions and stakeholder workshops across business and technology teams.
Prepare data models and technical design documentation according to established standards.
Assess intake requests for new projects and change requests.
Work with business and technology teams to fulfill data requirements.
Maintain confidentiality and protect operational information.
Maintain professional and technical knowledge through workshops and continuous learning.

Data Governance and Quality

Support the implementation of data governance policies and procedures to ensure compliance with industry regulations and standards.
Collaborate with cross-functional teams to design and implement data quality frameworks.
Improve data accuracy and integrity while reducing errors.

Mandatory Must-Have Skills and Experience

Strong PL/SQL and T-SQL development skills, including query optimization.
Experience in data modelling using industry-standard modelling tools, gap analysis, and MS Visio.
Strong understanding of data warehousing concepts, ETL processes, and source-to-target data mapping.
Proven experience conducting requirements-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 modelling.
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, document source-to-target mappings and transformation rules, and support the design and integration of L2/L3 data models and pipelines. Gather requirements, prepare technical documentation, monitor project progress, and support data governance and quality initiatives.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development skills, and expertise in data modeling, data warehousing, ETL, data mapping, profiling, and legacy system analysis. Candidates should also have experience leading requirements-gathering sessions and stakeholder workshops; banking data, PowerDesigner, AWS, and L2/L3 model experience are preferred.

Skills

PL/SQL
T-SQL
SQL Query Optimization
Data Modeling
Source-to-Target Data Mapping
Data Analysis
Data Profiling
Legacy System Analysis
Data Warehousing
ETL Processes
Technical Documentation
Requirements Gathering
Stakeholder Workshops
MS Visio
Data Governance
Data Quality

Visa sponsorship

Not detected in the job text

Keywords

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

Report this job