Lead Data Analyst: SQL & Power BI (Hybrid, Outside IR35)

InterAct Consulting; Northampton; Hybrid; GBP 65,000 - 69,000; Full time

Job summary

InterAct Consulting seeks a Lead Data Analyst to own BI reporting, primarily SQL-based, including Power BI solutions. You will lead a small team of Data Analysts, guiding design and delivery of scalable reports while remaining hands-on with data, datasets, and standards.

The role focuses on outside IR35 contracting, with hybrid work and one day per week onsite in Northampton. Strong SQL Server and Power BI expertise are essential.

Qualifications

• Strong experience with Microsoft SQL Server and SQL Server Reporting Services.
• Proven expertise with Power Platform tools, particularly Power BI and Dataverse.
• Ability to interpret business requirements and deliver secure, scalable technical solutions.
• Excellent stakeholder management and communication skills.

Responsibilities

• Own the technical design and delivery of SQL-based reporting solutions, including Power BI, ensuring alignment with best practices and standards.
• Provide leadership and guidance to a team of Data Analysts, acting as the escalation point for complex technical challenges.
• Lead the development of robust, consistent reporting that supports key business decision‑making.
• Translate business requirements into well‑structured, maintainable reporting outputs.
• Define and maintain clean, reliable datasets and enforce consistent data standards across reporting.
• Mentor and coach analysts, supporting development and promoting best practice across the team.

Skills

Analytical thinking

Stakeholder management

Communication skills

Tools

Microsoft SQL Server

SQL Server Reporting Services

Power BI

Dataverse

Power Automate

Job description

InterAct Consulting seeks a Lead Data Analyst to own BI reporting, primarily SQL-based, including Power BI solutions. You will lead a small team of Data Analysts, guiding design and delivery of scalable reports while remaining hands-on with data, datasets, and standards.

The role focuses on outside IR35 contracting, with hybrid work and one day per week onsite in Northampton. Strong SQL Server and Power BI expertise are essential.