Lead Data Analyst

The Vacancy

Lead Data Analyst

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.

Team Leadership & Process

• 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.

Support & Incident Management

• 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

• Azure Synapse or Jupyter Notebooks

• Vertipaq Analyser

• 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

• Competitive salary

• Flexible working

• 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

Work for Wates

Wates is one of the UK’s leading family-owned development, building and property maintenance companies.  Founded over 125 years ago, we have a proud legacy in the built environment.

We are driven by our purpose, ‘reimagining places for people to thrive’ and our three promises:

• Thriving places – working with customers, partners and communities to create places that are more sustainable, inclusive, and full of opportunity.
• Thriving planet – protecting nature and taking action on climate change by collaborating and innovating with our partners.
• Thriving people – creating opportunities and relationships so that everyone who works for and with us feels included, invested in and treated with care.

We are proud to be recognised as Gold Investors in People and as a Disability Confident employer.  We also ensure that our recruitment processes do not treat anyone less favourably due to an offending background.