Lead Data Analyst

Wates; Leatherhead; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading construction and property services company seeks a skilled Lead Data Analyst to join their Data & Analytics team in Leatherhead. The position includes transforming complex datasets, implementing robust models in Azure and Power BI, and ensuring adherence to development standards. You will create training materials and manage data projects. This hybrid role does require some in-office work and offers competitive benefits including extensive corporate perks like private medical coverage and professional development opportunities.

Benefits

Private Medical

Pension (8% employer contribution)

Health and Wellness programme

26 days holiday + bank holidays

Industry-leading family leave benefits

Qualifications

• Proven ability to engineer and transform raw data into optimised data models within Azure and Power BI.
• Strong background in data analysis, modelling, and visualisation.
• Expert in DAX, SQL, Python, and data notebooks.

Responsibilities

• Transform raw datasets into structured data models within Azure and Power BI.
• Oversee the full development lifecycle from design to sign-off.
• Create and deliver training materials promoting a data-driven culture.

Skills

Data analysis

SQL

DAX

Python

Data modelling

Azure

Power BI

Education

Degree in Information Technology, Computer Science, Data Analytics, or related field

Tools

Power BI

Azure Data Lake

SQL Server

Azure Synapse

Job description

We are seeking a highly skilled Lead Data Analyst to join our growing Data & Analytics team. This is a technical leadership role focused on delivering robust analytics solutions and ensuring development standards are upheld. You will act as the key link between business requirements and technical execution, enabling data-driven decision-making across the organisation.

Key Responsibilities

Technical Data Engineering & Modelling

• Transform raw, complex datasets into structured, high-quality data models within Azure and Power BI.
• Deep knowledge of deployment processes and components of implementation: Architecture, DevOps and Pipelines.
• Design and implement complex modelling concepts/semantic models (e.g., many-to-many joins, filtering considerations) with requirements traceability.
• Ensure SQL development code is intuitive, and performance is considered at all stages.
• Create calculated measures using DAX, ensuring scalability and performance.
• Develop dashboards and curated datasets for business consumption, aligned with Data Governance standards and best practice User Experience. Where standards do not exist, lead their creation and implementation.
• Implement a robust Peer Review and Pull Request approach: mentor team members and uphold secure development protocols.
• Ensure adherence to agreed standards and best practice regarding performance and maintenance. Where no policy exists, develop protocols.
• Oversee the full development life cycle: design, testing, deployment, documentation, and user sign-off.
• Embed Agile principles, ensuring technical detail meets the ‘REFINED’ standard. Challenge requirements and guide process improvements.

Skills Development & Training

• Create and deliver training materials for team members and business units, promoting upskilling and a data-driven culture.
• Manage the ServiceNow queue for in-life data support, ensuring timely and accurate resolution of issues within SLA, while keeping stakeholders informed.

Requirements

Knowledge & Experience

• Proven ability to engineer and transform raw data into optimised data models within Azure and Power BI.
• Strong background in data analysis, modelling, and visualisation.
• Expert in DAX, SQL, Python, and data notebooks (Jupyter or Azure Synapse).
• Proficient in Power BI, Azure Data Lake, and data modelling best practices.
• Experience managing data projects and stakeholder expectations.
• Experience developing processes and protocols around standards and governance.

Technical Skills

• Power BI (including Power BI Aggregates) & DAX / DAX Studio
• Microsoft Data Lake
• SQL & Python (or similar)

Qualifications

• Degree required, preferably in Information Technology, Computer Science, Data Analytics, or a related field

Hybrid (minimum 2 days in office per week)

What We Offer

• Travel covered to any of our sites (subject to HMRC advisory rates)
• Extensive corporate benefits including Private Medical, Pension (8% employer contribution), Health and Wellness programme, 26 days holiday + bank holidays and much more…
• Excellent range of learning and development activity to support your career progression
• Industry-leading family leave benefits including 26 weeks fully paid maternity and 12 weeks fully paid paternity

Given the nature of this position, you will need to undergo a Basic Disclosure and Barring Service Check (DBS) at offer stage. Applicants with criminal convictions will be assessed individually, and we assure you that we do not discriminate based on an applicant's criminal record or the details of any disclosed offenses. Additionally, certain roles may be subject to additional pre-employment checks.

To learn more about the checks included in this process, please click on the following link: National Security Vetting