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.

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.

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

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

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

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

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

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

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

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