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.
#J-18808-Ljbffr
Data/MI Business Analyst in City of Westminster employer: scrumconnect ltd
Scrumconnect Consulting is an exceptional employer that prioritises the growth and development of its employees, offering a supportive work culture in Newcastle. With a commitment to diversity and inclusion, as well as being a Disability Confident employer, we provide meaningful opportunities for career advancement and continuous learning, making it an ideal place for passionate individuals to thrive in their recruitment careers.
