Job Title: Data Modeler

Experience Level: 7 - 10 years

Location: PuneQualification: 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

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

· Valuable 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

· Positive 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.

📌 Data Modeler (Pune)
🏢 DataEconomy
📍 Pune