Business Intelligence Analyst

Us3 Consulting; Manchester; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

Us3 Consulting is seeking a BI Analyst to deliver end-to-end Power BI reporting solutions within a fast-paced, hybrid environment in Manchester. You will engage stakeholders, define low-level design and data mappings, and produce dashboards and scheduled extracts.

The role requires strong SQL, DAX/Power Query, and experience with data integration tools. You will collaborate across workstreams to ensure timely delivery and maintain documentation and handover materials.

Qualifications

• Proven experience delivering end-to-end Power BI reporting solutions.
• Strong SQL skills for data extraction and transformation.
• Experience with Power BI Dataflows and DAX/Power Query.
• Experience with Agile delivery in hybrid environments.
• Degree in Business, Data Analytics, Information Systems, or related field.

Responsibilities

• Engage stakeholders to gather and define low-level reporting requirements.
• Define detailed data field lists, transformations and mappings to support data extraction and modelling.
• Design wireframes and prototypes for reporting outputs including Power BI dashboards.
• Develop SQL scripts to extract, join and transform data from data lake and other sources.
• Deliver high-quality Power BI dashboards with performance and usability in mind.
• Support testing and defect resolution in Agile sprints and ensure timely re-testing.
• Produce clear documentation covering requirements, designs, and data logic.
• Operate independently within fast-paced delivery to maintain momentum.

Skills

Stakeholder engagement

Agile delivery

Data modelling

Hybrid collaboration

Education

Degree in Business, Data Analytics, Information Systems

Tools

Power BI

SQL

DAX

Power Query

Azure Data Factory

SSIS

Job description

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.

Knowledge and experience

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