Business Intelligence Architect
While professional experience and qualifications are key for this role, make sure to check you have the preferable soft skills before applying if required.
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. xsngvjr
A maintainable, scalable semantic model.
Full documentation and confident internal ownership