Data Modeler, Abrdn
Savings & investment company
Open for applications
Savings & investment company
501-1000 employees
Open for applications
501-1000 employees
Company mission
Helping clients to prepare for the future
Role
Who you are
- Proven experience in data modelling across conceptual, logical, and physical layers
- Strong expertise in Data Vault modelling (preferably DV 2.0)
- 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
- Strong communication and collaboration skills
What the job involves
- 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
Application process
- End Date: October 6, 2025
Our take
Abrdn, formerly known as Standard Life Aberdeen, is a global investment company helping its clients to save and invest for their futures. It operates three businesses - Investments, Adviser and Personal - and has been operating since way back in 1825.
Nowadays, atop its investment and advice services, the company delivers two platforms for financial advisers. The first, Wrap, enables users to build and manage portfolios for each client. It also includes SIPP drawdown capabilities - which means advisers can choose the best platform charges when client assets are at their highest. The second, Elevate, encompasses a suite of tools for advisers to save time and make sure their clients are informed.
In 2023, Abrdn announced "adviserOS", which represents an upgrade to their platform offerings. There is limited information to go on, but the company claims this new venture will be simpler and data-led, as well as require less admin. It will be interesting to see if this new release keeps pace with tech developments across the investment space and allows abrdn to continue as an innovator.
Freddie
Company Specialist at Welcome to the Jungle
Insights
Company
Company HQ
Edinburgh New Town, Edinburgh, UK
Leadership
Jason Windsor
(CEO)Previously CFO at Persimmon Homes, Group CFO at Aviva and was the Managing Director of Morgan Stanley.
Salary benchmarks
We don't have enough data yet to provide salary benchmarks for this role.
Submit your salary to help other candidates with crowdsourced salary estimates.
Share this job
View 38 more jobs at Abrdn