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 16 mins ago
LB
Senior Software Engineer, Agentic AI Products
Leo Berwick
Toronto, ON
- Full-time
We are hiring a Toronto-based Senior Software Engineer to join our founding in-house engineering team and build products from the ground up. This is a hands-on, individual contributor role…
Added 1 hour ago
CB
Senior Java Developer
Conduent Business Services Canada, Inc.
Canada
- Full-time
- Other
Provide support to Product Management/Solutions Architect during project estimation as needed
Added 1 hour ago
BR
Senior Applications Architect
BITS Recruiting
Toronto, ON
- $110 to $120 CAD / hour
- Contract
We are seeking an experienced Senior Applications Architect to lead the design and implementation of enterprise application architecture solutions within a large, complex technology…
Added 1 hour ago
PA
Senior Architectural Technologist / Licensed Architect
Paradigm Architecture + Design
Toronto, ON
- Full-time
Are you an experienced Senior Architectural Technologist or Licensed Architect looking for greater autonomy, meaningful project responsibility, and opportunities to advance your career?
Added 2 hours ago
Senior Software Engineer, Agentic AI Products
Leo Berwick
Toronto, ON
We are hiring a Toronto-based Senior Software Engineer to join our founding in-house engineering team and build products from the ground up. This is a hands-on, individual contributor role…
Added 2 hours ago
M
AVP, GTO Strategy & Transformation
Manulife
Toronto, ON
- Full-time
…ensure reported outcomes remain transparent and defensible to senior leadership and ELT - explicitly separating transformation-driven impact from organic or external…
Added 2 hours ago
5A
Registered Architect (or Experienced Architectural Intern)
5468796 Architecture Inc.
Winnipeg, MB
- Full-time
construction administration. You’ll work closely with a partner or senior architect,
Added 2 hours ago
SENIOR SYSTEMS INTEGRATOR P&R (UKG Pro Solution Architect)
City of Toronto
Toronto, ON
…across the Parks and Recreation Division. Reporting to the Project Director, Digital Project Implementation, the Senior Systems Integrator P&R (UKG Pro Solution Architect) will join the…
Added 3 hours ago
O
Scrum Master, senior
Onepoint
Montreal, QC
- Full-time
Wepoint is the architect of major transformations for businesses and public sector organizations.
Added 3 hours ago
W
Scrum Master, senior
Wepoint
Montreal, QC
- Full-time
Wepoint is the architect of major transformations for businesses and public sector organizations.
Added 3 hours ago
IG
Business System Analyst
IMCS Group
ON · Ontario, Canada
- Contract
The business team is responsible for the creation of the L2 Model, supported by the Project Business Analyst, Solution Architect, and TSBI.
Added 3 hours ago
A
Architecte PLM Senior / Senior PLM Architect
Airbus
Mirabel, QC · Montreal, QC
- Full-time
Le programme d'avions commerciaux A220 recherche d’un.e Architecte PLM Senior pour rejoindre notre équipe de Stratégie Transverse Ingénierie basée à Mirabel (Québec, Canada), où vous…
Added 4 hours ago
PH
Preconstruction Project Manager, ICI, Edmonton - Permanent - 4329
Parker Huggett - A Division of LRO Staffing
AB · Edmonton, AB
- Full-time
Every project manager has inherited a job that was won on a number nobody could build to. This role exists so the Edmonton operation of a large Canadian general contractor stops handing…
Added 4 hours ago
P
Graphics Specialist – Building Automation / EBO (GSBA004)
Potenco
Toronto, ON · Greater Toronto Area, Canada
- Full-time
Work closely with the Solution Architect / Lead EBO Engineer, Senior Systems Integrators, BAS Specialists, Controls Specialists, commissioning personnel, and project teams.
Added 5 hours ago
T
IT Architect II
TD
Mississauga, ON · Toronto, ON
- Full-time
Generally reports to Senior Managing Architect or above
Added 5 hours ago
Senior Technical Specialist
Insurance Corporation of British Columbia
North Vancouver, BC
The Information Services Division is currently looking for a Senior Technical Specialist. In this position, you will provide senior-level technical leadership for the design,…
Added 5 hours ago
XS
Security Analyst / Engineer / Architect
XChange Software Inc
Mississauga, ON
- Contract
· Communicates trade-offs clearly and credibly with senior stakeholders.
Added 5 hours ago
A
CYBERSECURITY ENGINEER
Adacel
Montreal, QC
- Full-time
Added 5 hours ago
R
Oracle Exadata Cloud@Customer (ExaCC) Senior DBA Consultant
Raise
Calgary, AB
- Full-time
High Availability & Disaster Recovery (HA/DR): Architect, deploy, and troubleshoot Oracle Data Guard (switchover, failover, DR testing) and Oracle GoldenGate replication (Extract/Replicat,…
Added 6 hours ago
MD
Information Technology Specialist 5 - Unified Communications & Collaboration Architect
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
- Full-time
Five years of progressive experience in enterprise unified communications and collaboration, including at least four years in a senior technical or architect-level role.
Added 7 hours ago
CE
Portfolio Architect
Cenovus Energy
Calgary, AB
- Full-time
Reporting to the Senior Manager Architecture, the Portfolio Architect will bring expertise in the oil and gas industry and a practical understanding of upstream business capabilities,…
Added 7 hours ago
M
Senior Functional Analyst - Cross-Functional Data Integration
Maarut
Montréal-Est, QC · Montreal /Quebec, Quebec
- Contract
The client is looking for a senior functional analyst (8+
Added 7 hours ago
AS
Senior Solutions Architect
Alquemy Search & Consulting
Calgary, AB
- Full-time
…Developers, Infrastructure teams, Cybersecurity teams, vendors, and project teams, the Senior Solution Architect ensures solutions align with business objectives, enterprise architecture…
Added 8 hours ago
P
Senior Revenue Operations Manager
Pepper
Canada
- Full-time
Architect the systems. Own the data model and integrations across HubSpot, Snowflake, Gong, Slack, and our internal sales platform, and build source-of-truth tables that agents and…
Added 9 hours ago
ML
AI Engineer
MACHINE LEARNING TECHNOLOGIES LLC
Toronto, ON
- Full-time
Design, architect, and build scalable Gen AI solutions, including LLM pipelines, Agentic, MCP, Graph/RAG architectures, prompt-based applications, and emerging technologies.

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