Data Vault Modeller - Banking & Data (Financial Services) Senior Consultant, Technology Consulting
Core
Design and implement modern enterprise data platforms using Data Vault 2.0 methodologies to support regulatory reporting, analytics, and AI use cases.
Role type
Senior Data Vault Modeller (Data Architect)
Builds
Scalable Data Vault 2.0 models (Hubs, Links, Satellites), Business Vault assets, PIT tables, Bridge tables, and Dimensional models.
Domain
Financial Services / Banking / Enterprise Data Architecture
Deliverable
production ML models
Required skills
Data Vault 2.0 methodology, Hub/Link/Satellite design, Surrogate and hash key generation, Source-to-target mapping, SQL, Dimensional modelling, Data profiling
Preferred skills
Databricks, Snowflake, Azure Data Platform, Regulatory reporting, Risk/Finance/Treasury domains, Metadata management, Data lineage, ER/Studio, ERwin, SAP PowerDesigner
Responsibilities
Develop Data Vault 2.0 structures, Analyse source systems to identify business keys and relationships, Support logical and physical data model development, Work with data engineers to implement models on cloud platforms, Contribute to metadata and lineage design, Participate in data quality assessments, Support requirements analysis workshops, Prepare design documentation and modelling standards.