Find work in Canada.

540,807 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 15 mins ago
T
IT Architect II
TD
Mississauga, ON · Toronto, ON
- Full-time
…supports the most efficient, reliable, scalable, and secure solutions to meet the business needs and technology strategy; this includes planning, evaluating, recommending and designing…
Added 30 mins ago
CO
Application & Integration Technical Analyst
City of Saint John
Saint John, NB
- Full-time
…(i.e., cloud-based) and on-premise applications, modern ERP solutions, integrations, data management, and reporting platforms. This role reinforces the organization’s transition to modern…
Added 30 mins ago
C(
Senior Software Engineer, Agentic Systems
CareLink (by Asepha)
Toronto, ON
- Full-time
CareLink (by Asepha) is based in New York and Toronto, building agentic solutions that re-imagine how medications are prescribed, verified, and supported across the pharmacy ecosystem.…
Added 45 mins ago
DT
AI Architect
Derex Technologies Inc
Toronto, ON
- Full-time
We are seeking a visionary and highly experienced AI Architect to lead the design and delivery of next‑generation intelligent solutions across our enterprise. This role is central to our…
Added 1 hour ago
N
AI Engineer, Design
Nubank
Toronto, ON
- Full-time
…building their own tooling: something like 100 AI-assisted solutions and 30+ local knowledge repositories, each built inside a business unit to solve that unit's problem. Most of them work.…
Added 1 hour ago
XS
Security Analyst / Engineer / Architect
XChange Software Inc
Mississauga, ON
- Contract
· Lead architecture reviews across cloud, applications, infrastructure, and third-party solutions.
Added 1 hour ago
A
CYBERSECURITY ENGINEER
Adacel
Montreal, QC
- Full-time
…contrôle de la circulation aérienne (ATC) de premier plan et de solutions de gestion du trafic aérien (ATM) à la fine pointe de la technologie…
Added 1 hour ago
V
AI Engineer
Virtusa
Toronto, ON
- Full-time
AWS Certifications (AWS Certified Machine Learning, AWS Solutions Architect, or related certifications)
Added 1 hour ago
IF
Enterprise Architect
iA Financial Group
Montreal, QC · Quebec, QC
- Full-time
As an Enterprise Architect, you will play a key role in the organization’s transformation and modernization by ensuring alignment between business strategic ambitions and technology…
Added 1 hour ago
MD
Information Technology Specialist 5 - Unified Communications & Collaboration Architect
Minnesota Direct Care and Treatment
Saint-Paul, NB · St.-Paul, NB
- Full-time
Working Title: Unified Communications & Collaboration Architect
Added 1 hour ago
Solutions Consultant - Advanced Process Control
Spartan Controls Ltd.
Calgary, AB · Edmonton, AB
…current and future automation and digital technology trends, to architect innovative and cost-effective…
Added 1 hour ago
I
Lead SAP TMS Consultant
Infosys
Calgary, AB
- Full-time
…healthcare and pharmaceutical industries through innovative digital solutions. We focus on integrating advanced AI and automation to enhance operational efficiency and support long-term…
Added 1 hour ago
NS
AWS Snowflake Solutions Architect
N2P Systems
Toronto, ON
- Full-time
N2P Systems is seeking an experienced AWS Snowflake Solutions Architect to join our enterprise technology delivery team in Toronto, Ontario, Canada. At N2P Systems, you will put 10+ years…
Added 1 hour ago
E
Field Coordinator
EllisDon
AB · Alberta Projects
- Full-time
…to deliver great careers to one another and develop creative solutions for complex problems on some of the most exciting projects. It doesn’t matter what your expertise and craft is – there…
Added 2 hours ago
IF
Enterprise Architect
iA Financial Group (Industrial Alliance)
Quebec, QC
- Full-time
As an Enterprise Architect, you will play a key role in the organization’s transformation and modernization by ensuring alignment between business strategic ambitions and technology…
Added 2 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 2 hours ago
AI
Data Business Analyst - PL/SQL, T-SQL & Data Warehousing
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Toronto, ON
- Full-time
Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps
Added 2 hours ago
IS
Enterprise Architect
Iris Software Inc.
Toronto, ON
- Full-time
Work closely/collaboratively with dev teams to architect solutions that meet enterprise standards
Added 2 hours ago
A
Data Architect
Altis
Mississauga, ON
- $70 to $100 CAD / hour
- Full-time
…innovative technology? We're looking for a Data & Analytics Solutions Architect to shape enterprise-wide data, analytics, and AI solutions within a forward-thinking…
Added 2 hours ago
AS
Senior Solutions Architect
Alquemy Search & Consulting
Calgary, AB
- Full-time
…Cybersecurity teams, vendors, and project teams, the Senior Solution Architect ensures solutions align with business objectives, enterprise architecture standards, operational requirements,…
Added 2 hours ago
SI
SAP HANA Database Administrator
Spruce InfoTech Inc.
Calgary, AB
- Contract
Architect and manage complex SAP HANA system architectures, including Multi-Tenant, scale-in/scale-out landscapes, and dynamic tiering.
Added 2 hours ago
SAP S/4HANA Solution Architect
Capgemini
Mississauga, ON
The SAP S/4HANA Solution Architect is responsible for leading the design, architecture, governance, and successful delivery of enterprise-wide SAP solutions that support business…
Added 2 hours ago
Technical Program Manager, Platform Services
Motive
Vancouver, BC
Identify systemic issues and execution gaps early, and lead teams toward practical, durable solutions that support departmental and functional objectives.
Added 3 hours ago
TT
Technology Lead Enterprise Platforms and Operations
Tundra Technical Solutions
Toronto, ON
- $140,000 to $145,000 CAD / year
- Full-time
Ecosystem Synergy & Debt Reduction: Architect seamless integrations across disparate systems to remove operational friction, eliminate redundant applications, and systematically reduce…
Added 3 hours ago
D
Lead, Forward Deployed Engineering
Deliverect
Toronto, ON
- Full-time
…revolution, dedicated to consistently delivering groundbreaking solutions to the global marketplace. Our team of passionate and innovative engineers, designers, and product managers…

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!

Data Business Analyst - PL/SQL, T-SQL & Data Warehousing

Toronto, ON, Canada

Full-time

Apply About employer

Applications open in a new tab.

Job details

Job type: Full-time
Apply by: Nov 27, 2026
Experience: Years of Experience: 8–10 years
Posting language: English
Posted: Oct 28, 2026

Original job description

Data Business Analyst - PL/SQL, T-SQL & Data Warehousing

Location: Toronto, ON
Work Arrangement: Hybrid (2 days per week in-person at Toronto office preferred)
Years of Experience: 8–10 years
Skills: Business Analysis, Solution and Functional Architect (SAFA), Data Analytics & Insights – ignio AIOps

Job Responsibilities

1. Analysis of Legacy Systems

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.

2. 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.

3. 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 data flows, document source-to-target mappings and business transformation rules, and design technical mappings for L2/L3 data models. Collaborate with business, architecture, data science, and IT teams to define requirements, monitor project progress, and improve data governance and quality.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization skills, and experience with data modeling, data warehousing, ETL, and source-to-target mapping. Candidates must also have experience gathering requirements, facilitating stakeholder workshops, analyzing and profiling legacy-system data, and producing technical documentation.

Skills

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

Visa sponsorship

Not detected in the job text

Keywords

PL/SQL
T-SQL
SQL
Data Warehousing
ETL
Data Modeling
Source-to-Target Mapping
Data Movement Model
L2/L3 Data Models
Legacy Systems
Data Analysis
Data Profiling
Business Transformation Rules
Surrogate Keys
Reference Data
Data Governance
Data Quality Frameworks
Requirements Gathering
Stakeholder Workshops
Gap Analysis
MS Visio
Sybase PowerDesigner
Amazon AWS
Banking Data
Customer Data
Account Data
Transaction Data
Solution Architecture
ignio AIOps
BORT

Report this job