Find work in Canada.

534,319 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 8 mins ago
PC
Business Analyst - Data Mapping
PwC Canada
Montreal, QC
- Contract
The Data Mapping Business Analyst supports the definition and validation of matching rules between source system data and the target Oracle Fusion Cloud data structure. The analyst…
Added 22 mins ago
BR
IT Systems Administrator | Administrateur(trice) de systèmes informatiques
BUSAC Real Estate | BUSAC Immobilier
Montreal, QC
- Full-time
Founded in Québec in 1998 and part of New York-based JEMB Realty Corporation, BUSAC Real Estate is an investor, owner, developer and manager of office, retail and mixed-use properties in…
Added 22 mins ago
D
Account Executive, ENT | North America
Deel
Canada
- Full-time
Our momentum is reflected in our achievements and customer satisfaction: CNBC Disruptor 50, Forbes Cloud 100, Deloitte Fast 500, and repeated recognition on Y Combinator's top companies…
Added 22 mins ago
O
Senior Software Developer (Bilingual)
OpenText
Ottawa, ON
- Full-time
We are looking for a Senior Backend Software Developer to join our development team at OpenText. Our team builds and evolves a public, multi-tenant Software-as-a-Service (SaaS) cloud…
Added 22 mins ago
O
Sr. Software Developer (Bilingual)
OpenText
Ottawa, ON
- Full-time
We are looking for a Senior Backend Software Developer to join our development team at OpenText. Our team builds and evolves a public, multi-tenant Software-as-a-Service (SaaS) cloud…
Added 22 mins ago
C
Program Manager - Retail Technology & AI
Cogniify
Vancouver, BC
- $175,000 to $183,000 CAD / year
- Full-time
Exposure to Snowflake or similar data platforms and cloud-native product development.
Added 22 mins ago
YC
SAP Analyst
York Catholic District School Board
Aurora, ON
- Full-time
Design and deliver custom or enhanced reports and data extracts for management and staff.
Added 23 mins ago
TC
Director of Information Technology
Taproot Community Support Services
Langley (District), BC · Langley, BC
- Full-time
Our Support Office provides the systems, data and services that help our programs do their best work. As we grow, we are looking for a Director of Information Technology to lead our…
Added 23 mins ago
E
AI DevOps Specialist (AI Enablement & Secure DevOps)
Experis
Canada
- Contract
This specialist will bridge the gap between AI development pipelines, secure networking infrastructure, and cloud platform services. They will take a hands-on lead in configuring…
Added 23 mins ago
RH
Salesforce Consultant
Robert Half
Calgary, AB
- Contract
Test Salesforce Experience Cloud portals across multiple user types, including authentication, permissions, and guest access.
Added 23 mins ago
TC
Director of Information Technology, Full-Time
Taproot Community Support Services
Langley (District), BC · Langley, BC
- Full-time
Our Support Office provides the systems, data and services that help our programs do their best work. As we grow, we are looking for a Director of Information Technology to lead our…
Added 39 mins ago
A
Salesforce DevOps Developer
ATB
Calgary, AB · Edmonton, AB
- Full-time
Build automated sandbox data provisioning, database mocking patterns, and execution optimization tools to shorten developer feedback loops and accelerate unit testing cycles.
Added 39 mins ago
A
Salesforce Devops Lead
ATB
Calgary, AB · Edmonton, AB
- Full-time
Build automated sandbox data provisioning, database mocking patterns, and execution optimization tools to shorten developer feedback loops and accelerate unit testing cycles.
Added 39 mins ago
M
Cloud & AI Platform Sales Specialist
Microsoft
Goodwood, ON
- Full-time
As a Cloud & AI Specialist, you are a business leader with deep technical and business knowledge within our enterprise sales organization, working with our most important customers in…
Added 39 mins ago
M
Responsable de comptes stratégiques - Secteur minier / Strategic Account Executive - Mining
Microsoft
Montreal, QC
- Full-time
…solutions that support the customer's transformation journey across cloud, data and…
Added 39 mins ago
U
Scientifique Principale des Données-Ingénieur/Staff Data Scientist- Eng
UKG
Montreal, QC
- Full-time
Nous recherchons des data scientists chevronnés, dotés de solides bases mathématiques, d'une expérience dans la création de solutions basées sur l'IA à partir de données réelles, et d'un…
Added 52 mins ago
CR
Manager HCM Applications Support
Chartwell Retirement Residences
Mississauga, ON
- Full-time
…maintenance, and service delivery of the organization’s Oracle HCM Cloud footprint and related HR…
Added 53 mins ago
B
General Repair Technician III
BGIS
Ottawa, ON
- Full-time
…telecommunications, financial services, oil & gas, healthcare and cloud enterprise. In addition to managing a diverse portfolio of corporate offices, retail, colleges, hospitals and…
Added 53 mins ago
AC
SAP Data Archiving Developer
Alteris Consulting
Markham, ON
- Contract
…experienced consultants across SAP, enterprise applications, data management, cybersecurity, cloud, and business transformation programs. Our focus is on providing exceptional talent that…
Added 53 mins ago
ÉD
Professor of cybersecurity
École de technologie supérieure
Montreal, QC
- Full-time
Cybersecurity of smart networks (5G+) and cloud computing;
Added 53 mins ago
A
Manager, Global Practice and Delivery (Solutions & Services)
Acceldata
Kitchener, ON
- Full-time
Solid understanding of data engineering, distributed systems, cloud platforms, and Kubernetes-based environments. Most important: deep domain expertise in data management, data platforms,…
Added 53 mins ago
Q
Director of Product & Strategy, CXM Flex
Quadient
Toronto, ON
- $221,600 to $332,400 CAD / year
- Full-time
…Professional Services, and Sales, and play a central role in shaping cloud migration paths, hybrid deployment models, and AI‑enabled capabilities for customers who run Inspire in their own…
Added 53 mins ago
R
Sr. Salesforce Administrator/ Business Analyst
Recfront
Toronto, ON
- Contract
…company specializes in technology recruiting with a focus on cloud, data and analytics, AI/ML, cybersecurity, ERP, product, software engineering, infrastructure, and digital…
Added 53 mins ago
S
Protocol Developer
Survalent
Toronto, ON · Greater Toronto Area, Canada
- Full-time
Survalent Technology is seeking a talented and experienced Software Developer to join our Protocols team as a Protocols Developer. This is an exciting opportunity to develop the…
Added 53 mins ago
LI
Business System Analyst
LanceSoft, Inc.
Toronto, ON
- $45 to $50 CAD / hour
- Contract
Experience in Data Modelling using industry-standard modeling tools, Gap Analysis, and MS Visio.

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