Power BI Consultant (Hybrid) – Data Transformation Expert

The Portfolio Group Inc.; Kidlington; Hybrid; GBP 88,000 - 115,000; Full time

Job summary

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.

Qualifications

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

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.

Skills

Power BI

DAX

Power Query (M)

T-SQL

Data modelling

Performance optimisation

Mentoring

Stakeholder management

Consultancy/Advisory

Education

DP-600 certification

Microsoft Certified Trainer

Tools

Power BI

Job description

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.