Application Support Engineer

Aberdeen Standard Investments; City of Edinburgh; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading investment firm in Edinburgh is seeking an Application Support Engineer to enhance and support critical investment application systems. This role demands strong SQL skills and the ability to work in a reactive support capacity across various time zones. Interested candidates should possess the ability to handle complex scenarios and ensure compliance in a financial context. A strong commitment to service quality is essential, along with the flexibility to adapt to various shift patterns.

Benefits

40 days annual leave

16% employer pension contribution

Private healthcare

Discretionary performance-based bonus

Gym discounts

Qualifications

• Experience in application support and maintenance.
• Familiarity with Financial Services and trading.
• Understanding of data warehousing and ELT/ETL processes.
• Ability to work independently in agile environments.

Responsibilities

• Support multi-slot batch and applications for Asset Management.
• Perform application recovery and incident management.
• Ensure rapid resolution of issues across global time zones.
• Collaborate with infrastructure specialists for fixes.

Skills

SQL proficiency

Analytical skills

Problem-solving skills

Strong communication

Proactive mindset

Tools

Autosys

Azure

ETL tools

Job description

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 Role & Department

We are seeking a proactive Application Support Engineer to join our Asset Management Technology team. This role is focused on supporting and enhancing our investment application systems which are critical components of our investment business. This includes support for real time trading as well as our multi slot investment batch applications. Batch and application support operates across APAC, EMEA and AMRS. You’ll work across a range of technologies, to a global delivery schedule, ensuring performance and availability of our applications and data flows. Due to our global delivery schedule, flexibility to work on-call and a variety of shift patterns will be essential.

In Investments Technology, our Asset Management Tribe supports the products and processes employed by our asset management business. The tribe comprises a number of squads who are responsible for developing, maintaining and supporting the critical suite of applications and technologies.

Key Responsibilities

• Provide time critical support and maintenance for multi-slot batch and applications which serve our global Asset Management business, ensuring rapid resolution and minimal impact to services and data integrity.
• Perform application recovery, incident management and conduct root cause analysis, debugging failures and applying fixes across the global time zones.
• Support scheduled release and deployment activities, including validation, rollback planning, and post-deployment monitoring.
• Evaluate infrastructure, system and third-party changes to identify potential impact to supported application services.
• Collaborate with infrastructure specialists to implement fixes and enhancements and participate in scheduled Disaster Recovery proving events during maintenance windows.
• Work seamlessly with service partners to ensure robust service levels are maintained.
• Produce and maintain technical documentation to support our production services.
• Develop, test and maintain application code, contributing to sprint activities as part of our application lifecycle management.

About the Candidate

The ideal candidate will possess the following:

• Experience of working in an application support and maintenance role.
• Strong proficiency in SQL for data querying, processing and performance tuning.
• Familiarity with Financial Services, preferably trading and the ability to ensure compliance throughout.
• Understanding of data warehousing, ELT/ETL processes, and data modelling.
• Experience using scheduling tools and in supporting applications running on Windows.
• A proactive mindset with a focus on service and customer impact.
• Performs consistently in time-sensitive and complex scenarios.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to work independently and within cross-functional teams using agile development.
• Flexible to work different shift patterns / be on an on-call rota

Desirable Skills

• Exposure to DevOps practices and tools (CI/CD, automation).
• Familiarity with Data/ETL tools and cloud platforms.
• Knowledge of Cloud-native development: Azure, Snowflake, ADF (Azure Data Factory) and DBT (Data Build Tool) for modular SQL development.
• Autosys scheduling and Ab Initio for ETL and batch processing as well as Markit EDM.
• Understanding of MQ (IBM MQ, ACE) for message-based integrations or equivalent.
• Understanding of Active Directory, Networks and PowerShell scripting or equivalent.

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; management information and accessibility can be provided on request.

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.

An inclusive way of working and an inclusive culture are central to who we are. Whatever way you like to work, if you have the talent and commitment to join our team, we’d like to hear from you. We’ve adopted a blended working approach, combining office collaboration with flexible work from home. If you need assistance with your application, or a reasonable adjustment to your interview arrangements, please let us know.

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 and welcome 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.