Data Modeller

abrdn; London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading wealth & investments group in London is seeking a versatile Data Modeller to support client-focused outcomes through data capabilities. The successful candidate will collaborate with architects to define data strategies, design data models, and ensure compliance with governance standards. Ideal applicants should have experience with modelling tools, proficiency in SQL/Python, and good communication skills to convey complex ideas clearly. The role offers an agile working environment with excellent benefits.

Benefits

40 days’ annual leave

16% employer pension contribution

Discretionary bonuses

Private healthcare

Flexible benefits

Qualifications

• Experience with data modelling tools and techniques (e.g., ER/Studio, ERwin, UML).
• Proficiency in SQL/Python and data manipulation.
• Knowledge of Snowflake & Azure.
• Understanding of data architecture principles and data governance.
• Good understanding of database management and design best practices.

Responsibilities

• Collaborate with architects to define scalable data strategies and models.
• Identify opportunities to enhance existing data assets.
• Design and maintain data models, translating requirements into specifications.
• Provide data insights throughout the delivery lifecycle.
• Engage with stakeholders to meet data needs.

Skills

Data modelling tools and techniques

SQL

Python

Snowflake

Azure

Communication

Job description

Social network you want to login/join with:

At Aberdeen, our ambition is to be the UK’s leading Wealth & Investments group.

Strengthening talent and culture is one of our strategic priorities. We strive to make Aberdeen a great place to work so that we can attract and retain the industry’s best talent.

Our people put our stakeholders at the heart of everything they do by helping us to make a positive difference to the lives of our clients, customers, colleagues, shareholders, and society.

We are focused on growing our direct and advised wealth platforms and repositioning our specialist asset management business to meet client demand. We are committed to providing excellent client service, supported by leading technology and talent.

Aberdeen comprises three businesses: interactive investor (ii), Investments, and Adviser, each focusing on meeting and adapting to our clients’ evolving needs:

• interactive investor: the UK’s second-largest direct-to-consumer investment platform, enabling individuals in the UK to plan, save, and invest in ways that suit them.
• Our Adviser business: provides financial planning solutions and technology for UK financial advisers, creating value for their customers.
• Our Investments business: a specialist asset manager focusing on key market themes through public markets or alternative asset classes.

About the Department

The Client Domain is responsible for shaping data capabilities that drive client-focused outcomes. It works closely with architects, technical leads, and business stakeholders to design, evolve, and communicate data models supporting digital and analytical solutions.

About the Role

We’re seeking a versatile and collaborative Data Modeller to join the Client Domain. This role suits someone who thrives in agile environments, enjoys working across strategic and technical domains, and is passionate about shaping data capabilities that support client outcomes.

Key Responsibilities

• Collaborate with architects and domain leadership to define scalable data strategies and models supporting business objectives and future readiness.
• Identify opportunities to reuse and enhance existing data assets, ensuring compliance with governance, security, and regulatory standards.
• Design and maintain conceptual, logical, and physical data models, translating requirements into actionable specifications.
• Provide data insights and modelling support throughout the delivery lifecycle, participating in agile ceremonies.
• Engage with stakeholders to understand and address data needs, ensuring alignment with agile methodologies and technical solutions.

About the Candidate

The ideal candidate will possess:

• Experience with data modelling tools and techniques (e.g., ER/Studio, ERwin, UML, etc.).
• Proficiency in SQL/Python and data manipulation.
• Knowledge of Snowflake & Azure.
• Understanding of data architecture principles and data governance.
• Good understanding of database management, design best practices, and enterprise-level data architecture.
• Ability to communicate complex technical ideas clearly to non-technical stakeholders.
• Strong communication skills to simplify complexity for diverse audiences.
• Ability to thrive in agile, collaborative environments and a passion for continuous learning.

We are proud to be a Disability Confident Committed employer. If you have a disability and wish to apply under the Disability Confident Scheme, please notify us via the candidate questionnaire. Our team will support you through your application.

We offer an environment where you can learn, get involved, and be supported, with benefits including 40 days’ annual leave, a 16% employer pension contribution, discretionary bonuses, private healthcare, and flexible benefits such as gym discounts, season ticket loans, and access to an employee discount portal.

Our Business

Our focus is enabling clients to be better investors. Our business is structured around three growth vectors, tailored to our clients’ changing needs.

An Inclusive Way of Working

We embrace a ‘blended working’ approach, combining face-to-face collaboration with flexible remote work, supporting a balance that benefits roles, teams, clients, and the business.

At Aberdeen, diverse perspectives are at the core of our actions and success.