Data Modeller

Aberdeen Standard Investments; City Of London; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

A leading investment firm in London seeks a versatile Data Modeller to drive client-focused data capabilities. The ideal candidate will thrive in agile environments and possess skills in data modelling, SQL/Python, and effective communication. This role offers opportunities for career growth and promotes a collaborative culture.

Benefits

40 days’ annual leave

16% employer pension contribution

Discretionary performance-based bonus

Private healthcare

Gym discounts

Season ticket loans

Qualifications

• Experience with data modelling tools and techniques.
• Ability to communicate complex ideas clearly.
• Strong collaboration skills in agile environments.

Responsibilities

• Define scalable data strategies and models.
• Ensure compliance with governance and standards.
• Translate requirements into actionable specifications.
• Provide data insights throughout the delivery lifecycle.
• Engage with stakeholders on data needs.

Skills

Data modelling tools (e.g., ER/Studio, ERwin, UML)

SQL/Python proficiency

Data manipulation

Knowledge of Snowflake & Azure

Data architecture principles

Communication of technical ideas to non-technical stakeholders

Collaboration in agile environments

Job description

Overview

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 of which focuses on meeting and adapting to our clients’ evolving needs:

• interactive investor, the UK’s second largest direct-to-consumer investment platform, enables individuals in the UK to plan, save, and invest in the way that works for them.

• Our Adviser business provides financial planning solutions and technology for UK financial advisers, enabling them to create value for their customers.

• Our Investments business is a specialist asset manager that focuses on areas where we have both strength and scale to capitalise on the key themes shaping the market, through either public markets or alternative asset classes.

About the Department

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

About the Role

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

Key Responsibilities

• Collaborate with architects and Domain leadership to define scalable data strategies and models that support 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 the following:

• 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 communicator who can simplify complexity for diverse audiences.

• Thrive in agile, collaborative environments and enjoy continuous learning.

We are proud to be a Disability Confident Committed employer. If you have a disability and would like to apply to one of our UK roles under the Disability Confident Scheme, please notify us by completing the relevant section in our candidate questionnaire. One of our team will reach out to support you through your application process.

Our benefits

There\'s more to working life than coming home with a good salary. We have an environment where you can learn, get involved and be supported.

When you join us, your reward will be one of the best around. This includes 40 days’ annual leave, a 16% employer pension contribution, a discretionary performance-based bonus (where applicable), private healthcare and a range of flexible benefits – including gym discounts, season ticket loans and access to an employee discount portal. You can read more about our benefits here.

Our business

Enabling our clients to be better investors drives everything we do. Our business is structured around three distinct areas – our vectors of growth – focused on our clients’ changing needs. You can find out more about what we do here.

An inclusive way of working

Whatever way you like to work, if you have the talent and commitment to join our team, we’d like to hear from you.

At Aberdeen we’ve adopted a ‘blended working’ approach. This approach combines the benefits of face-to-face collaboration, coaching and connecting in our offices with the flexibility of working from home. It enables colleagues to find a balance that works for their roles, their teams, our clients and our business.

An inclusive culture, where diverse perspectives drive our actions, is at the core of who we are and what we do. If you need assistance with your application, or a reasonable adjustment to your interview arrangements – for example, because you are neurodivergent, or have a physical, sensory, cognitive, mental, visible or invisible disability – please let us know and we’ll be happy to help.

We’re committed to providing an inclusive workplace where all forms of difference are valued and which is free from any form of unfair or unlawful treatment. We define diversity in its broadest sense – this includes but is not limited to our diversity of educational and professional backgrounds, experience, cognitive and neurodiversity, age, gender, gender identity, sexual orientation, disability, religion or belief and ethnicity and geographical provenance. We support a culture that values meritocracy, fairness and transparency and welcomes enquiries from everyone. If you need assistance or an adjustment due to a disability please let us know as part of your application and we will assist.