Senior Consultant - Data Engineering

The opportunity

In this AI & Data consulting role, you will work 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

Work as part of a delivery team on complex Financial Services data transformation programmes. A typical programme can include roles such as target state architecture scoping, data analysis, solution design, and end to end implementation management. As a Senior Consultant you will be a vital part of the delivery team on any or all of those roles as you develop your practical experiences with Data Platform solutions.

Support the development of new EY data solutions and methods that will improve effectiveness and reduce costs of current practices. 
Support 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 basic 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 as we advance Scotland’s position as a world leader in Financial Services.

Skills and attributes for success
We’re looking for people with a passion for the delivery of data technology solutions that deliver positive outcomes for customers, regulators and shareholders. You should have advanced problem solving skills, relish working in high performing teams and 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 Data Architecture & Data Engineering 
Data Management & Strategy Understanding of technology trends and implications on the FS industry, including data platforms, digital drivers, cloud architecture, integration tools & approaches AI methods & techniques and the challenges faced in establishing effective delivery of value across the business 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 
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.