Lead Data Analyst

Aberdeen; City of Edinburgh; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A leading investments firm in the UK seeks a Lead Analyst to drive complex analytical projects and mentor team members. The ideal candidate excels in DAX, SQL, and Python, with experience in developing Power BI dashboards. This role offers substantial annual leave and a comprehensive benefits package in a blended working environment.

Benefits

40 days annual leave

16% employer pension contribution

Private healthcare

Gym discounts

Access to an employee discount portal

Qualifications

• Strong proficiency in DAX, SQL and/or Python.
• Experience developing and optimising Power BI dashboards.
• Solid understanding of data architecture and modelling principles.

Responsibilities

• Lead delivery of complex analytics projects.
• Build and optimise Power BI dashboards.
• Translate data into actionable insights.

Skills

DAX

SQL

Python

Communication

Stakeholder engagement

Tools

Power BI

Microsoft Fabric

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.

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

The Data Insights Team plays a critical role in enabling data-driven decision-making across the organisation. We deliver high-impact analytics, build scalable data products, and foster a culture of insight-led thinking. Our work supports strategic priorities and helps elevate analytical maturity across Aberdeen.

About The Role

As a Lead Analyst, you’ll lead complex analytical projects, mentor junior team members, and act as a trusted partner to stakeholders. This role blends hands-on technical delivery with leadership and team enablement, helping embed a data-driven culture and drive continuous improvement.

Key Responsibilities

• Lead delivery of complex analytics projects, ensuring outputs are robust, scalable, and aligned with business needs.
• Build and optimise Power BI dashboards and data models using advanced DAX, SQL, and/or Python.
• Translate data into actionable insights through compelling narratives and visualisations.
• Collaborate with stakeholders to shape technical solutions and communicate outcomes clearly.
• Ensure analytics outputs meet governance, privacy, and compliance standards.
• Promote reusable data assets and support documentation of data definitions.
• Mentor Analysts and Senior Analysts, fostering a collaborative and high-performing team culture.
• Champion best practices and explore emerging technologies like AI to enhance insight generation.

About The Candidate

The ideal candidate will have:

• Strong proficiency in DAX, SQL and/or Python.
• Experience developing and optimising Power BI dashboards and data models.
• Solid understanding of data architecture and modelling principles.
• Familiarity with Microsoft Fabric and cloud-based data platforms (desirable).
• Knowledge of data governance and compliance standards.
• Excellent communication and stakeholder engagement skills.
• Proven ability to lead, mentor, and drive continuous improvement.

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.

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.

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.