Senior Data Vault Modeller – Banking & Data

About the role

EY is looking for a hands-on Data Vault Modeller to support the design and implementation of modern enterprise data platforms. The successful candidate works alongside data architects, engineers and business analysts to build scalable Data Vault 2.0 models supporting regulatory reporting, analytics and AI use cases. The role suits practitioners who enjoy turning complex business requirements into robust, auditable data models.

Key responsibilities

• Develop Data Vault 2.0 structures including hubs, links and satellites
• Assist in creating business vault assets, PIT tables, bridge tables and dimensional models
• Analyse source systems and identify business keys, relationships and historical tracking requirements
• Produce source-to-target mapping documentation and support logical and physical data model development
• Work with data engineers to implement Data Vault models on cloud-based data platforms
• Contribute to metadata, lineage and audit design, and take part in data profiling and quality assessments
• Support business analysts and architects in requirements workshops, and prepare design documentation, modelling standards and implementation artefacts

Required profile

• 3-6 years of experience in data modelling, data warehousing or data engineering
• Practical experience with Data Vault 2.0 methodologies
• Strong analytical and problem-solving skills
• Preferred: Data Vault 2.0 certification, banking or financial services experience, and exposure to regulatory reporting, risk, finance, treasury or customer data domains

Required skills

• Hub design, link modelling, satellite historization, surrogate and hash key generation
• Familiarity with SQL and large-scale relational data models
• Understanding of dimensional modelling and source-to-target mappings
• Preferred: Databricks, Snowflake, Azure Data Platform; metadata management and lineage; ER/Studio, ERwin, SAP PowerDesigner, Vertabelo

What we offer

• A competitive remuneration package linked to individual and team performance
• Flexible working arrangements considered
• Continuous learning, coaching and leadership development