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.
Skills Required
- Bachelor's degree in Computer Science or related field
- Proven experience in data modeling
- Proficiency in Cloud Azure services
- Strong understanding of data warehousing concepts
- Excellent analytical and problem-solving skills
Hexaware Technologies Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Hexaware Technologies and has not been reviewed or approved by Hexaware Technologies.
-
Healthcare Strength — Feedback suggests health insurance is a standout element, often described as strong and comparable or better than many employers. Medical coverage and related protections are repeatedly highlighted as reliable pillars of the package.
-
Parental & Family Support — Parental leave options, including extended paid leave in some locations, are offered and seen as valuable for family needs. Feedback suggests these policies complement core medical coverage for a more complete family safety net.
-
Wellbeing & Lifestyle Benefits — Wellbeing resources such as an Employee Assistance Program, wellness initiatives, on-site gyms, and engagement activities provide lifestyle support. These offerings are reinforced by flexible work options and shift-related extras where applicable.
Hexaware Technologies Insights
What We Do
At Hexaware, we're not just a global technology and business process services company; we're a community of 27,000 Hexawarians dedicated to one singular purpose: creating smiles through the power of great people and technology. With a presence in 40+ offices across 19 countries, we empower enterprises worldwide to embark on their digital transformation journey with unparalleled scale and speed. As an employer, we're more than just a workplace. We put our people first, foster diversity and inclusivity, and prioritize their growth through robust learning and development programs. Our culture is a canvas for innovation as we work toward our shared vision of becoming the world’s most loved digital transformation partner. Exciting, isn’t it? Visit www.hexaware.com to join us in embracing the magic of technology, as we passionately advocate for its potential to transform lives today and shape a brighter future. Together, we'll make the digital world a better place.
