Senior Data Modeler
2 days ago
Job Description :
We are hiring a Senior Data Modeler to lead enterprise-wide schema design initiatives for a major U.S.-based global banking client undergoing large-scale modernization. This is a critical, hands-on role for someone experienced in designing and evolving normalized relational schemas while collaborating with cross-functional teams including architects, data engineers, and business analysts. Youll be responsible for unifying schemas across legacy systems and event-driven architectures, supporting governance, and ensuring models are scalable, optimized, and well-documented.
This role is ideal for someone with deep expertise in 3NF modeling, relational databases (Oracle/Postgres), ER modeling tools, and schema optimization. Exposure to NoSQL, Kafka, or cloud-native data platforms is a plus.
Model : Hybrid (3 Days Onsite)
Client : US-based Global Banking Institution
Notice Period : 21 Days
Key Responsibilities :
- Design and maintain logical and physical data models following third normal form (3NF), covering relationships (1 : M, M : N), surrogate vs. natural keys, and schema evolution strategies.
- Collaborate with stakeholders to unify schemas across transactional systems, data lakes, and event-based pipelines.
- Optimize relational schemas for performance on RDBMS platforms like Oracle and Postgres, including indexing, partitioning, and constraint enforcement.
- Support legacy modernization efforts by contributing to NoSQL-to-RDBMS data migrations, including mapping transformations and normalization strategies.
- Create and maintain entity-relationship diagrams using tools like Erwin or ER Studio, and manage DDL generation, versioning, and documentation.
- Lead schema walkthroughs and review sessions with cross-functional teams, resolving naming conflicts, duplication issues, and data ownership boundaries.
- Maintain detailed metadata documentation, including data dictionaries, field definitions, and transformation logic using tools like Confluence or Excel.
- Contribute to schema decisions with awareness of event-driven design patterns, including event sourcing, snapshotting, and downstream consumption.
- Engage with DevOps or data engineering teams on model lifecycle management, schema versioning, and deployment practices.
Skills & Expertise
Required Skills :
- Strong hands-on experience in 3NF relational modeling, including independent ownership of subsystem-level models and schema refactoring without data loss.
- Deep technical expertise in Oracle and/or Postgres, including performance tuning, referential integrity, indexing strategies (B-Tree, Bitmap), and DDL validation with DBAs.
- Working knowledge of NoSQL modeling (preferably MongoDB), including document structure design, indexing, and embedded vs. referenced data strategies.
- Proficiency with ER modeling tools such as Erwin or ER/Studio, including forward/reverse engineering and model versioning.
- Experience maintaining attribute-level metadata, data dictionaries, and supporting model rationale documentation.
- Effective stakeholder collaboration, including conducting schema walkthroughs and resolving architectural/data design conflicts.
- Awareness of event-driven design principles, such as event sourcing, schema evolution tied to domain events, and schema compatibility.
- Involvement in data migration from NoSQL to RDBMS, including mapping challenges, data quality impact, and normalization strategies.
Nice-to-Have Skills :
- Familiarity with cloud-native schema design using Redshift, BigQuery, or Azure SQL, and catalog integration (e.g., AWS Glue).
- Experience with version control for data models using Git or SVN.
- Exposure to data governance tools such as Collibra or Alation and concepts like metadata management and business glossary alignment.
- Knowledge of banking and financial services domains, including customer, account, transaction, or instrument data models.
-
Senior Data Modeler
4 days ago
Hyderabad, Telangana, India Info Services Full time ₹ 12,00,000 - ₹ 36,00,000 per yearSenior Data ModelerFinancial District, Hyderabad or Navalur, ChennaiFull-time with Info ServicesSalary: Try to get under 35 LPA, but it is openRole OverviewWe are seeking an experiencedData Modelerto design, develop, document, and manage logical and physical data models supporting Oracle databases, data warehouse environments, and BI reporting tools such as...
-
Senior Data Modeler
2 weeks ago
Hyderabad, Telangana, India Infosys Full time ₹ 15,00,000 - ₹ 25,00,000 per yearSr Data Modeler• Primary skills:Technology->Database->Data Modeling • Desirables:Process->PLM->Architecture and Data Model Design,Technology->Consulting - Data Management->Data Management Primary skills:Technology->Database->Data ModelingData modeler, Erwin • Good knowledge on software configuration management systems • Strong business acumen,...
-
Senior Data Analyst
4 days ago
Hyderabad, Telangana, India Data Unveil Full timeDescription : About us : Data Unveil is the next generation provider of best-in-class data aggregation services. Our solutions and methodologies have been honed over the past 10 years by experienced practitioners who have collectively supported 100+ brands, 100+ data partners and 25+ new drug launches. Our integrated capabilities create a...
-
Data Modeler
1 week ago
Hyderabad, Telangana, India YO IT Group Full time ₹ 12,00,000 - ₹ 36,00,000 per yearExperience:8 to 12 YearsRequired Qualifications8 to 12 years of experience as a Data Modeler or in a similar data architecture role.Strong domain expertise in Private Equity, Investment Management, or Asset Management (fund structures, portfolio data, investor reporting, valuations).Proven experience creating canonical models and developing logical &...
-
Data Modeler
4 days ago
Hyderabad, Telangana, India Parexel Full time ₹ 5,00,000 - ₹ 12,00,000 per yearWhen our values align, there's no limit to what we can achieve.At Parexel, we all share the same goal - to improve the world's health. From clinical trials to regulatory, consulting, and market access, every clinical development solution we provide is underpinned by something special - a deep conviction in what we do.Each of us, no matter what we do at...
-
Data Modeler
1 week ago
Hyderabad, Telangana, India AALUCKS Talent Full time ₹ 12,00,000 - ₹ 36,00,000 per yearPosition : Data ModelerDepartment : Information Technology Role : Full-time Experience : 8 to 12 Years Number of Positions : 1 About the Role : We are seeking an experienced Data Modeler with strong expertise in the Private Equity and Investment domain. The ideal candidate will have a proven track record of designing and implementing...
-
Data Modeler
2 weeks ago
Hyderabad, Telangana, India Talent Worx Full time ₹ 15,00,000 - ₹ 25,00,000 per yearWe are seeking a skilled Data Modeler to join our dynamic team. In this role, you will be responsible for designing and implementing data models that support our data strategy and business objectives. You will work closely with business stakeholders, data engineers, and analysts to ensure that our data is structured in a way that promotes accessibility,...
-
Data Modeler
2 days ago
Hyderabad, Telangana, India Talent Worx Full time ₹ 15,00,000 - ₹ 25,00,000 per yearWe are seeking a skilled Data Modeler to join our dynamic team. In this role, you will be responsible for designing and implementing data models that support our data strategy and business objectives. You will work closely with business stakeholders, data engineers, and analysts to ensure that our data is structured in a way that promotes accessibility,...
-
Data Modeler
4 days ago
Hyderabad, Telangana, India Prudent Globaltech Solutions Full timeWe are seeking an experienced Data Modeler with a strong background in real estate, investment management, and master data management. The ideal candidate will be responsible for designing, implementing, and maintaining data models that support our business objectives. This role requires a deep understanding of data architecture, data integration, and...
-
Data Modeler
1 week ago
Hyderabad, Telangana, India Two95 International Inc. Full time ₹ 1,20,000 - ₹ 3,00,000 per yearTitle: Data ModelerLocation: Hyderabad(Hybrid)Duration: Full time Salary: 20-22LPA(INR). Time : 1pm to 10PmRequirementsWhat you will be doing:Work as a team member to build a data warehouse on Snowflake This role will be responsible for creating, implementing, and maintaining data models for database platform and code table changes within the enterprise that...