BI Consultant

Consult; Greater London; Hybrid; GBP 101,000 - 120,000; Full time

Job summary

Consult is seeking a Senior BI Consultant to take technical ownership of the Power BI reporting environment for an international organisation. This hands-on role involves reviewing and enhancing an existing suite of reports, improving data accuracy, and delivering reliable, production-ready dashboards.

You will work remotely across the UK, engage with business stakeholders, manage BI deployments and ensure quality through testing and documentation.

Qualifications

• Hands-on expertise in Power BI, DAX, Power Query, SQL and data modelling.
• Experience owning BI solutions and improving quality, performance and reliability.
• Strong data validation, testing and reconciliation knowledge.
• Experience creating professional, user-friendly dashboards.
• Experience managing Power BI Service deployments, security and troubleshooting.
• Ability to challenge requirements and deliver with minimal supervision.
• Excellent communication with business stakeholders.

Responsibilities

• Take ownership of Power BI development, enhancements, testing, deployment and ongoing support.
• Review existing reports and resolve issues across DAX measures, data models, filters, and visual presentation.
• Ensure reporting accuracy through testing, reconciliation and documented quality assurance.
• Develop polished, intuitive dashboards with consistent formatting and strong usability.
• Build and optimise data models and Power Query transformations, using SQL to investigate discrepancies and validate outputs.
• Manage Power BI Service workspaces, refreshes, gateways and security.
• Strengthen documentation, version control and release processes, supporting a smooth handover from an external development partner.

Skills

Stakeholder communication

Data quality assurance

Problem solving

Independence

Dashboard design

Tools

Power BI

DAX

Power Query

SQL

Snowflake

Job description

BI Consultant

Fully remote (UK)

£550 - £650 per day, Outside IR35

3-month contract, with potential to extend

We are partnering with an international organisation seeking an experienced Senior BI Consultant to take technical ownership of its Power BI reporting environment.

Joining an ongoing reporting programme, you will review and enhance an existing suite of reports, improve data accuracy and dashboard design, and deliver reliable, production-ready reporting. This is a hands‑on opportunity for a senior consultant who can work independently and make confident technical decisions.

Key responsibilities

• Take ownership of Power BI development, enhancements, testing, deployment and ongoing support.

• Review existing reports and resolve issues across DAX measures, data models, filters, and visual presentation.

• Ensure reporting accuracy through testing, reconciliation and documented quality assurance.

• Develop polished, intuitive dashboards with consistent formatting and strong usability.

• Build and optimise data models and Power Query transformations, using SQL to investigate discrepancies and validate outputs.

• Manage Power BI Service workspaces, refreshes, gateways and security.

• Strengthen documentation, version control and release processes, supporting a smooth handover from an external development partner.

About you

• Advanced hands‑on expertise in Power BI, DAX, Power Query, SQL and data modelling.

• Proven experience taking ownership of existing BI solutions and improving their quality, performance and reliability.

• Strong understanding of data validation, testing and reconciliation.

• A track record of creating professional, user-friendly dashboards.

• Experience managing Power BI Service deployments, security and troubleshooting.

• The confidence to challenge requirements, recommend improvements and deliver without day‑to‑day technical supervision.

• Clear communication skills and experience working directly with business stakeholders.

Experience with Snowflake or similar cloud data platforms would be advantageous, alongside experience inheriting solutions from external development teams.

The role is fully remote, working UK/Central European hours. Candidates should ideally be able to share examples of dashboards they have developed and explain how they validated the underlying data.