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 UKs 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 industrys 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 UKs 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 youll 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 asAzure Data FactorySynapse Pipelines andSQL/T-SQL ensuring data quality performance and reliability.
• Contribute to the evolution of our cloud-native data architecture leveragingAzure Databricks Azure Data Lake andSnowflakewhere appropriate.
• Apply strong data modelling and transformation skills to support analytics regulatory reporting and operational use cases.
• Promote and implement engineering best practices includingtest automationunit testing andCI/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 flowsespecially those that are critical to daily and intraday investment operationswill 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 orFinance Technology
• Experience inSQL
• Solid understanding ofETL developmentdata modelling anddata governance
• Familiarity withDevOps toolingandCI/CD pipelines
• Strong foundation insoftware development practices includingunit testing
• Experience withcode deploymentand production support

Other Desirable Skills & Experience

• Experience withAzure DatabricksAzure Data Lake andSnowflake
• Experience inPythonfor data engineering and transformation
• Experience withAzure Data FactoryandSynapse Pipelines
• Exposure toAzure App ServicesKey Vault andAzure Function Apps
• Experience withbatch processingtools such asAutoSys Control M
• Familiarity withPower BIandDBT
• Knowledge ofREST APIJSONXML andXSLT
• Experience withtest automation frameworksandtest-driven development
• Awareness ofMS FabricData Vault andPowerShell
• Exposure toGitHub Copilotor similar AI-assisted development tools
• Experience working withSecurity Masterdata
• Experience withSSISMarkit EDM or other data integration platforms
• Familiarity withVBAAb 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

Theres 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 benefitshere.

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 dohere.

An inclusive way of working

Whatever way you like to work if you have the talent and commitment to join our team wed like to hear from you.

At Aberdeen weve 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 well be happy to help.

Were 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.