Lead Data Analytics & Power BI Architect

Aberdeen Standard Investments; City of Edinburgh; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading financial services group in Edinburgh is seeking a Lead Analyst to lead complex analytics projects and mentor junior team members. The ideal candidate will have strong skills in DAX, SQL, and Python, along with experience in developing Power BI dashboards. The position emphasizes collaboration and embedding a data-driven culture within the organization. Attractive benefits include extensive leave and a pension contribution.

Benefits

40 days annual leave

16% employer pension contribution

Discretionary performance-based bonus

Private healthcare

Gym discounts

Employee discount portal

Qualifications

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

Responsibilities

• Lead delivery of complex analytics projects aligned with business needs.
• Build and optimise Power BI dashboards and data models.
• Translate data into actionable insights through narratives and visualisations.

Skills

DAX

SQL

Python

Communication

Stakeholder engagement

Tools

Power BI

Microsoft Fabric

Job description

A leading financial services group in Edinburgh is seeking a Lead Analyst to lead complex analytics projects and mentor junior team members. The ideal candidate will have strong skills in DAX, SQL, and Python, along with experience in developing Power BI dashboards. The position emphasizes collaboration and embedding a data-driven culture within the organization. Attractive benefits include extensive leave and a pension contribution.