Data Modeller - Edinburgh
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.
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.
The Data Platform team sits within the Investments business and plays a pivotal role in bridging the gap between business and data. It supports the adoption of a Data Mesh architecture and a Modern Data Stack to enable scalable, federated data development and delivery across Aberdeen.
We are seeking an experienced and detail-oriented Data Modeller to join our modern data platform team. This role is critical in shaping the data architecture and modelling standards that underpin our analytics and reporting capabilities. You will work closely with data engineers, platform teams, and business stakeholders to design and implement robust data models that support enterprise-wide data initiatives.
Design and maintain conceptual, logical, and physical data models.
Develop and implement Data Vault 2.0 models for scalable and auditable data warehousing.
Collaborate with engineering teams to implement models using DBT, Snowflake, Azure Data Factory, and Microsoft Fabric.
Translate business requirements into robust data models.
Ensure alignment with data governance, quality, and security standards.
Provide technical guidance on data modelling best practices.
Proven experience in data modelling across conceptual, logical, and physical layers.
Strong expertise in Data Vault modelling (preferably DV 2.Experience with semantic modelling for BI tools (e.g., Power BI, Fabric).
Hands-on experience with Azure Data Factory, Snowflake, DBT, and Microsoft Fabric.
Understanding of Data Mesh principles and domain-oriented data product design.
Familiarity with data governance, metadata management, and data quality frameworks.
Experience in financial services, ideally asset management.
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. There's more to working life than coming home with a good salary. 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. Whatever way you like to work, if you have the talent and commitment to join our team, we’d like to hear from you.
This approach combines the benefits of face-to-face collaboration, coaching and connecting in our offices with the flexibility of working from home. 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 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. If you need assistance or an adjustment due to a disability please let us know as part of your application and we will assist.