Data Modeler - HRMS Data Domain

About The Role

We are looking for an experienced Data Modeler to design, develop, and maintain enterprise-grade data models for HRMS migration and transformation projects.

The ideal candidate should have strong expertise in relational and non-relational databases, data migration, schema design, metadata management, and HRMS data domains.

You will work closely with cross-functional teams to build scalable, secure, and high-performance data models that support business and compliance requirements.

Key Responsibilities

• Design, develop, and maintain logical, physical, and relational data models for enterprise HRMS applications.
• Create HRMS-specific data models covering employee master data, payroll, benefits, performance management, and compliance reporting.
• Define and maintain primary keys, foreign keys, constraints, indexes, and partitioning strategies to optimize database performance.
• Design and execute schema conversions, data mappings, and ETL/ELT processes for HRMS migration initiatives.
• Collaborate with application owners, business stakeholders, QA, infrastructure, and security teams to ensure successful data migration and integration.
• Develop and maintain ER diagrams, data dictionaries, metadata repositories, and data lineage documentation.
• Establish and enforce enterprise data governance standards, including metadata management and Master Data Management (MDM) practices.
• Support migration from legacy HRMS platforms by ensuring data quality, consistency, and integrity.
• Optimize database schemas for scalability, performance, and maintainability.
• Work with development and analytics teams to align data models with business and reporting requirements.
• Ensure compliance with data privacy, security, and regulatory standards throughout the data lifecycle.
  
  

Education

Required Skills & Qualifications :

• Bachelor's degree in Engineering, Computer Science, Information Technology, or a related discipline.
• Master's degree in a relevant field is an added advantage.
  
  

Experience

• 5- 8 years of experience in data modeling for enterprise applications.
• Strong experience with relational databases such as Oracle and MySQL.
• Experience with non-relational databases such as MongoDB and Cassandra.
• Proven expertise in designing and implementing enterprise-scale data models.
• Hands-on experience in HRMS data modeling and migration projects.
• Experience integrating and migrating data from legacy HRMS systems.
• Strong experience with schema design, normalization, and ER modeling.
• Experience designing and implementing ETL/ELT pipelines.
• Exposure to Big Data technologies such as Hadoop is an advantage.
  
  

Technical Skills

• Expertise in Oracle SQL Developer Data Modeler or equivalent data modeling tools.
• Strong knowledge of :
• Logical, Physical, and Relational Data Modeling
• Entity Relationship (ER) Diagrams
• Database Normalization
• Schema Design
• Metadata Management
• Data Dictionaries
• Data Lineage
• Master Data Management (MDM)
• Data Governance
• Understanding of database performance optimization techniques.
• Knowledge of HRMS data architecture and enterprise integration patterns.
  
  

Preferred Certifications

• Oracle Certified Professional (OCP).
• Certifications in NoSQL databases (MongoDB, Cassandra) are an added advantage.
• Relevant Data Modeling or Data Architecture certifications are preferred.
  
  

Preferred Candidate Profile

• Strong analytical and problem-solving skills.
• Excellent stakeholder management and communication skills.
• Ability to work collaboratively with cross-functional teams.
• Experience in enterprise HRMS migration and digital transformation projects.
• Detail-oriented with a strong focus on data quality, governance, and compliance.
• Ability to manage multiple priorities in a fast-paced environment.
  
  

(ref:hirist.tech)