Contract- PowerBI Consultant - 2 Month Contract - SC Cleared

We are looking for a PoweBI Consultant for a 2 month contract. The role can be home based but we would prefer someone who is able to travel to our offices in London.

Eligible Candidates must have SC clearance.

Role overview

We’re looking for an experienced Power BI Consultant (Contract) to deliver high-quality, client-facing KPI reports embedded within our software products using Power BI Embedded. You’ll take ownership of the reporting layer end-to-end: translating business requirements into robust semantic models and reports, shaping data where needed, and building accurate, performant dashboards aligned to existing wireframes.

This work supports one of our major clients, so accuracy, consistency, and strong QA discipline are essential.

Key responsibilities

• Build and enhance Power BI reports/dashboards in line with provided wireframes and agreed KPI definitions.
• Translate business requirements into reporting logic, clarifying metric definitions, filters, and calculation rules with stakeholders.
• Review available datasets and determine the right approach to support reporting outcomes, including:

• • Creating new datasets where required
  • Transforming/cleansing data
  • Building scalable data models (ideally star-schema / dimensional modelling)

• Develop and maintain complex DAX measures (time intelligence, allocations, exception logic, segmentation, multi-table calculations).
• Use SQL to interrogate source data and amend queries to ensure the right shape/grain for reporting and performance.
• Perform robust self-QA: reconciliation to source data, validation of KPI outputs, edge-case testing, and consistency checks across visuals/pages.
• Document assumptions, measure logic, and dataset transformations to support maintainability and handover.