Business Analyst - Data & Reporting (Water Utilities Domain)

N Consulting Ltd; Leeds; Hybrid; GBP 55,000 - 75,000; Full time

Job summary

A data consulting firm based in the UK is seeking a skilled Business Analyst specializing in Data & Reporting within the Water Utilities domain. This role involves translating business needs into structured data requirements using Azure, leading discussions on KPIs, and ensuring accuracy in data reporting. The ideal candidate will have over 7 years of experience and strong analytical skills. Collaboration with various stakeholders is essential to drive successful reporting outcomes.

Qualifications

• 7+ years of experience in business analysis, specifically related to data and reporting.
• Hands-on expertise in defining KPI, dashboard, and semantic model requirements for reporting.
• High-level understanding of Azure data pipelines and complex data environments.

Responsibilities

• Lead discussions with stakeholders to capture KPIs and reporting needs.
• Define business rules and data mappings supporting reporting.
• Work closely with reporting teams to ensure accurate and consistent KPIs.
• Coordinate with technical teams to ensure clarity of requirements.
• Create documentation supporting business rules and data mappings.

Skills

Strong analytical skills

Domain understanding of Water Utilities

Proficiency in Power BI

Coordination across stakeholders

Job description

Overview

Role: Business Analyst - Data & Reporting

Experience: 7years

Location: Bradford/Leeds

Work mode: Hybrid

Job Description

Business Analyst - Data & Reporting (Water Utilities Domain)

The Business Analyst plays a critical role in translating business needs into clear, structured data and reporting requirements across the Azure data platform. With 6-10 years of experience, the ideal candidate brings strong analytical skills, domain understanding of Water Utilities, and hands-on expertise in defining KPI, dashboard, and semantic model requirements for enterprise reporting. This role requires strong coordination across stakeholders, high-level understanding of Azure data pipelines, and the ability to drive clarity in complex data environments.

Key Responsibilities

• End-to-End Requirement Analysis
  • Lead discussions with business stakeholders to capture KPIs, reporting needs, and operational expectations. Document business processes, data dependencies, source behaviours, and reporting flows across utility systems.
• Data Interpretation & Integration Alignment
  • Understand ingestion, transformation, data quality expectations, and Lakehouse layers at a conceptual level. Define business rules, data mappings, and semantic model requirements supporting downstream reporting.
• Power BI Reporting Coordination
  • Work closely with reporting teams to define dashboard requirements, drill-downs, metrics, and visualization logic. Validate report outputs and ensure KPIs are accurate, consistent, and aligned with business objectives.
• Cross-Functional Collaboration
  • Coordinate with architects, data engineers, QA teams, and reporting teams to ensure requirement clarity. Bridge the gap between business needs and technical delivery across ingestion → modeling → reporting.
• Documentation & Governance
  • Create BRDs, FRDs, user stories, business rules, and data mapping documents with clear acceptance criteria. Support KPI dictionaries, metadata definitions, and reporting documentation to maintain consistency.