Power BI Developer (SC Cleared) - Contract

Power BI Developer (SC Cleared)

💰 £400 per day, inside IR35, contract running to the end of March 2027

📍 Home based, with potential for occasional site visit

Company & role

This role sits with an established UK technology consultancy delivering cloud, data and AI programmes into central government and other regulated environments. Their data practice builds the platforms and reporting that underpin large public sector transformation work, and reporting demand on the programme has grown to the point where they need dedicated Power BI capability through to spring 2027.

You will own the reporting and analytics layer on a programme where the source data sits largely in Dataverse, Dynamics 365 and the wider Power Platform, alongside SQL and relational sources. The work runs from data model design through to the dashboards senior stakeholders actually make decisions on.

**Active SC clearance is essential**

Why This Role Stands Out

• A long contract with real runway, booked through to the end of March 2027, rather than a rolling three month extension cycle
• Fully home based, so no commute and no fixed site attendance
• You own the semantic layer, not just the visuals. This is modelling and DAX work as much as dashboard design
• A varied source estate across Dataverse, Dynamics 365, Power Platform and SQL, which makes for more interesting work than a single warehouse feed
• Fabric and Azure data services are in the picture, so there is scope to work on a modern analytics stack rather than legacy reporting
• Direct access to business users and senior stakeholders, so you see what your reporting actually changes

Key Responsibilities

• Design, build and maintain Power BI reporting and analytics solutions for a range of business audiences
• Create data models and semantic layers that support reporting and analytics at scale
• Develop complex DAX calculations and measures
• Build and maintain Power Query transformations across multiple sources
• Work with Dataverse, Dynamics 365 and Power Platform data alongside SQL and relational databases
• Translate complex business requirements into workable technical solutions
• Apply dashboard design and data visualisation best practice
• Administer and support solutions within the Power BI Service
• Work alongside technical specialists, business users and senior stakeholders
• Manage competing priorities and deliver quality outcomes to agreed timescales

Ideal Experience

• Active SC clearance, essential
• Significant hands on experience designing and developing solutions using Microsoft Power BI
• Advanced DAX, including complex calculations and measures
• Strong data modelling grounding covering star schemas, fact and dimension tables and relationships
• Experience creating semantic layers to support reporting and analytics
• Strong Power Query and data transformation experience
• Experience working with Dataverse, Dynamics 365 and Power Platform as reporting data sources
• Solid SQL and relational database experience
• Experience administering and supporting solutions within the Power BI Service
• Strong analytical and problem solving skills, with the communication to work across technical specialists, business users and senior stakeholders

Desirable

• Microsoft Fabric
• Azure data services and cloud based analytics platforms
• Data warehouses, data lakes or modern data architectures
• Reporting governance and data quality controls
• API based integrations across multiple data sources
• Agile delivery environments
• Experience supporting digital transformation, data or analytics programmes
• UK public sector or regulated environment experience
• PL-300: Microsoft Power BI Data Analyst Associate