Manager, AI & Data, Data Modeller, Financial Services ( BCM)

Manager, AI & Data, Financial Services ( BCM)

The EY Financial Services AI & Data team is continuing to grow and develop unique advisory propositions aligned to market needs and demand. We are currently looking for an exceptional Manager with strong experience in AI and Data solution design and implementation to join our team and drive continued growth and success on a global scale. Joining EY’s AI & Data team in this exciting period of growth will offer a huge variety of opportunity to make a tangible impact to our clients businesses and to your career.

The opportunity
The AI & Data practice works collaboratively with our clients to enhance their ability to solve complex business problems by exploiting data and analytics strategies and solutions. We provide expertise and delivery in three core areas which all work closely together:

• Data Architecture & Engineering – Focusing on next generation data solution architecture design and implementation
• Data Management & Data Strategy – Supporting our clients with Data Strategy, Data Governance, Data and Analytics Target Operating Model Design and wider Data Office and CDO support functions

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, Databricks, 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

•  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 Financial Services Domain is Mandatory

Primary Skills (must have):

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

What we look for
We are looking for highly motivated individuals who are passionate about Data and Analytics and want to assist clients to become truly data driven organisations. If you think you can meet the challenges of a focused consulting organisation, understand how to grow and lead in a large practice and work in the most complex of sectors our Data and Analytics team is looking forward to hearing from you.

What we offer 

We offer a competitive remuneration package where you’ll be rewarded for your individual and team performance. Our comprehensive Total Rewards package includes support for flexible working and career development, and with FlexEY you can select benefits that suit your needs, covering holidays, health and well-being, insurance, savings and a wide range of discounts, offers and promotions. 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.