Data Vault Modeller - Banking & Data (Financial Services) Senior Consultant, Technology Consulting

At EY, we develop you with future-focused skills, and equip you with world-class experiences. We empower you in a flexible environment, and fuel you and your extraordinary talents in a diverse and inclusive culture of globally connected teams.

We work together across our full spectrum of services and skills powered by technology and AI, so that business, people and the planet can thrive together. 

We’re all in, are you?

Join EY and shape your future with confidence.

About the opportunity

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

Your key responsibilities

• Develop Data Vault 2.0 structures including: Hubs / Links / Satellites
• Assist in creation of: Business Vault assets / PIT tables / Bridge tables / Dimensional models
• Analyse source systems and identify business keys, relationships, and historical tracking requirements.
• Produce source-to-target mapping documentation.
• 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 activities.
• Participate in data profiling and data quality assessments.
• Support business analysts and architects in requirements analysis workshops.
• Prepare design documentation, modelling standards, and implementation artefacts.

Required Qualification

• 3-6 years of experience in data modelling, data warehousing, or data engineering.
• Practical experience with Data Vault 2.0 methodologies.
• Understanding of: Hub design / Link modelling / Satellite historization / Surrogate and hash key generation
• Experience creating source-to-target mappings.
• Familiarity with SQL and large-scale relational data models.
• Understanding of dimensional modelling concepts.
• Strong analytical and problem-solving skills.

Preferred Qualification

• Data Vault 2.0 certification.
• Databricks, Snowflake, Azure Data Platform, or similar cloud technologies.
• Banking or financial services experience.
• Exposure to regulatory reporting, risk, finance, treasury, or customer data domains.
• Knowledge of metadata management and data lineage concepts.
• Experience with modelling tools such as ER/Studio, ERwin, SAP PowerDesigner, Vertabelo, or similar.

What we look for

• Passion for enterprise data architecture and modern data platforms.
• Strong attention to detail.
• Curiosity to understand complex business processes.
• Ability to work effectively with both business and technical stakeholders.
• Commitment to quality, documentation, and data governance.

What working at EY offers

EY offers a competitive remuneration package where you’ll be rewarded for your individual and team performance. We are committed to being an inclusive employer and are happy to consider flexible working arrangements. Plus, we offer:

• Continuous learning: You’ll develop the mindset and skills to navigate whatever comes next.
• Success as defined by you: We’ll provide the tools and flexibility, so you can make a meaningful impact, your way.
• Transformative leadership: We’ll give you the insights, coaching and confidence to be the leader the world needs.
• Diverse and inclusive culture: You’ll be embraced for who you are and empowered to use your voice to help others find theirs.

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi-disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.

All in to shape the future with confidence.