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)
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
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
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
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
A leading financial institution is seeking a Senior Data Management Lead in Toronto.This role requires providing technical leadership across diverse data analysis functions, including SQL, ETL, and... 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
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
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 business intelligence firm in Toronto is seeking a Software Application Consultant to implement and integrate BI applications for clients.You will focus on software installation and confi... Show more
An established industry player is looking for a skilled developer to join their team in Toronto.This role focuses on leveraging AWS services to develop and maintain robust data architectures while ... 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
Data Architect needed to develop and support data architecture in a complex, distributed environment.Responsibilities include data flow, database location, and data access methods. 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 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
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
A leading technology company in Canada is seeking an experienced data modeler to own and evolve its core data models and shared metrics.You will work closely with cross-functional teams to ensure h... 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
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
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
Unlock new opportunities as a Datastage ETL Expert in Toronto.Enjoy a hybrid work model while utilizing your extensive ETL knowledge and SQL expertise to optimize our data processes.We are currentl... Show more
