Data Modeler

Job Description

Job Title: Data Modeler
Experience Level: 7 - 10 years
Location: Pune

Qualification: BTech/MTech/MCA
Mode of Work: Hybrid

Job Summary

We are seeking an experienced Data Vault Modeler / Data Architect to lead the design and implementation of enterprise-scale Data Vault 2.0 solutions within banking, risk, and regulatory data domains. The ideal candidate will have strong hands-on expertise in conceptual, logical, and physical data modeling, deep understanding of banking and financial services, and the ability to collaborate across business, risk, and data-engineering teams to deliver scalable, auditable, and compliant data architectures.

Key Responsibilities:

Data Modeling & Architecture

· Lead the design and implementation of enterprise-scale data models using Data Vault 2.0 methodology, including Hubs, Links, and Satellites.

· Develop and maintain conceptual, logical, and physical data models to support banking, risk, finance, and regulatory reporting use cases.

· Ensure data models are scalable, auditable, and compliant with regulatory and internal governance standards.

Banking, Risk & Regulatory Alignment

· Collaborate closely with business, risk, finance, and compliance stakeholders to translate requirements into robust data-vault structures.

· Support regulatory and risk initiatives such as BCBS 239, risk aggregation, financial controls, and regulatory reporting.

· Design data models that enable traceability, lineage, and auditability across source systems and downstream consumption layers.

Standards, Governance & Metadata

· Define, document, and enforce data modelling standards, naming conventions, historization rules, and data-vault best practices.

· Ensure strong alignment between source-to-vault and vault-to-consumption layers.

· Work with metadata, lineage, and data-governance teams to ensure consistency and transparency across the data ecosystem.

ETL / ELT & Analytics Enablement

· Support ETL/ELT development teams by providing optimized vault designs, source-system mappings, and transformation guidance.

· Advise on performance optimization, data-quality controls, reconciliation, and error-handling mechanisms.

· Enable downstream analytics, reporting, and consumption layers by ensuring high-quality, well-structured vault models.

Collaboration & Communication

· Act as a subject-matter expert for data modelling and Data Vault architecture.

· Communicate complex data concepts clearly to both technical and non-technical stakeholders.

· Participate in design reviews, architecture discussions, and solution governance forums.

Requirements

Technical Skills

· Strong experience in data modeling, with hands-on Data Vault 2.0 knowledge (Hubs, Links, Satellites).

· Good experience working with SQL-based data modelling tools (DBM tools).

· Strong SQL knowledge and understanding of relational database concepts.

· Experience supporting ETL/ELT pipelines and data-warehouse architectures.

Domain Expertise

· Strong understanding of Banking & Financial Services domains.

· Hands-on exposure to risk, finance, and regulatory data.

· Familiarity with BCBS 239, regulatory reporting, and audit requirements is a strong advantage.

Soft Skills

· Good communication and stakeholder-management skills.

· Ability to work effectively in cross-functional teams.

· Strong analytical, documentation, and problem-solving capabilities.

Preferred / Nice to Have

· Experience working in large-scale enterprise or regulatory programs.

· Exposure to cloud data platforms (AWS, Azure, GCP).

· Knowledge of data governance, metadata management, and lineage tools.

· Certification or formal training in Data Vault modeling.

Benefits

• Comprehensive Medical Coverage:  
  

  Health insurance of INR 5.0 Lakhs for you and your family (up to 6 members), ensuring complete peace of mind.
  

• Robust Protection Plans:  
  

  Group Personal Accident Insurance and Group Term Life Insurance to safeguard you and your loved ones.
  

• Retirement Benefits: 
  

  PF and Gratuity provided as per standard government regulations.
  

• Flexible Work Options: 
  

  Enjoy hybrid work arrangements & flexible working hours
  

• Generous Leave Policy:  
  

  21 days of annual leave, in addition to 10 company-declared holidays.
  

• Employee Well-being Spaces: 
  

  Access to a dedicated break-out area with round-the-clock refreshments for relaxation and rejuvenation.
  

Requirements
Technical Skills · Strong experience in data modeling, with hands-on Data Vault 2.0 knowledge (Hubs, Links, Satellites). · Good experience working with SQL-based data modelling tools (DBM tools). · Strong SQL knowledge and understanding of relational database concepts. · Experience supporting ETL/ELT pipelines and data-warehouse architectures. Domain Expertise · Strong understanding of Banking & Financial Services domains. · Hands-on exposure to risk, finance, and regulatory data. · Familiarity with BCBS 239, regulatory reporting, and audit requirements is a strong advantage. Soft Skills · Good communication and stakeholder-management skills. · Ability to work effectively in cross-functional teams. · Strong analytical, documentation, and problem-solving capabilities. Preferred / Nice to Have · Experience working in large-scale enterprise or regulatory programs. · Exposure to cloud data platforms (AWS, Azure, GCP). · Knowledge of data governance, metadata management, and lineage tools. · Certification or formal training in Data Vault modeling.