Data / MI Business Analyst (SC Cleared)

About Scrumconnect Consulting

Scrumconnect Consulting is a multi-award-winning digital consultancy, recognised for delivering impactful and innovative technology solutions across UK government departments. Our work has positively influenced the lives of over 40 million UK citizens.

We are passionate about user-centred design, agile delivery, and building digital services that make a real difference. Our teams work at the forefront of innovation, helping organisations transform and deliver high-quality, scalable solutions that truly matter.

Overview

We are looking for an experienced Data / MI Business Analyst to join our team and work closely with business stakeholders, technical teams, and data specialists.

In this role, you will translate business and reporting needs into clear, well-defined requirements. You will investigate existing reports, datasets, and data processes, identify data quality issues and gaps, and define the KPIs, metrics, and specifications required to support effective MI and dashboard solutions.

Key Responsibilities

• Work closely with business stakeholders to understand and define MI, reporting, and analytical requirements, including the underlying business needs and desired outcomes.
• Review and investigate existing reports, dashboards, datasets, and data processes to understand current capabilities, limitations, and gaps.
• Use SQL and other analytical techniques to investigate data, identify discrepancies, trends, anomalies, and data quality issues.
• 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 identify root causes and agree appropriate resolutions.
• Translate business and analytical needs into clear business requirements, technical requirements, user stories, acceptance criteria, and reporting/dashboard specifications.
• Assess data availability and identify whether required information is fully available, partially available, or missing, and define requirements to address data gaps.
• Collaborate with MI Developers, Data Analysts, Data Engineers, and Data Architects to refine requirements and validate analytical and reporting solutions.
• Produce high-quality documentation, including requirements, metric definitions, data mappings, investigation findings, data quality assessments, and recommendations.

Essential Skills & Experience

• Active SC Clearance is mandatory for this role.
• Proven experience working as a Technical Business Analyst, Data Business Analyst, MI Business Analyst, or similar role.
• Strong experience working with data, MI, reporting, or analytics teams.
• Strong SQL skills with experience in data investigation, analysis, and validation.
• Experience defining and documenting KPIs, metrics, business rules, and calculation logic.
• Good understanding of data structures, relationships, data lineage, and data quality.
• Experience analysing complex datasets and investigating data and reporting discrepancies.
• Ability to translate business requirements into clear technical and analytical requirements.
• Experience working within Agile delivery environments, including writing user stories and acceptance criteria.
• Strong stakeholder management, communication, problem-solving, and analytical skills.
• Ability to explain complex data and technical concepts clearly to both technical and non-technical stakeholders.

Desirable Skills & Experience

• Experience with Power BI, Microsoft Fabric, Azure Synapse, or other enterprise data platforms.
• Experience with Oracle, SQL Server, PostgreSQL, or similar relational databases.
• Knowledge of enterprise data models, data governance, and data quality frameworks.
• Experience working within large-scale public sector or complex enterprise environments.

Diversity & Inclusion

At Scrumconnect Consulting, we believe that diversity drives innovation and better outcomes. We are committed to fostering an inclusive environment where every individual is valued, respected, and supported.

We welcome applications from candidates of all backgrounds and actively encourage individuals from underrepresented groups, including women, people with disabilities, and diverse communities, as well as those seeking flexible working arrangements.

As a Disability Confident Level 1 employer, we are committed to providing reasonable adjustments throughout the recruitment process and during employment to ensure equal opportunities for all.