Senior Data Modeler

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.