Engineer (Data Platform)

Job Description
We are seeking a Data Engineer to be based in our Edinburgh office with hybrid working (3 days a week in office) + excellent benefits
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 Role
The role is for an Engineer with practical experience spanning 2+ years, joining the Development Chapter within the Asset Management Tribe. Reporting to the Chapter Lead, you'll work in a cross-functional team to design, develop, and support systems critical to investment operations and reporting. The focus is on building and maintaining data platforms and pipelines that power investment data products used across the organization for portfolio management, analytics, and regulatory reporting. Key responsibilities include developing robust, scalable solutions, ensuring data quality and performance, integrating with cloud-native platforms, and contributing to data architecture. Strong skills in data modelling, transformation, governance, and collaboration in an Agile environment are essential.

Key Responsibilities

• Design, develop, and maintain robust, scalable data pipelines and services that support investment data products and reporting platforms.
• Build and optimise data integration workflows using tools such as Azure Data Factory, Synapse Pipelines, and SQL/T-SQL, ensuring data quality, performance, and reliability.
• Contribute to the evolution of our cloud-native data architecture, leveraging Azure Databricks, Azure Data Lake, and Snowflake where appropriate.
• Apply strong data modelling and transformation skills to support analytics, regulatory reporting, and operational use cases.
• Promote and implement engineering best practices, including test automation, unit testing, and CI/CD pipelines.
• Ensure observability and operational readiness of data solutions, including logging, monitoring, and Level 3 production support.
• Support data governance and metadata management initiatives to ensure data integrity and compliance.
• Explore and apply AI-assisted development tools (e.g. GitHub Copilot) and automation to improve engineering efficiency and solution quality.
• Participate in Agile ceremonies and contribute to continuous delivery and iterative improvement of our data platforms.
• Participate in code reviews, pair programming, and knowledge sharing.
• Drive continuous improvement in development tools, processes, and team ways of working.

About The Candidate
We are looking for a highly capable and detail-oriented engineer who thrives on working with complex, high-volume data systems. You should have a track record of building and maintaining data platforms that are not only robust and scalable, but also efficient and cost-effective. Your ability to understand and optimise data flows—especially those that are critical to daily and intraday investment operations—will be key to your success in this role.

You will be someone who takes pride in writing clean, performant code and designing modern data solutions that stand up to the demands of a fast-paced, data-driven environment. You should be comfortable navigating large datasets, applying best practices in data modelling and transformation, and leveraging cloud-native tools to deliver solutions that are both technically sound and operationally sustainable. A mindset focused on automation, observability, and continuous improvement is essential, as is the ability to collaborate effectively with both technical and non-technical stakeholders.

Essential Skills & Experience

• Experience in Asset Management or Finance Technology
• Experience in SQL
• Solid understanding of ETL development, data modelling, and data governance
• Familiarity with DevOps tooling and CI/CD pipelines
• Strong foundation in software development practices, including unit testing
• Experience with code deployment and production support

Other Desirable Skills & Experience

• Experience with Azure Databricks, Azure Data Lake, and Snowflake
• Experience in Python for data engineering and transformation
• Experience with Azure Data Factory and Synapse Pipelines
• Exposure to Azure App Services, Key Vault, and Azure Function Apps
• Experience with batch processing tools such as AutoSys, Control M
• Familiarity with Power BI and DBT
• Knowledge of REST API, JSON, XML, and XSLT
• Experience with test automation frameworks and test-driven development
• Awareness of MS Fabric, Data Vault, and PowerShell
• Exposure to GitHub Copilot or similar AI-assisted development tools
• Experience working with Security Master data
• Experience with SSIS, Markit EDM, or other data integration platforms
• Familiarity with VBA, Ab Initio, or observability tooling

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.