Lead Analytics Engineer
Full Job Posting
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.
Qualifications
- Experience with Snowflake and dbt would be highly advantageous.
About Dexters
Independent London estate agency providing residential sales, lettings, management, and chartered surveying to buyers, sellers, landlords, and tenants.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Dexters
Entry Level Administrator
, GBR
An ‘on the job’ training opportunity, learning the basics of our Tenancy Management department whilst carrying out the role. As part of the Tenancy and Property Management Teams, provide consistently excellent service to
Lead Data Engineer
, GBR
Dexters is London’s leading independent estate agency. With a fast-paced environment and continuous growth strategy, high-quality data is increasingly fundamental to how we operate, measure performance and make decisions
Business Development Consultant
, GBR
We’re looking for a confident, ambitious Business Development Consultant to join our growing team and play a key role in generating new business across our sales and lettings offices. You’ll be someone who enjoys speakin
Senior Data Engineer
, GBR
Dexters is London’s leading independent estate agency. Continued growth through acquisitions, systems development and business transformation creates complex data engineering, migration and integration challenges. We are
Trainee Estate Agent Twickenham
, GBR
Are you great with people? Do you enjoy building relationships and have the ambition to grow your career? If so, we want you to join our team! Whether or not you have property experience, we’re looking for a bubbly perso
Entry Level Administrator
, GBR
An ‘on the job’ training opportunity, learning the basics of Tenancy Administration whilst carrying out the role. As part of the Tenancy and Property Management Teams, provide consistently excellent service to drive the
Graduate Analyst (M&A and FP&A)
, GBR
Dexters is seeking a high-calibre graduate to join its fast-growing Finance and M&A team. This role is ideal for an ambitious university leaver eager to gain hands-on experience in mergers and acquisitions, financial pla
Office Support Coordinator Lewisham
, GBR
If you're looking to kick start your career in the property industry, look no further! We have a fantastic opportunity as an Office Administrator, to support our busy teams. A great foot in the door and the chance to pro
Entry Level Administrator
, GBR
Lead Data Engineer
, GBR
Business Development Consultant
, GBR
Senior Data Engineer
, GBR
Trainee Estate Agent Twickenham
, GBR
Entry Level Administrator
, GBR
Graduate Analyst (M&A and FP&A)
, GBR
Office Support Coordinator Lewisham
, GBR