Business Intelligence Architect

2-3 Months with a local authority

The Power BI Architect will spearhead the comprehensive design, development, and implementation of a strategic Inclusion Tool using Microsoft Power BI. This role is pivotal in shaping the data architecture, semantic layer, and reporting experience to ensure the delivery of reliable and scalable insights. The architect will collaborate closely with the Intelligence Hub (iHub) to source data, build models, design dashboards, and ensure a seamless transition to internal teams.

• Design a scalable and future‑ready Power BI solution aligned with organizational needs.
• Develop semantic models, star schemas, shared dimensions, and conformed measures.
• Create robust DAX measures and KPI logic.
• Define dataflows, refresh patterns, and governance frameworks.
• Enable governed self‑service analytics for long‑term adoption.

• Extensive experience as a Power BI Architect, BI Architect, or Senior Power BI Developer.
• Expert knowledge of Power BI Desktop & Service.
• Advanced DAX expertise and performance optimization skills.
• Strong dimensional modeling (star schema) capability.
• Proficient SQL skills and experience with relational data sources.
• Equivalent professional experience will also be considered in place of a formal degree.

• Working hours:
  
  37 hours per week
• 2 days in the office, 3 days working from home
• Bi‑weekly payments