Data Engineer

Aberdeen; City of Edinburgh; Hybrid; GBP 50,000 - 90,000; Full time

Job summary

An established industry player is seeking a Senior Data Engineer to develop a centralized data model that enhances insights and reporting. This role is pivotal in driving data-driven decision-making and requires a blend of technical expertise and strong stakeholder relationships. You will work in a collaborative environment, mentoring junior team members while ensuring data quality and governance. Join a forward-thinking company that values continuous learning and offers a supportive workplace culture, with flexible working arrangements and a comprehensive benefits package.

Benefits

40 days annual leave

16% employer pension contribution

Discretionary performance-based bonus

Private healthcare

Gym discounts

Season ticket loans

Employee discount portal access

Qualifications

• Expert in Microsoft Azure Stack and data tools like SQL and Python.
• Experience delivering data models in visualization tools like Power BI.

Responsibilities

• Deliver high-quality data models and maintain datasets.
• Ensure compliance with data governance and security policies.

Skills

Microsoft Azure Stack

SQL

Excel

Python

Data Visualization (Power BI)

Analytical Thinking

Problem-Solving

Job description

Job Description

We are a global investment company that helps clients and customers to plan, save and invest for the future. By doing so, we enable our clients and customers to be better investors. 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.

Aberdeen comprises three businesses, Investments, Adviser and interactive investor (ii), each of which focuses on meeting and adapting to our clients’ evolving needs.

• Investments manage £368bn of client assets, offering investment capabilities built on the strength of our insights from wide-ranging research, worldwide investment expertise and local market knowledge.
• Adviser provides financial planning solutions and technology to over half of the UK’s financial advisers, enabling them to create value for their businesses and clients.
• ii, the UK’s second-largest direct-to-consumer investment platform, helps over 430,000 individual customers to plan, save and invest in the way that works best for them
  
  

About The Department

The Data Engineering team sits within the wider Data & Analytics function at Aberdeen, delivering high-quality reporting, analytics, and insights to key stakeholders. The team is focused on ensuring our data can be taken from source systems and joined together to create powerful data sets for use by the analytics team and the wider business.

About The Role

We are looking for a talented Senior Data Engineer to help develop a new centralised “single view” data model. This will be used to deliver new and improved insight and reporting to our key stakeholders. This opportunity is perfect for someone looking to fast-track their personal development whilst putting their own stamp on our approach to data and analytics.

This role will play a critical part in driving data-driven decision-making and innovation within the company. It requires someone who has strong technical skills whilst being entrepreneurial and proactive, with the ability to develop key stakeholder relationships quickly. You will also need to be a team player and collaborator, working across multi-discipline teams and be confident working with other technical specialists and analysts.

Your primary responsibility will be to develop a multi sourced data model that can be used to create and delivery specific reporting data models that will be used for dashboards, reporting, and insights. The analytics this supports will drive tangible value and change for our clients and our business. You will need to blend a mix of back-end and front-end data engineering to produce well governed and scalable data models.

Key Responsibilities

• Deliver high quality and high impact data models.
• Analysing raw data and developing and maintaining datasets.
• Improving data quality and efficiency and building pipelines.
• Ensuring compliance with data governance and security policies.
• Work closely with all stakeholders, ensuring they are managed effectively, and that communication is timely and informative.
• Identify new ways of using our data sources and help shape our data strategy.
• Mentoring junior team members and the wider business community.
  
  

About The Candidate

The ideal candidate will possess the following:

Technical Skills

• Expert in the Microsoft Azure Stack.
• Experience using data tools such as SQL, Excel, or Python.
• Expertise in delivering data models within data visualisation tools, ideally with Power BI exposure.
  
  

Business Skills

• Strong communication and organisation skills.
• Strong analytical thinking and problem-solving skills.
• Ability to work in a fast-paced environment, prioritise tasks, and meet deadlines.
• Strong attention to detail.
• A passion for continuous learning and self-improvement.
  
  

Experience

• Significant experience in data and analysis with a track record of value-add deliveries.
• Previous experience in financial services or with market data is desirable.
  
  

We are a Disability Confident Committed employer and are happy to provide adjustments to the recruitment process to support candidates.

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.