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 [email protected] 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.
