Lead Data Modeler

Skip to main content.

View More Jobs

Lead Data Modeler

Canada

Job Description

**Employer:**Hexaware Technologies Canada Ltd.

Position: Lead Data Modeler

Terms of Employment: Full-time / Permanent

Location: Toronto, Ontario

Employment Address

• 66 Wellington Street West, Toronto, ON, M5K 1A2

• Hybrid work arrangement available

Hours of Work: 40 hours/week

Language: English

Existing Vacancy: This posting reflects an ongoing opportunity for future openings

Benefits: Eligible for discretionary bonuses and/or salary increases in accordance with company policy.Eligible for medical insurance, dental insurance, and disability insurance

Salary: $135,000 - $140,000 CAD per annum

Contact: Please send resumes to premkumarv1@hexaware.com and include “Lead Data Modeler” in the email subject line.

Role Summary: We are seeking an experienced and highly skilled Lead Data Modeler to operationalize and optimize our large-scale data modeling applications for our database management systems. This role requires someone with proficiency in data modeling tools including SAP Power Designer and Erwin Data Modeler and the ability to provide thought leadership to our clients about how to optimize their data models based on changing industry standards. The ideal candidate will bridge the gap between existing data architecture and the future end-state architecture with the goal to improve security, scalability, reliability, performance, and cost-efficiency in a fast-paced financial environment.

Duties

• Delivering end to end data modelling for OLTP, OLAP, Master Data Management (MDM), and Cloud solutions.

• Optimizing data models for performance, scalability and storage efficiency across multiple platforms.

• Designing MDM (Master Data Management) models for product master data, including attributes, hierarchies, validation rules, and workflow configurations.

• Developing source-to-target mappings and data integration designs using Oracle Data Integrator (ODI) for ELT/ETL pipelines.

• Completing models and simulations, using manual or automated tools, to analyze or predict system performance under different operating conditions.

• Implementing data quality frameworks using Oracle Enterprise Data Quality (EDQ), including data profiling, cleansing, standardization, match/merge rules and configurations.

• Advising customers to meet governance, architecture, process, best practices and strategic goals by involving the relevant groups within the organization.

• Organizing, documenting, and reviewing work items in scope from technical viewpoints and approaches to ensure completeness and consistency in scoping of the project.

Requirements

• Bachelor’s degree or college diploma, preferably in computer science, software engineering or a related field is required

• 7+ years of experience in design, development, testing, implementation, support, client management, project management and resource management is required

• Proficient in data modelling tools including SAP Power Designer and Erwin Data Modeler

• Experience with OLTP, OLAP, Master Data Management (MDM) and Cloud Solutions

• Experience as a Data Modeler in a Credit Card and Risk / Regulatory System for Federal reporting, including CCAR

• Experience designing and developing using Informatica PowerCenter

• Knowledgeable about client-specific frameworks used for data ingestion

• Extensive background in the Software Development Life Cycle (SDLC) and Methodologies such as Waterfall and Agile

• Experience with functional testing, systems integration, performance testing, User Acceptance and application monitoring

• Extensive experience with testing in Azure Cloud Data storage and Snowflake Data Warehouse

• Extensive experience using advanced SQL queries

• Knowledge of various databases such as Oracle, DB2, Informix, and SQL Server.

• AI Disclosure: We may use artificial intelligence tools to assist with scheduling interviews and managing screening times. We do not use AI to evaluate applicants or make decisions during the interview process. All candidate assessments and hiring decisions are made by our recruitment and leadership teams.

Required Skills

• Ab Initio
• Collibra
• Data Modelling
• IBM Datastage
• Informatica
• Microsoft SQL Server Integration Services
• PL/SQL
• SAP
• SAS Data Integration Studio
• Talend

Apply Now

Job Info

• Job Identification644624
• Posting Date05/13/2026, 03:23 PM
• LocationsCanada
• Lane of RecruitmentLane 1

Similar Jobs

• Senior Principal Data Architect\ \ IndiaPosted on 07/10/2026

• Senior Amaze - Data Architect\ \ United StatesPosted on 06/11/2026

See More Jobs

• ABOUT

I am an employee

Are You Still With Us?

It seems you've been gone for a while. For security reasons we will end your session automatically in 03:00 unless you would like to continue working.

End SessionContinue Working

Work Summary

This summary is generated by AI Assist. Click inside the summary text box to make changes as necessary.

DiscardAdd Summary

Page Lead Data Modeler - HEXAWARE Careers loaded