Business Intelligence Architect

Business Intelligence Architect

Day Rate: £500 per day
Contract: Temporary - until 31 March 2026
Location: Suffolk - Hybrid (2 days per week onsite)

We are working with a public sector organisation in Suffolk seeking an experienced Power BI Architect for a high?impact, delivery?focused contract. This role suits a contractor who can take ownership quickly, shape a solution with minimal onboarding, and deliver at pace.
You will lead the full design and build of a new Inclusion Tool in Power BI-from data architecture and modelling through to dashboard design, documentation, and handover to internal teams.

The Role

As the Power BI Architect, you will:

• Lead the technical delivery of a strategic Power BI reporting solution.
• Design a scalable data and semantic architecture.
• Identify and validate data sources alongside analysts and data owners.
• Build performance?optimised models, DAX measures, and high?quality dashboards.
• Deliver a rapid, iterative build within a fixed timeframe.
• Produce full documentation and handover materials for the Intelligence Hub team.

This is a hands?on role ideal for an experienced contractor who can hit the ground running.

Key Responsibilities

Solution Architecture

• Build a robust Power BI semantic model using star schema principles.
• Define dataflows, refresh strategies, and long?term architectural considerations.

Data Integration

• Map authoritative data sources and resolve gaps or inconsistencies.
• Conduct profiling and validation to ensure trusted KPIs.
• Document data lineage and assumptions.

Power BI Development

• Develop optimised models and reusable, well?structured DAX.
• Implement appropriate data security.
• Create clean, accessible dashboards with clear user journeys.

Delivery & Stakeholder Engagement

• Manage a short, fixed delivery cycle including scope, iterations, and reviews.
• Turn business requirements into technical solutions independently.
• Work confidently with both technical and non?technical stakeholders.

Testing, Documentation & Handover

• Support UAT and KPI validation.
• Produce clear, practical technical documentation.
• Deliver a smooth, confident handover to the internal team.

Essential Experience

• Strong experience as a Power BI Architect or Senior Power BI Developer.
• Expert knowledge of Power BI Desktop & Service, DAX, and dimensional modelling.
• Proficient SQL and relational database skills.
• Evidence of delivering enterprise?grade BI solutions end?to?end.
• Comfortable with short?term, delivery?focused contracts.
• Strong communicator and autonomous worker.

Desirable Experience

• Public sector, education, or social care analytics.
• Inclusion, SEND or needs?based datasets.
• Power BI governance frameworks.
• Microsoft Fabric or Azure BI tools (nice to have).

Success Criteria

• A live, fully functioning Inclusion Tool in Power BI.
• Trusted, well?defined KPIs.
• A maintainable, scalable semantic model.
• Full documentation and confident internal ownership.