Lead Analytics Engineer

Dexters is London’s leading independent estate agency. We rely on accurate, timely and well-designed management information to understand performance across a large and growing business.

We are looking for a Lead Analytics Engineer to take technical ownership of our BI and analytics capability, with particular responsibility for reliable semantic models, consistent business metrics and high-quality Power BI solutions.

This is a senior, hands-on role combining strong BI expertise with the ability to structure data around meaningful commercial questions.

Location: Clapham Junction

Salary: £80,000-£90,000 DOE

Key responsibilities:

• Lead the technical design of Dexters’ BI and analytics solutions.

• Own the definition and implementation of core business metrics, ensuring they are consistent, traceable and reconciled across models and reports.

• Design scalable dimensional and semantic models for reliable, consistent reporting.

• Establish validation and reconciliation controls to ensure reporting outputs are complete and accurate.

• Own Power BI standards across development, deployment, performance and governance.

• Build complex analytical solutions using DAX, SQL and appropriate transformation tools.

• Translate complex business requirements into well-structured analytical solutions.

• Improve the performance and maintainability of existing Power BI datasets and reports.

• Design and maintain appropriate row-level security and access models.

• Work with Data Engineers to ensure analytical requirements are reflected correctly in the underlying data platform.

• Reduce duplicated business logic through reusable metrics and shared models.

• Provide technical review and mentoring for colleagues developing BI solutions.

• Work directly with senior stakeholders to understand business questions and challenge requirements where appropriate.

• Communicate assumptions, risks and delivery timescales clearly.

What we are looking for:

• Deep practical experience with Power BI in a complex business environment.

• Advanced DAX and strong SQL skills.

• Excellent understanding of dimensional modelling, star schemas and semantic model design.

• Experience creating shared or enterprise analytical models rather than isolated dashboards.

• Strong understanding of Power BI performance, RLS and governance.

• Strong approach to data validation, reconciliation and quality assurance.

• Ability to turn ambiguous business questions into robust analytical solutions.

• Strong commercial judgement and attention to detail.

• Excellent communication skills and confidence working directly with senior stakeholders.

• A track record of raising standards and developing the capability of others.

Experience with Snowflake and dbt would be highly advantageous.