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.

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), Degree required, preferably in Information Technology, Computer Science, Data Analytics, or a related field

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