Business Intelligence Architect

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., Solution ArchitectureBuild a robust Power BI semantic model using star schema principles.Define dataflows, refresh strategies, and long?term architectural considerations.Data IntegrationMap authoritative data sources and resolve gaps or inconsistencies.Conduct profiling and validation to ensure trusted KPIs.Document data lineage and assumptions.Power BI DevelopmentDevelop optimised models and reusable, well?structured DAX.Implement appropriate data security.Create clean, accessible dashboards with clear user journeys.Delivery & Stakeholder EngagementManage 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 & HandoverSupport UAT and KPI validation.Produce clear, practical technical documentation.Deliver a smooth, confident handover to the internal team.

Essential ExperienceStrong 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 ExperiencePublic 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 CriteriaA live, fully functioning Inclusion Tool in Power BI.Trusted, well?defined KPIs.A maintainable, scalable semantic model.Full documentation and confident internal ownership.