Lead Data Analyst

Data Idols; Greater London; Hybrid; GBP 75,000 - 85,000; Full time

Job summary

Data Idols is seeking a Lead Data Analyst in London with a strong hands-on background to shape analytics and AI solutions across Fabric, Databricks, and Power BI. You will lead the design of scalable data architectures and collaborate with analytics teams and stakeholders to deliver value at scale.

The role combines technical delivery with strategic direction, enabling governance, security, and reusable patterns across analytics platforms while staying close to latest AI-enabled analytics

Qualifications

• Excellent SQL skills.
• Strong experience with Power BI.
• Experience with Microsoft Fabric and Azure Databricks.
• Knowledge of dimensional modelling and semantic models.

Responsibilities

• Design scalable analytics solutions for enterprise-scale needs.
• Partner with analytics teams, data engineers, platform engineers and stakeholders to shape data architectures.
• Establish reusable analytics standards, best practices, and patterns.
• Deliver hands-on analytics work while guiding solution design and delivery at scale.

Skills

SQL

Power BI

Microsoft Fabric

Azure Databricks

Dimensional modelling

Semantic models

Analytics data architecture

Stakeholder management

Tools

Microsoft Fabric

Azure Databricks

Power BI

Job description

The Opportunity

Lead Data Analyst

Location: London | Hybrid

Salary: £75,000 - £85,000

Data Idols are working with a leading organisation that is continuing to invest in and modernise its data and analytics capabilities. They are looking for a Lead Data Analyst to play a key role in shaping how analytics solutions are designed, built and scaled across the business.

This is a highly technical role offering the opportunity to work across modern analytics and AI technologies, combining hands‑on expertise with solution design, technical leadership and stakeholder engagement.

The Opportunity

As a Lead Data Analyst, you'll help shape the technical direction of analytics and AI solutions, working across Microsoft Fabric, Azure Databricks, and Power BI.

You’ll partner with analytics teams, data engineers, platform engineers and business stakeholders to design scalable analytics solutions and AI‑ready data architectures. This will include working across data structures, semantic models, metric layers and dimensional modelling. You’ll also help establish reusable standards and best practices across analytics, supporting teams to deliver solutions that are scalable, secure, governed and aligned with wider business objectives.

Skills and Experience

• Strong experience designing and delivering enterprise-scale analytics solutions
• Excellent SQL skills
• Strong experience with Power BI
• Experience working with Microsoft Fabric and Azure Databricks
• Strong knowledge of dimensional modelling, semantic models and analytics data architecture
• Experience establishing analytics standards, best practices and reusable technical patterns
• Ability to combine strategic thinking with hands‑on technical delivery
• Strong stakeholder management skills

If you're an experienced analytics professional looking for a role where you can remain technically hands‑on while influencing how modern analytics and AI solutions are designed and delivered at scale, we'd love to hear from you.

Lead Data Analyst