EY - GDS Consulting - AI and DATA - Data Modeller/Data Vault - Senior

At EY, you’ll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture and technology to become the best version of you. And we’re counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. 

EY GDS – Data and Analytics (D&A) –Data Modeller Developer with Cloud Exposure- Senior

As part of our EY-GDS D&A (Data and Analytics) team, we help our clients solve complex business challenges with the help of data and technology. We dive deep into data to extract the greatest value and discover opportunities in key business and functions like Banking, Insurance, Manufacturing, Healthcare, Retail, Manufacturing and Auto, Supply Chain, and Finance.

The opportunity

We’re looking for candidates with strong technology and data understanding in big data engineering space, having proven delivery capability. This is a fantastic opportunity to be part of a leading firm as well as a part of a growing Data and Analytics team.

Your key responsibilities

• Design, build, and maintain Data Vault 2.0 data models (Hubs, Links, Satellites) aligned with enterprise data architecture principles.
• Develop and document conceptual, logical, and physical data models to support business requirements.
• Implement data transformations and lineage using tools like dbt, Snowflake, or cloud-native orchestration frameworks.
• Support data testing, auditing, and change management processes across releases.
• Collaborate with stakeholders and cross-functional teams to understand data requirements and design appropriate data models that align with business needs.
• Create and maintain data dictionaries and metadata repositories to ensure consistency and integrity of data models.
• Identify and resolve data model performance issues to optimize database performance and enhance overall system functionality.
• Maintain comprehensive documentation for data models, metadata, lineage, and mapping logic.

• Should have experience working on building/integrating data into a data warehouse.
• Champion Data Vault 2.0 methodology, automation, and standardization across the data engineering team.

To qualify for the role, you must have

• 3-8 Years of hands-on Experience in data modelling with a focus on Data modelling tools.
• Proven experience in Data Vault 2.0 modelling (certification preferred).

• Strong understanding of dimensional and relational modelling principles.

• Proficiency in data modelling tools such as Erwin / Visio or Power Designer
• Experience in designing and implementing database structures
• Ability to create and maintain conceptual, logical, and physical data models

• Hands-on experience with at least one major cloud data warehouse (Snowflake, Azure Synapse, AWS Redshift, or BigQuery)

• Knowledge of industry best practices for data modelling and database design
• Ability to collaborate with cross-functional teams to gather and analyse data requirements
• Experience with dbt (Data Build Tool) or similar ELT/ETL frameworks.
• Having cloud certification is an added advantage

• Strong analytical skills, attention to detail, and ability to work in agile delivery environments.

• Excellent communication and documentation skills.
• Knowledge in Insurance Domain is Mandatory (Speciality Insurance is a Plus)

Primary Skills:

• Data Modelling (Data Vault 2.0
• Familiarity with Data Vault automation frameworks.
• Advanced SQL
• Insurance domain Knowledge

Ideally, you’ll also have

• Client management skills

What we look for

• People with technical experience and enthusiasm to learn new things in this fast-moving environment

What working at EY offers

At EY, we’re dedicated to helping our clients, from start–ups to Fortune 500 companies — and the work we do with them is as varied as they are.

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

About EY

As a global leader in assurance, tax, transaction and consulting services, we’re using the finance products, expertise and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better. Whenever you join, however long you stay, the exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people, we’ll make our ambition to be the best employer by 2020 a reality.

If you can confidently demonstrate that you meet the criteria above, please contact us as soon as possible.

Join us in building a better working world. 

Apply now

EY | Building a better working world 

 
EY exists to build a better working world, helping to create long-term value for clients, people and society and build trust in the capital markets.  

 
Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform and operate.  

 
Working across assurance, consulting, law, strategy, tax and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.