Find work in Canada.

606,433 jobs across our Canadian network. How we count

Jobs in Canada

25+ jobs

Email me new jobs Save this search

Added 3 hours ago
NS
Power Platform & Copilot Studio Architect
Nexvant Solutions
Canada
- Full-time
10+ years of experience in software engineering or enterprise solution delivery, including at least 2+ years of experience architecting systems and 6+ years of experience leading technical…
Added 5 hours ago
M
Solution Engineer - Cloud & AI Applications
Microsoft
Toronto, ON
- Full-time
As a Solution Engineer – Cloud & AI Applications, you’ll play a pivotal role in helping customers unlock the full potential of AI. You’ll guide them in understanding the art of the…
Added 5 hours ago
M
Cloud & AI Solution Engineer - Azure Platform
Microsoft
Toronto, ON
- Full-time
…solve complex challenges in the AI era? Join us as a Cloud & AI Solution Engineer - Azure Platform for enterprise and commercial customers at…
Added 5 hours ago
WE
Senior Architect
West End Workforce
Toronto, ON
- $103,300 to $153,300 CAD / year
- Full-time
Registration as a licensed architect with the OAA or the AIBC.
Added 6 hours ago
S
Data & AI Solution Architect
SaskTel
Regina, SK
- Contract
…impact, skillsets and timeliness for delivery of a quality…
Added 6 hours ago
Senior Software Engineer - Kubernetes platform
Cloudflare
Toronto, ON
…"normalized" problem and the AI-native curiosity to create a solution using the latest tools. Our culture is built on iteration, leveraging AI to ship faster today to make it better…
Added 7 hours ago
N
Sr AI Engineer
Nutrien
Saskatoon, SK
- Full-time
Act as the primary code reviewer for the AI engineering team, owning code quality standards, review turnaround, and merge approval for AI solution and agent codebases
Added 7 hours ago
A
PTC Windchill Technical Architect
Accenture
Calgary, AB · Vancouver, BC · Ottawa, ON · Toronto, ON · Montreal, QC
- Full-time
Responsibilities of the PTC Windchill Technical Architect may include:
Added 7 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 7 hours ago
TI
Technical Architect
Themesoft Inc.
Toronto, ON
- Contract
· Strong understanding of integration technologies, single sign-on, Enterprise Mobility Management, BYOK, Data Masking, Data Loss Prevention, and cloud solution architecture patterns
Added 7 hours ago
PS
Senior Adobe Experience Platform (AEP) Technical Lead
Publicis Sapient
Toronto, ON
- Full-time
Architect and govern Adobe Experience Platform Web SDK implementations, including tags, data layers, event design, datastreams, consent handling, identity collection, personalization, Edge…
Added 7 hours ago
BH
SAP Technical Lead – Platform & BTP
BC Hydro
Burnaby, BC
- $131,100 to $165,800 CAD / year
- Full-time
Govern transport, change and release management across the landscape, using tools such as SAP Cloud ALM, Solution Manager/ChaRM or CTS+. SAP BTP and Integration
Added 7 hours ago
N
Sr AI Engineer
Nutrien
Calgary, AB
- Full-time
Act as the primary code reviewer for the AI engineering team, owning code quality standards, review turnaround, and merge approval for AI solution and agent codebases
Added 7 hours ago
R
AI Solutions Lead, Enterprise Applications (T & I) (Telework/Hybrid)
Radio-Canada
Montreal, QC
- Full-time
As the core technical builder of this practice, you will work hand-in-hand with our AI Lead Architect to translate our overarching AI vision into tangible platform assets. You will also…
Added 7 hours ago
U
Workday Financials Sales Solution Architect
UST
ON · Ontario, Canada
- Full-time
We are seeking a Workday Financials Sales Solution Architect to serve as a strategic, client-facing subject matter expert with deep domain, product, industry, and solution area expertise.…
Added 7 hours ago
PH
Reporting Architect, BC Health Workday
Provincial Health Services Authority
Burnaby, BC
- Temporary
Reporting to the Manager of Reporting and Dashboards, the Reporting Architect is responsible for governing the technical architecture and solution design to ensure alignment with enterprise…
Added 7 hours ago
N
Enterprise Architect
Nutrien
Calgary, AB
- Full-time
The Enterprise Architect - Applications & ERP defines and maintains Nutrien’s enterprise application and ERP architecture direction. The role creates a transparent view of the application…
Added 8 hours ago
AI
Solution Architect – ServiceNow, ITSM, ITOM, CMDB & SecOps
Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!
Vancouver, BC
- Full-time
The person will be responsible for the end-to-end ServiceNow solution architecture, with expert-level ownership across ITSM, ITOM, CMDB, SecOps and related platform capabilities. The role…
Added 8 hours ago
C
AI Solutions Lead, Enterprise Applications (T & I) (Telework/Hybrid)
CBC/Radio-Canada
Toronto, ON · Montreal, QC
- Full-time
As the core technical builder of this practice, you will work hand-in-hand with our AI Lead Architect to translate our overarching AI vision into tangible platform assets. You will also…
Added 8 hours ago
Solution Architect, D365 Customer Engagement
Long View Systems
Calgary, AB · AB · Vancouver, BC · Toronto, ON
We are looking for a professional and engaging Dynamics 365 Customer Engagement Solution Architect for our Data & Dynamics team to be based out of our Toronto, Vancouver, Edmonton, or…
Added 8 hours ago
NH
SOLUTIONS ARCHITECT
Northern Health - BC
Prince George, BC
- Full-time
…culture? Northern Health is seeking an experienced Solutions Architect to join our Information Management Information Technology…
Added 8 hours ago
P/
System Administrator
PrecisionERP / PrecisionIT
London, ON
- Contract
Architect, build, and maintain complex solutions using various technologies utilizing cloud and on-premise solutions.
Added 9 hours ago
PLM Solution Architect/Architecte de solutions PLM
Capgemini
Montreal, QC
As a PLM Solution Architect, you will blend technical scheduling expertise with strong people management skills to mentor staff, resolve bottlenecks, and ensure organizational milestones…
Added 9 hours ago
PLM Solution Architect/Architecte de solutions PLM
Capgemini
Montreal, QC
We are seeking an experienced PLM Solution Architect to join our dynamic team. In this role, you will be responsible for designing, implementing, and optimizing PLM solutions (3DExperience,…
Added 9 hours ago
PLM Solution Architect/Architecte de solutions PLM
Capgemini
Montreal, QC
As a PLM Solution Architect, you will blend technical scheduling expertise with strong people management skills to mentor staff, resolve bottlenecks, and ensure organizational milestones…

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: Dec 5, 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 source-to-target data flows, document business transformation rules, and develop technical designs and mappings for L2/L3 data models. Coordinate with business, architecture, data science, and IT teams to support data pipeline integration, data governance, data quality, and project delivery.

Requirements

Requires 8–10 years of experience, strong PL/SQL and T-SQL development and query optimization skills, and expertise in data modeling, 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
Data Warehousing
ETL
Source-to-Target Data Mapping
Business Analysis
Data Profiling
Legacy System Analysis
Requirements Gathering
Stakeholder Workshops
Data Governance
Data Quality
MS Visio
Sybase PowerDesigner

Visa sponsorship

Not detected in the job text

Keywords

PL/SQL
T-SQL
SQL
Query Optimization
Data Modeling
Data Warehousing
ETL
Source-to-Target Mapping
Data Movement Model
L2/L3 Data Models
Legacy Systems
Data Analysis
Data Profiling
Business Analysis
Solution Architecture
Functional Architecture
Requirements Gathering
Stakeholder Workshops
Business Transformation Rules
Surrogate Keys
Reference Data
Data Governance
Data Quality
MS Visio
Sybase PowerDesigner
Amazon AWS
Banking Data
Enterprise Data Warehouse
ignio AIOps
TSBI

Report this job