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