Business Intelligence 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.

• 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.

• Proven experience delivering end-to-end Power BI reporting solutions on large-scale or complex programmes.
• Strong experience engaging stakeholders to gather and define detailed reporting and data requirements.
• Demonstrated ability to produce low-level designs, including data field definitions, transformations, and mappings.
• Advanced Power BI knowledge, including datasets, dataflows, and visualisation best practices.
• Strong SQL skills with experience querying and transforming data from data lakes or enterprise data platforms.
• Proficiency in DAX and Power Query for data modelling and transformation.
• Experience delivering both dashboard-based reporting and scheduled data extracts.
• Comfortable working at pace, independently managing workload and priorities in a fast-moving environment.
• Experience working within a hybrid organisation, collaborating effectively with stakeholders across both remote and in-person environments.
• Familiarity with Agile delivery methodologies.
• Excellent communication, analytical, and problem-solving skills.
• Degree in Business, Data Analytics, Information Systems, or a related field (or equivalent experience).
• A minimum of 2 years in a similar role, developing dashboards and reports in Power BI for large-scale or complex projects.
• Microsoft certifications such as PL-300: Microsoft Power BI Data Analyst or equivalent (desired).
• Strong SQL skills and experience with data modelling principles.
• Knowledge of data integration and ETL tools (e.g., Azure Data Factory, SSIS) is a plus.
• Understanding of data governance, security, and compliance in reporting environments.

Please apply with an updated CV, if interested and available.