Job Title: Data Modeler - SQL ETL & DWH
Location: Toronto Office
Work Model: Hybrid (2 days per week in office)
Qty: 6
Skills: Data Concepts & Data ModellingData WarehouseMySQL
Experience Required: 68 years
MUST HAVE skills/experience
Strong knowledge of PL/SQL and T-SQL
Experience in Data Modelling using any designer tool Gap Analysis and MS Visio
Good understanding of Data Warehousing concepts and ETL processes
Ability to drive requirement sessions and meetings with various stakeholders
NICE TO HAVE skills/experience
Knowledge of banking domain including regular accounts customer data and transaction data across banking business processes
Experience with Sybase PowerDesigner for data modelling
Knowledge of Cloud technologies (e.g. Amazon AWS)
Role and Responsibilities
Determine operational objectives by studying business functions gathering information and evaluating output requirements and formats
Design analyze requirements and implement modifications
Define project requirements by identifying project milestones phases and elements and forming project teams
Monitor project progress by tracking activity 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 ensuring information confidentiality
Prepare technical design and mapping documents by collecting analyzing and data profiling
Maintain professional and technical knowledge by attending workshops
Work with business and technology teams to fulfill data requirements
Perform data modelling and prepare technical design documentation as per standards
Assess intake requests for new projects and change requests
Strong knowledge of SQL and ability to analyze data from different product systems
Detailed Breakdown
Analyze of Legacy System
For each use case analyze mapping documents of target tables to determine operational objectives by studying business functions gathering information and evaluating output requirements
Track target field mapping back to origin data elements in source systems
Perform data analysis and data profiling on legacy systems using strong SQL knowledge
Document source-to-target data flow for each table including:
Business transformation rules applied
Key-cutting implemented to identify surrogate keys as unique identifiers
Reference data used to enhance context and validity of target data elements
For tables without mapping documents TSBI and ETL leads jointly analyze code to extract business rules and document requirements
L2 / L3 Model
Business team responsible for creation of L2 model supported by Project Business Analyst Solution Architect and TSBI
Collaborate with data scientists business analysts and IT teams to integrate L2/L3 models into the data pipeline
Mapping Design of New L2 / L3
Prepare technical design and mapping (Data Movement Model) for new L2 model with Project Business Analysts and Solution Architects
Review key-cutting process to be implemented on L2 model and obtain approval from L2 schema owners
Only BORT system data is populated into L2 schema; reference and tactical data consumed directly by L3 processes
L2 to L3 mapping includes business transformation rules for each target table
Custom surrogate key process implemented on L3 tables differing from L2 tables
One-off tables containing business data loaded into L3 schema for processing
Spearhead implementation of data governance policies and procedures ensuring compliance with industry standards reducing data security incidents
Collaborate with cross-functional teams to design and implement data quality frameworks to improve accuracy and reduce errors
Required Skills:
Sailpoint
Employment Type : Full Time
Experience: years
Vacancy: 1
Monthly Salary Salary: 10 - 10
Data Modeler SQL, ETL & DWH • Toronto, Ontario, Canada
Toronto-based data intelligence company that turns millions of unstructured public documents into high-value datasets powering infrastructure markets across North America.Looking for a data profess... Show more
Shape the future of data modeling as a Data Modeler.This hybrid role emphasizes SAP data structures, data quality, and thorough documentation to support organizational needs.As a key contributor, y... Show more
About the job RQ08478 - Data Architect/Modeller - Senior.Experience and Skill Set Requirements.Demonstrates experience in working with large scale public safety radio systems that employ P25 trunki... Show more
About the job RQ08912 - Data Architect/Modeller - SeniorResponsibilities:Construct a high-level overview of the entire data landscape of the organization.Illustrate how data moves through the organ... Show more
About the job RQ08912 - Data Architect/Modeller - Senior.Construct a high-level overview of the entire data landscape of the organization.Illustrate how data moves through the organization and betw... Show more
Take on a one-year contract as a Data Engineer with a hybrid work model in the Greater Toronto Area, focusing on data integration and pipeline management.Your advanced technical skills are crucial.... Show more
A technology company's data team in Canada is looking for a skilled Data Analyst to work on data-driven projects.The ideal candidate should have strong SQL skills, experience in data warehousing, a... Show more
Designs schemas and models data from structured and unstructured sources to create clean, queryable datasets, collaborating with engineering and product teams. Show more
Tata Consultancy Services (TCS) is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to c... Show more
A technology solutions provider based in Toronto, Ontario is seeking a mid-senior level Data Engineer with at least 3 years of relevant professional experience.Candidates should have a background i... Show more
A financial services provider in Toronto is seeking a skilled Senior Database Architect / Developer (MSSQL) to manage and optimize SQL databases.Responsibilities include data purging, index optimiz... Show more
About the job RQ08648 - Data Architect/Modeller - Senior.Develops and supports data architecture for prototype and program development in a complex and distributed environment, including the determ... Show more
Designs and develops data models to support business intelligence and analytics, collaborating with stakeholders and the development team. Show more
A leading technology firm is seeking a Sr.Technical Recruiter for a hybrid position in Toronto, Ontario.The ideal candidate will have experience in the capital market and the ability to accelerate ... Show more
We are currently requesting resumes for the following position.Thursday, August 21, 2025 (5:00PM EST).Temp – 700 University Ave, Toronto, Base – CHQ on rotating schedule.Analyze and document existi... Show more
A leading financial technology provider in Canada is seeking a Mid-Senior level professional to lead ETL development and manage a Databricks platform for Capital Markets.This role requires strong e... Show more
A leading data engineering firm is seeking a Senior Data Engineer who can design and maintain effective ETL pipelines.The ideal candidate will have over 7 years’ experience and be proficient in Pyt... Show more
Toronto ( 3 days downtown/Hybrid) Our client is interviewing to onboard a.We are looking for an Intermediate Data Engineer with proven track record working within the Financial sector.You’ll help b... Show more
Direct message the job poster from BuzzClan.Senior Data Architect/Data Modeller.Senior Data Architect/Data Modeller.The role supports metadata tooling, Digital Health Data Dictionary (DHDD), and OI... Show more
A leading technology service provider in Toronto is seeking an experienced ETL Tester/Data Tester.This role involves designing and executing test cases for ETL validation and requires strong SQL sk... Show more
