Power BI Consultant

The Portfolio Group Inc.; Kidlington; Híbrido; GBP 88.000 - 115.000; Jornada completa

Descripción de la vacante

The Portfolio Group Inc. is seeking an experienced Power BI Consultant to join a major data transformation programme, with hybrid working between Winchester and Kidlington, Oxfordshire.

Day rate is 550 per day (Umbrella), with flexible full-time or part-time arrangements (minimum two days per week on average). This role focuses on migrating from SAP BusinessObjects to Power BI, developing scalable reporting, and mentoring colleagues.

Formación

• Extensive hands-on Power BI development experience, including Power BI Desktop and Power BI Service.
• Advanced DAX and Power Query (M) skills.
• Strong T-SQL experience and integration with SQL-based data warehouses.
• Excellent understanding of data modelling, semantic model design and optimisation.
• Knowledge of query folding and Power BI performance best practices.
• Experience mentoring, training or supporting Power BI users.
• Previous experience working in a consultancy, advisory or technical support capacity.
• Strong stakeholder management and communication skills.
• Desirable: migration from SAP BusinessObjects to Power BI.
• Desirable: DP-600 certification.
• Desirable: Microsoft Certified Trainer qualification.
• Desirable: experience in regulated environments.

Responsabilidades

• Design, build and optimise Power BI semantic models and reusable datasets.
• Support analysts and developers in adopting Power BI best practices.
• Work closely with data engineering teams to improve SQL Data Warehouse design and reporting performance.
• Develop and maintain Power BI reporting solutions using DAX, Power Query (M) and T-SQL.
• Provide technical guidance on data modelling, dataset architecture, query folding and performance optimisation.
• Deliver practical training sessions and workshops to small groups of analysts and business users.
• Support the migration of existing BusinessObjects reporting workflows into Power BI.
• Translate business requirements into effective technical reporting solutions.
• Collaborate with technical and non-technical stakeholders to improve reporting processes and data accessibility.
• Advise on sustainable reporting practices and future ways of working.

Conocimientos

Power BI

DAX

Power Query (M)

T-SQL

Data modelling

Performance optimisation

Mentoring

Stakeholder management

Consultancy/Advisory

Educación

DP-600 certification

Microsoft Certified Trainer

Herramientas

Power BI

Descripción del empleo

Power BI Consultant Location: Winchester and Kidlington, Oxfordshire Working pattern: Hybrid, typically 1-2 days per week on site Day rate: 550 per day (Umbrella) Contract: Flexible working arrangements, full-time or part-time considered (minimum two days per week on average)

The Opportunity

We are recruiting for an experienced Power BI Consultant to join a major data transformation programme, helping an established organisation modernise its reporting capabilities and maximise the value of its Azure-based data platform.

This is an exciting opportunity to play a key role in a large-scale migration from SAP BusinessObjects to Power BI, supporting the development of scalable reporting solutions and empowering teams to work more effectively with data.

The successful consultant will combine strong technical expertise in Power BI, semantic modelling, DAX and SQL with the ability to mentor colleagues, deliver training and provide hands‑on consultancy support.

Key Responsibilities

• Design, build and optimise Power BI semantic models and reusable datasets.
• Support analysts and developers in adopting Power BI best practices.
• Work closely with data engineering teams to improve SQL Data Warehouse design and reporting performance.
• Develop and maintain Power BI reporting solutions using DAX, Power Query (M) and T-SQL.
• Provide technical guidance on data modelling, dataset architecture, query folding and performance optimisation.
• Deliver practical training sessions and workshops to small groups of analysts and business users.
• Support the migration of existing BusinessObjects reporting workflows into Power BI.
• Translate business requirements into effective technical reporting solutions.
• Collaborate with technical and non-technical stakeholders to improve reporting processes and data accessibility.
• Advise on sustainable reporting practices and future ways of working.

Essential Experience

• Extensive hands‑on Power BI development experience, including Power BI Desktop and Power BI Service.
• Advanced DAX and Power Query (M) skills.
• Strong T-SQL experience and integration with SQL-based data warehouses.
• Excellent understanding of data modelling, semantic model design and optimisation.
• Knowledge of query folding and Power BI performance best practices.
• Experience mentoring, training or supporting Power BI users.
• Previous experience working in a consultancy, advisory or technical support capacity.
• Strong stakeholder management and communication skills.

Desirable Experience

• Previous experience migrating from SAP BusinessObjects to Power BI.
• Microsoft Fabric experience or DP-600 certification.
• Microsoft Certified Trainer qualification.
• Experience supporting performance reporting in policing, government, public sector or other regulated environments.

Working Arrangements

This is a predominantly remote contract, with an expectation of approximately 1-2 days per week working on site, across Winchester and Kidlington. Occasional travel to other regional sites may be required.

Both full‑time consultants and experienced professionals seeking a part‑time engagement of at least two days per week will be considered.