Opportunity for BI Analyst

The BI Analyst will play a key role in delivering end-to-end reporting solutions as part of the Reporting Workstream. This role spans the full reporting lifecycle, from engaging stakeholders to define low-level design requirements, through to data extraction, and the delivery of Power BI dashboards or scheduled data extracts. The successful candidate will work closely with the Reporting Workstream Lead, business stakeholders, and the Data Workstream to ensure reporting requirements are clearly defined, solution defined, and delivered at pace within a fast-moving programme environment.

Key accountabilities

• Stakeholder Engagement and Requirements Definition: Engage with stakeholders to gather and define low-level reporting requirements, including clarification of user stories, reporting objectives, and output types. Facilitate discussions to capture and agree detailed design requirements.
• Low-Level Design and Solution Definition: Define detailed “to be” data field lists, required transformations, and business logic. Map reporting requirements to data sources and provide clear specifications to the Data Workstream to support data extraction and modelling activities.
• Design and Prototyping: Design wireframes and prototypes for reporting outputs, including PowerBI dashboards or CSV-based extracts, to align stakeholder expectations with the proposed solution.
• Acceptance Criteria and Sign Off: Define clear acceptance criteria for reporting deliverables and seek formal stakeholder sign off to confirm requirements have been fully understood and defined prior to build.
• Data Extraction and SQL Development: Use SQL to write scripts that extract, join, and transform data from the data lake and other sources. Produce reusable queries to support dashboard development or scheduled data extracts where required.
• Dashboard Development: Design and deliver high-quality, engaging Power BI dashboards that meet agreed business and technical requirements, ensuring performance, usability, and consistency with reporting standards.
• Testing and Defect Management: Collaborate with testers to support testing activities, diagnose and fix reporting defects, and ensure timely re-testing and validation of changes to deliver accurate, reliable reporting outputs.
• Agile Delivery and Tooling: Deliver reporting solutions using an Agile approach, contributing to daily scrums, maintaining work items and defects in Azure DevOps, and ensuring transparent tracking of progress, risks, and dependencies.
• Documentation and Handover: Produce clear documentation covering requirements, designs, data logic, and reporting outputs to support knowledge transfer and ongoing support.
• Independent Delivery in a Fast-Paced Environment: Operate independently within tight deadlines, applying sound judgement and common sense, proactively seeking guidance where required to maintain delivery momentum and quality.