Opus People Solutions Ltd
03/02/2026
Seasonal
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.