Data Platform Engineer

Job Description

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

Join Aberdeen’s Investments department, where we help clients plan and invest with confidence for a brighter future. Our dynamic Data Tribe, led by the Chief Data Officer, is revolutionizing data accessibility and innovation through a cutting-edge Data Mesh architecture. Collaborate with passionate teams to unlock powerful data insights that drive sustainable investment and fuel scalable growth. Be part of a forward-thinking environment making a real impact.

About the Role

As a Data Platform Engineer at Aberdeen, you will be at the heart of building and evolving a modern, cloud-based data platform using Azure, Snowflake, DBT, and Microsoft Fabric. Working within a Data Mesh architecture, you will enable decentralized data ownership and empower domain teams through self-service data capabilities. Your expertise will drive the design, implementation, and automation of scalable, secure data solutions, ensuring high performance, governance, and compliance. This is a pivotal role where you will collaborate closely with cross-functional teams to deliver innovative data products that fuel business growth and unlock meaningful insights.

Key Responsibilities

About the Candidate

• Design and implement a Data Mesh architecture, enabling decentralized data ownership and collaboration across domain teams.

• Develop and maintain scalable cloud data infrastructure using Azure, Snowflake, DBT, and Microsoft Fabric, ensuring performance and automation.

• Build self-service data platforms and automate data pipelines to empower domain teams to manage their own data products independently.

• Collaborate with teams to define data product standards, governance policies, and ensure compliance with security and regulatory requirements.

• Optimize data warehousing and orchestration workflows for efficiency, cost-effectiveness, and reliability across distributed data products.

• Provide technical guidance, monitoring, and support to domain teams, fostering knowledge sharing and continuous improvement.

The ideal candidate will possess the following:

• Strong hands-on experience with Azure services, including resource groups, networking, Data Factory, Key Vault, and Azure Fabric.

• Proven expertise in Snowflake administration, including database/user management, warehouses, role-based access control, and data sharing.

• Solid experience with DBT for data transformation, including best practices for modular, testable, and version-controlled data models.

• Proficiency in infrastructure-as-code deployments, especially using Terraform for Azure, Snowflake, and related platforms.

• Experience with Azure DevOps CI/CD pipelines, including YAML pipeline creation, artifact management, and automated secrets handling.

• Good scripting skills in SQL, PowerShell, and Python, combined with a strong understanding of security, compliance, and agile delivery methodologies.About the department
   

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.