Find work in Canada.

521,894 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 28 mins ago
PI
Senior Software Engineer, Accounts
PENN Interactive
Canada
- Full-time
Design, architect, and deliver new features end-to-end in a collaborative agile/scrum environment
Added 28 mins ago
Digital Architect
Government of Alberta
AB
…Architects. Reporting to the Manager, Development, the Digital Architect is a visionary and technical leader responsible for shaping the strategic design and overseeing the implementation…
Added 58 mins ago
KR
Cloud Support Engineer
KTek Resourcing
Toronto, ON · Scarborough, ON
- Contract
Design, build, manage, and operate Azure infrastructure including virtual networks, compute, storage, identity, and security services in large-scale environments
Added 1 hour ago
SAP SuccessFactors Consulting Manager - Technical Integrations Lead
EY
AB · Toronto, ON · Calgary, AB
Architect end-to-end integration solutions between SAP SuccessFactors and external systems (e.g., SAP HCM, payroll engines, ERP platforms, third-party HR tools).
Added 1 hour ago
LT
Principal Azure Platform & Cloud Operations Architect
Lorven Technologies Inc.
Toronto, ON
- Contract
Role: Principal Azure Platform & Cloud Operations Architect (AKS / Networking / Automation)
Added 2 hours ago
Salesforce Technical Architect
Orion Global Solutions
Toronto, ON · Montreal, QC
We are seeking an experienced Salesforce Technical Architect to join our team. This role is responsible for designing scalable, secure, and high-performing Salesforce solutions that align…
Added 2 hours ago
AI
BSA TSB
Apptoza Inc.
Toronto, ON
- Contract
Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights : ignio AIOps
Added 2 hours ago
RI
Senior Full Stack Engineer
Remarcable, Inc.
Remote, Canada
- $140,000 to $190,000 CAD / year
- Full-time
- Remote
…influence. You won’t get lost in corporate red tape: you will architect scalable services, ship end-to-end features, collaborate closely with product and customer-facing teams, and help…
Added 3 hours ago
A
Forward Deployed Solutions Lead
Accenture
Calgary, AB · Ottawa, ON · Toronto, ON · Montreal, QC
- Full-time
…will work across AI agents, data, APIs, cloud infrastructure, security, networking, and DevOps, taking solutions from design and development through deployment and production…
Added 3 hours ago
API Lead Architect
Capgemini
Mississauga, ON
Define enterprise API architecture, strategy, governance, security, and reusable standards.
Added 3 hours ago
AF
Senior Controls Engineer
Armstrong Fluid Technology
Toronto, ON
- Full-time
Embed cybersecurity best practices into the product, including secure firmware update processes, certificate-based authentication, and alignment with recognized industry security frameworks.
Added 3 hours ago
MC
Software QA Lead - HandyDART
MatchBox Consulting Group
New Westminster, BC
- Contract
…test coverage, reliability and stability, data quality and security, and operational readiness (monitoring, backup/restore, and…
Added 4 hours ago
AC
Specialist, Cloud and AI FinOps
Air Canada
Toronto, ON
- Full-time
Added 4 hours ago
SQ
Director, Domain Enterprise Architect, RPA and Intelligent Automation
Sunlife Québec
Montreal, QC
- Full-time
At Sun Life, we're driven by our Purpose: helping our Clients achieve lifetime financial security and live healthier lives. Our values shape how we work: caring, authentic, bold, inspiring,…
Added 5 hours ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
…integration frameworks, ensuring the reliability, scalability, and security of critical business systems. This role champions a portfolio of SaaS (i.e., cloud-based) and on-premise…
Added 5 hours ago
EC
Business Architect
Experis Canada
Toronto, ON
- Contract
We are looking for an experienced Domain Architect / SME to provide technical leadership, architecture guidance, and domain expertise. The candidate will work closely with business…
Added 5 hours ago
C
Senior Project Manager
Cognizant
Toronto, ON
- Full-time
The Product Architect ISG will design and evolve customer identity and access management solutions using Ping UnboundID CIAM and Janrain CIAM for global enterprise clients in a hybrid work…
Added 6 hours ago
B
Enterprise Architect
BRP
Montreal, QC · Greater Montreal Metropolitan Area
- Full-time
We are looking for an Enterprise Architect (EA) who will report to the manager of Enterprise & Solution Architecture. As an EA-Cybersecurity, you will play a pivotal role in shaping,…
Added 6 hours ago
C
Senior Customer Engineer, Digital Native - Vancouver BC
Cloudflare
BC · British Columbia, Canada
- Full-time
…go-to-market strategy: a trusted technical advisor and primary architect of the customer journey. You will bridge the gap between technical strategy and business value - guiding enterprise…
Added 6 hours ago
AI
Snowflake ETL/ELT Developer
Apptoza Inc.
Calgary, AB
- Contract
Architect data solutions using Medallion (Bronze, Silver, Gold) architecture.
Added 6 hours ago
FI
Salesforce Revenue Cloud Architect
Flexstaf I.T. Inc.
Toronto, ON · Greater Toronto Area, Canada
- Contract
Job Description: Salesforce Revenue Cloud Architect responsible for designing and leading enterprise-scale Revenue Cloud solutions supporting Quote-to-Cash, Contract-to-Cash, Billing,…
Added 7 hours ago
T
Full-Stack Architect
TD
Toronto, ON
- Full-time
…technical integration architecture, data strategies and models, security and enterprise…
Added 7 hours ago
M
Technical Delivery Lead
McKesson
Mississauga, ON
- Full-time
The Technical Delivery Lead works horizontally across HCM platforms and partners closely with the HCM Architect, Solution Managers, Vendor Operations Lead, Portfolio/Program Management,…
Added 7 hours ago
M
Workday Solutions Delivery Manager
McKesson
Mississauga, ON
- Full-time
Coordinate functional, technical, integration, security, testing, and vendor resources required for delivery.
Added 7 hours ago
M
HR Technology Solutions Manager
McKesson
Mississauga, ON
- Full-time
Work with the HCM Architect and technology teams to develop scalable solution approaches.

Apptoza Inc.

BSA TSB

Toronto, ON, Canada

Contract

Apply About employer

Applications open in a new tab.

Job details

Job type: Contract
Apply by: Nov 27, 2026
Posting language: English
Posted: Oct 28, 2026

Original job description

BSA TSBI*

Toronto, ON Hybrid (4 days per week in-person at Toronto office preferred)

Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights : ignio AIOps

Years Experience: 8-10

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.

5 Mandatory 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.

5 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 source-to-target mappings, document business transformation rules, and prepare technical designs for L2/L3 data models. Collaborate with business, architecture, data science, and IT teams to deliver data pipelines, governance, and data quality improvements.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization, and experience with data modeling, data warehousing, ETL, and source-to-target mapping. Candidates should have experience gathering requirements across business and technology teams and conducting data analysis, profiling, legacy system analysis, and technical documentation.

Skills

Business Analysis
SQL
PL/SQL
T-SQL
Data Modeling
Data Profiling
Data Analysis
ETL
Data Warehousing
Source-to-Target Mapping
Gap Analysis
MS Visio
Stakeholder Workshops
Data Governance
Data Quality
Solution Architecture

Visa sponsorship

Not detected in the job text

Keywords

Business Analysis
Solution and Functional Architecture
Data Analytics
Ignio AIOps
SQL
PL/SQL
T-SQL
Query Optimization
Data Modeling
Gap Analysis
MS Visio
Data Warehousing
ETL
Source-to-Target Mapping
Data Profiling
Legacy System Analysis
Data Governance
Data Quality
L2/L3 Data Models
Surrogate Keys
Reference Data
Business Transformation Rules
Sybase PowerDesigner
Amazon AWS
Banking Data
Customer Data
Account Data
Transaction Data
Data Pipelines
Technical Documentation

Report this job