Find work in Canada.

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

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 11 mins ago
NB
Senior Analyst - SSI Expert
National Bank of Canada
Montreal, QC
- Full-time
A career as a Senior SSI Analyst in the Capital Markets Operations team at National Bank means acting as a specialist in OTC operations and payment processes. This role allows you to make a…
Added 2 hours ago
RB
Financing Specialist
Royal Bank of Canada
Langley (District), BC · LANGLEY, British Columbia
- Full-time
…compliance support you will contribute to an exceptional client experience by providing superior business, financial and credit advice. Your contribution to the Client’s Relationship Team,…
Added 4 hours ago
PS
Accounting Support Analyst
PBS Systems
Calgary, AB
- Full-time
…to join our Client Services team. As an Accounting Support Analyst, you will provide excellent training to our new and existing customers in the accounting module of our software, by…
Added 4 hours ago
RB
Bilingual Commercial Mortgage Analyst, Commercial Credit Adjudication
Royal Bank of Canada
Montreal, QC
- Full-time
Develop knowledge and experience of the Commercial Mortgage product and industry to support the credit needs of Commercial Relationship Managers and their Commercial Mortgage clients
Added 4 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 4 hours ago
MC
Financial Analyst
Mennonite Central Committee Ontario (MCC Ontario)
Kitchener, ON
- Full-time
The Financial Analyst is responsible for day-to-day financial accounting matters, ensuring tasks are completed promptly and accurately. This salaried position will be responsible for the…
Added 4 hours ago
LD
Program Financial Analyst
Leonardo DRS
Bedford, NS
- Full-time
Reporting to the Senior Manager, Program Finance the Program Finance Analyst will analyze, plan and understand the company’s financial position, support baseline planning and actual cost…
Added 4 hours ago
A
eCommerce Operations Analyst, Order and Vendor Support. [AQ-24494]
Aquent
Toronto, ON
- $25 to $30 CAD / hour
- Contract
1–3 years of experience in eCommerce operations, order management, vendor support, fulfillment, supply chain, customer support operations, or a related field. Relevant internship or co-op…
Added 4 hours ago
RI
Associate Product Manager (Accounting)
Remarcable, Inc.
Remote, Canada
- $90,000 to $120,000 CAD / year
- Full-time
- Remote
2-4 years of experience as an Associate Product Manager, Product Analyst, Business Systems Analyst, or in a technical solutions/implementation role within a B2B SaaS environment.
Added 4 hours ago
S
International Trade Compliance Analyst
Sanmina
Ottawa, ON
- Full-time
The International Trade Compliance Analyst plays an important role in ensuring the import and export activities of product as well as ensuring data exchanges with suppliers and customers…
Added 4 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 4 hours ago
PS
Senior Security Consultant ( Analyst)
Prodata Systems
ON · Regional Municipality of York, ON
- Full-time
Elaborate architectures and designs based on the customer requirements
Added 4 hours ago
CI
Deskside Support Analyst (Onsite) - 12-month contract
Compugen Inc
Victoria, BC
- Contract
The Deskside Support Analyst will provide onsite, face-to-face technical support to end users ensuring timely resolution of incidents and service requests while maintaining a high level of…
Added 5 hours ago
HT
Master Data Mgmt Analyst
Husky Technologies
Bolton, ON
- Full-time
Husky TechnologiesTM a company with a strong foundation built on innovation, close customer relationships, a strong sense of community and a unique culture and values. We are looking for…
Added 5 hours ago
Asset Investment Analyst
Toronto Hydro
Toronto, ON
Reporting to the Manager, Customer Connections Planning & Technical Analysis, the Asset Investment Analyst will provide a wide range of engineering support services that will ensure…
Added 5 hours ago
RS
Data Analyst III
Ryder System, Inc.
Halifax, NS
- Full-time
The Data Analyst III role is to deliver a final business solution to the operations team through a Power Bi experience. The Data Analyst's technical skills will be put to the test as they…
Added 5 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 6 hours ago
MN
Client Data Analyst II
Mosaic North America
Toronto, ON
- Full-time
The Client Data Analyst II (analyst) position is responsible for partnering with our clients and teams to drive their initiatives with strategy, analytics and actionable insights,…
Added 6 hours ago
MN
Client Data Analyst II
Mosaic North America
Mississauga, ON
- Full-time
The Client Data Analyst II (analyst) position is responsible for partnering with our clients and teams to drive their initiatives with strategy, analytics and actionable insights,…
Added 6 hours ago
MN
Analytics and Insights Analyst (CPG)
Mosaic North America
Mississauga, ON
- Full-time
Added 6 hours ago
CC
Technical Support Analyst
Colas Canada Inc.
St. Albert, AB
- Full-time
As a Technical Support Analyst, you will be part of a distributed team of highly skilled professionals who take pride in their technical expertise, problem-solving abilities, and…
Added 6 hours ago
AC
Senior Actuarial Analyst, High Net Worth Pricing
Aviva Canada
Markham, ON
- Full-time
Analyze portfolio performance, customer behavior, and market trends to identify opportunities for pricing and product improvements.
Added 6 hours ago
AC
Senior Actuarial Analyst, Personal Pricing
Aviva Canada
Markham, ON
- Full-time
…by the opportunity to influence pricing strategies, improve customer outcomes, and help shape the future of…
Added 6 hours ago
HT
Master Data Mgmt Analyst
Husky Technologies
Bolton, ON
- Full-time
Husky TechnologiesTM a company with a strong foundation built on innovation, close customer relationships, a strong sense of community and a unique culture and values. We are looking for…
Added 7 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.

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