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.

Skills Required