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.