Senior Consultant, Data Management and Strategy, BCM, FS, Edinburgh

EY; City Of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A global consulting firm is seeking a Senior Consultant for their AI & Data team in Edinburgh. Ideal candidates will have over 2 years of experience in Financial Services, proficiency in data platforms like Snowflake and Databricks, and skills in SQL and Python. The role involves collaborating with clients to solve complex business challenges and driving innovative data solutions. Competitive compensation and a commitment to professional development are provided.

Benefits

Continuous learning

Flexible tools and impact

Transformative leadership

Diverse and inclusive culture

Qualifications

• Demonstrable interest in AI and emerging technologies.
• Ability to communicate complex ideas clearly and effectively.
• Experience in the Financial Services sector.

Responsibilities

• Work on complex Financial Services data transformation programmes.
• Support development of new data solutions.
• Engage with clients to enhance business problem-solving.

Skills

Problem solving

Teamwork

Communication

Data analysis

SQL

Python

Education

2+ years of FS experience

Tools

Snowflake

Databricks

PowerBI

SQL

Python

Job description

At EY, we’re all in to shape your future with confidence.

We’ll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.

Join EY and help to build a better working world.

Senior Consultant, AI & Data, Financial Services, Data Platforms, 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, 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 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 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

• 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.

EY | Building a better working world

EY is building a better working world by creating new value for clients, people, society and the planet, while building trust in capital markets.

Enabled by data, AI and advanced technology, EY teams help clients shape the future with confidence and develop answers for the most pressing issues of today and tomorrow.

EY teams work across a full spectrum of services in assurance, consulting, tax, strategy and transactions. Fueled by sector insights, a globally connected, multi‑disciplinary network and diverse ecosystem partners, EY teams can provide services in more than 150 countries and territories.