Data/MI Business Analyst

scrumconnect ltd; City of Westminster; On-site; GBP 50,000 - 75,000; Full time

Benefits offered by this job

Exposure to major public sector data/à

Job summary

Scrumconnect Ltd is seeking a Technical Business Analyst to join our MI/Analytics team in the UK. You will work with business stakeholders to understand reporting requirements and translate them into clear technical specifications.

You will investigate data sources, define KPIs, perform data analysis with SQL, and collaborate with MI Developers, Data Analysts and Engineers to deliver scalable, quality solutions in Agile projects. Active SC clearance is mandatory.

Qualifications

• Strong SQL skills with hands-on data analysis experience.
• Experience as Technical/MI Data or Business Analyst.
• Experience delivering in Agile environments and producing user stories.
• Excellent communication and stakeholder management skills.
• Active SC clearance is mandatory for this role.
• Strong understanding of data structures, data lineage and data quality.

Responsibilities

• Work with business stakeholders to understand MI, reporting and analytical requirements.
• Investigate existing reports, dashboards, datasets and data processes to understand gaps.
• Analyse data using SQL and other techniques to identify data quality issues and trends.
• Define KPIs, metrics, and calculation rules; document data requirements.
• Translate business needs into clear requirements, user stories and acceptance criteria.
• Collaborate with MI Developers, Data Analysts and Engineers to refine solutions.
• Produce documentation including data mappings and investigation findings.
• Engage stakeholders and translate requirements for technical delivery in Agile teams.

Skills

SQL

Data analysis

Stakeholder management

Communication

Agile delivery

Tools

Power BI

Azure Synapse

Oracle

SQL Server

PostgreSQL

Job description

Responsibilities

• Work with business stakeholders to understand and clarify MI, reporting and analytical requirements, including underlying business questions and desired outcomes
• Investigate existing reports, dashboards, datasets and data processes to understand current capabilities, data sources and reporting gaps
• 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 identify root causes and agree remediation
• Translate business and analytical needs into clear requirements, user stories, acceptance criteria and reporting or dashboard specifications
• Identify where required data is available, partially available or unavailable, and define the requirements needed to address any gaps
• Collaborate with MI Developers, Data Analysts, Data Engineers and Architects to refine requirements and validate analytical solutions
• Produce clear documentation, including business requirements, metric definitions, data mappings, investigation findings, data quality assessments and recommendations This role requires a strong combination of business analysis, data investigation and stakeholder management skills, with the ability to bridge the gap between business requirements and technical data solutions., Security Clearance: Active SC clearance is mandatory for this role
• Business Analysis: Proven experience as a Technical Business Analyst, Data Business Analyst or MI Business Analyst
• Data & MI: Strong experience working with data, management information, reporting or analytics teams
• SQL & Data Analysis: Strong SQL skills and hands‑on experience investigating, analysing and validating data
• KPI & Metrics Definition: Experience defining and documenting KPIs, metrics, business definitions and calculation rules
• Data Fundamentals: Strong understanding of data structures, relationships, data lineage and data quality
• Data Investigation: Experience analysing complex datasets and investigating reporting discrepancies and data‑related issues
• Requirements Gathering: Proven ability to translate business requirements into clear technical and analytical specifications
• Agile Delivery: Experience working within Agile teams and producing user stories, acceptance criteria and supporting documentation
• Stakeholder Management: Excellent communication and analytical skills, with the ability to engage stakeholders at all levels
• Communication: Ability to explain complex data and technical concepts clearly to both technical and non-technical audiences

Desirable

• Experience with Power BI, Microsoft Fabric, Azure Synapse or other enterprise data platforms
• Experience working 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 programmes or complex enterprise environments Scrumconnect Consulting is a multi-award-winning digital consultancy, recognised for delivering impactful technology solutions across UK government departments. Our work has positively influenced the lives of over 40 million UK citizens.

With a strong commitment to user-centred design and agile delivery, we build innovative digital services that matter. Our teams work collaboratively to help organisations transform, improve performance and deliver high-quality digital solutions., 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.

Benefits

• Exposure to major public sector digital transformation programmes
• The opportunity to contribute to data-driven decision-making and improved public services
• A collaborative and inclusive working culture
• The opportunity to work alongside experienced data, technical and delivery professionals
• Hands-on experience within Agile delivery environments

Our Commitment to Diversity & Inclusion At Scrumconnect Consulting, we believe that diversity drives innovation. We are committed to creating an inclusive environment where everyone is respected, valued and supported.