Data / MI Business Analyst

Scrumconnect Consulting; Greater London; On-site; GBP 45,000 - 65,000; Full time

Job summary

Scrumconnect Consulting is seeking a Data/MI Business Analyst to work with stakeholders, data specialists and technical teams to turn reporting needs into clear requirements. You will investigate existing reports and data processes, identify quality issues and gaps, and define KPIs and data specifications to drive better MI.

Join a UK public sector digital consultancy delivering agile, data-driven transformation.

Qualifications

• Active SC Clearance, mandatory for this role.
• Proven experience as a Technical Business Analyst, Data Business Analyst or MI Business Analyst.
• Strong SQL skills and experience investigating and validating data.
• Experience defining and documenting KPIs, metrics and business rules.
• Experience working with Agile delivery teams and producing user stories and acceptance criteria.

Responsibilities

• Work with business stakeholders to understand and clarify MI, reporting and analytical requirements, including the underlying business questions and outcomes.
• Investigate existing reports, dashboards, datasets and data processes to understand what is currently available, how it is produced and what is missing.
• Analyse data using SQL and other analytical techniques to identify data quality issues, discrepancies, trends, anomalies and gaps.
• Define and document KPIs, metrics, business definitions, calculation logic, rules, assumptions and data requirements.
• Investigate discrepancies between legacy systems, datasets and reports, working with technical teams to establish root causes and agree remediation.
• Translate business and analytical needs into clear requirements, user stories, acceptance criteria and reporting/dashboard specifications.
• Identify where required data is available, partially available or unavailable, and define the requirements needed to address gaps.
• Work closely with MI developers, Data Analysts, Data Engineers and Architects to refine requirements and validate analytical solutions.
• Produce clear documentation, including requirements, metric definitions, data mappings, investigation findings, data-quality assessments and recommendations.

Skills

SQL

Stakeholder management

Data analysis

Requirements gathering

Agile

Tools

Power BI

Azure Synapse

Microsoft Fabric

Oracle

SQL Server

PostgreSQL

Job description

Scrumconnect Consulting is a multi-award-winning UK public sector digital consultancy, positively influencing the lives of over forty million UK citizens. We bring deep expertise in agile delivery, digital transformation, and platform engineering across central government. With a team of over one hundred and twenty-five professionals — more than forty percent of whom are women — we are committed to building inclusive, diverse teams that reflect the communities we serve.

The Role

We are looking for a Data / MI Business Analyst to work with business stakeholders, technical teams and data specialists to turn reporting and analytical needs into clear, well-evidenced requirements. You will investigate existing reports, datasets and data processes, uncover quality issues and gaps, and define the KPIs, metrics and specifications that shape better MI and

Key Responsibilities

• Work with business stakeholders to understand and clarify MI, reporting and analytical requirements, including the underlying business questions and outcomes.
• Investigate existing reports, dashboards, datasets and data processes to understand what is currently available, how it is produced and what is missing.
• Analyse data using SQL and other analytical techniques to identify data quality issues, discrepancies, trends, anomalies and gaps.
• Define and document KPIs, metrics, business definitions, calculation logic, rules, assumptions and data requirements.
• Investigate discrepancies between legacy systems, datasets and reports, working with technical teams to establish root causes and agree remediation.
• Translate business and analytical needs into clear requirements, user stories, acceptance criteria and reporting/dashboard specifications.
• Identify where required data is available, partially available or unavailable, and define the requirements needed to address gaps.
• Work closely with MI developers, Data Analysts, Data Engineers and Architects to refine requirements and validate analytical solutions.
• Produce clear documentation, including requirements, metric definitions, data mappings, investigation findings, data-quality assessments and recommendations.

What We are Looking For

• Active SC Clearance, mandatory for this role.
• Proven experience as a Technical Business Analyst, Data Business Analyst or MI Business Analyst.
• Strong experience working with data, MI, reporting or analytics teams.
• Strong SQL skills and experience investigating and validating data.
• Experience defining and documenting KPIs, metrics and business rules.
• Understanding of data structures, relationships, data lineage and data quality.
• Experience analysing complex data and investigating reporting and data discrepancies.
• Experience translating business requirements into technical and analytical requirements.
• Experience working with Agile delivery teams and producing user stories and acceptance criteria.
• Strong stakeholder management, communication and analytical skills.
• Ability to communicate complex data and technical concepts clearly to both technical and non-technical audiences.
• Experience with Power BI, Microsoft Fabric, Azure Synapse or other enterprise data platforms.
• Experience with Oracle, SQL Server, PostgreSQL or similar databases.
• Experience with enterprise data models, data governance and data quality.
• Experience in large-scale public sector or complex enterprise environments.

Why Join Scrumconnect Ltd?

At Scrumconnect, we are more than just a consultancy. We are a collaborative team focused on delivering impactful digital transformation services across government and enterprise organisations.

As part of our team, you will benefit from:

• Exposure to major public sector digital transformation programmes.
• A collaborative and inclusive working culture.
• Hands-on experience working within agile delivery environments.

Scrumconnect Ltd is committed to creating an inclusive workplace and welcomes applications from individuals of all backgrounds and experiences.

Diversity and Inclusion

At Scrumconnect Consulting, we believe that diversity drives innovation. We are committed to creating an inclusive environment where every individual is respected, valued, and supported. We welcome applications from candidates of all backgrounds and experiences, and we actively encourage applications from women, people with disabilities, underrepresented communities, and those seeking flexible working arrangements.