Senior Consultant - Data Engineering, BCM, FS in Edinburgh

The EY Financial Services AI & Data Consulting team in Scotland is continuing to grow and develop unique advisory propositions in response to market needs and demand. We fully support the Scottish Financial Enterprise (SFE) vision for an ecosystem with Data, AI and emerging technology at the core and are now recruiting for new colleagues as part of our strategic investment to help deliver this vision. We offer the opportunity to join a local team, driving continued growth and success on a global scale, delivering exceptional career experiences and advancing Scotland’s position as a world leader in Financial Services.

Our mission is to deliver AI-ready Data enabling our Financial Services clients to deliver superior market products and experiences. We are currently looking for exceptional Senior Consultants with good experience in Financial Services and Data Platform solutions (Snowflake or Databricks) to join our team and actively contribute to this mission, locally and globally. Joining the Edinburgh EY 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 in this AI & Data consulting role involves working collaboratively with our clients to enhance their ability to solve complex business problems by delivering engagements related to the deployment of Data Platforms such as Snowflake and Databricks. We provide expertise and delivery across two core areas:

• Data Architecture & Engineering – Focusing on next generation data platforms, architecture and implementation, making data available and trusted to deliver on AI priorities.
• Data Management & Strategy – Supporting our clients manage AI & Data Risk, define AI & Data Strategies, design Target Operating Models and enable Data Offices that prove transformational to their business.

Your key responsibilities include:

• Working as part of a delivery team on complex Financial Services data transformation programmes, including roles such as target state architecture scoping, data analysis, solution design, and end to end implementation management.
• Supporting the development of new EY data solutions and methods that will improve effectiveness and reduce costs of current practices.
• Supporting RFP responses as well as thought leadership articles that we issue to the market.

Experience in Data Platform Technologies, including some of the following capabilities:

• Understanding of Snowflake/Databricks architecture, including data warehousing concepts and data sharing capabilities.
• The ability to write SQL and/or Python queries for the purposes of transforming, joining and aggregating data.
• Ability to analyse datasets and generate insights using Snowflake and/or Databricks analytical tools and features.
• Practical knowledge of common data engineering and BI/data visualisation integrations such as dbt, Azure Data Factory, PowerBI and Sigma.
• Experience using native functionality to deploy and interact with Large Language Models.
• Ability to develop, test and deploy machine learning models.
• Work to ensure internal risk and admin processes are adhered to.
• Participate actively in the local Financial Services ecosystem, collaborating with our clients, FinTechs and Universities.

Skills and attributes for success:

• A passion for the delivery of data technology solutions that deliver positive outcomes for customers, regulators and shareholders.
• Advanced problem solving skills, relish working in high performing teams and an ability to communicate complex ideas effectively, both verbally and in writing.

To qualify for the role you must have some or all of the following:

• Demonstratable interest and awareness in data, AI & emerging technologies.
• Good problem solving, teamwork and communication skills, and an ability to communicate ideas effectively and clearly.
• 2+ years of FS experience in one of the following sectors: Banking, Capital Markets or Insurance.
• Good knowledge in at least one of our core AI & Data capabilities.
• Understanding of technology trends and implications on the FS industry, including data platforms, digital drivers, cloud architecture, integration tools & approaches.
• Some hands-on coding experience with SQL, Python or Scala would be advantageous but not compulsory.
• Relevant experience in Data Platform Technologies (knowledge of any or all including Snowflake, Databricks, Microsoft Fabric would be beneficial).
• Previous consulting experience would be a plus, but so would the curiosity and ambition to develop your career with a consulting role.

What we look for:

We are looking for highly motivated individuals who are passionate about AI and Data and want to assist clients to become truly data driven organisations. If you think you can meet the challenges of a focused consulting organisation, want to learn how to grow and lead in a large practice, deliver on Scotland’s vision for Financial Services and work in the most complex of sectors, our Edinburgh AI and Data team is looking forward to hearing from you.

What working at EY offers:

• A competitive remuneration package where you’ll be rewarded for your individual and team performance.
• Support for flexible working and career development.
• 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.