Power BI Solution Architect

• Role: Power BI Architect
• Rate: Inside IR35
• Location: 2 days per week on site, London
• Clearance: Active SC Clearance Required

About the Role

Our client is seeking an experienced, forward-thinking Power BI Architect to join the team and take full ownership of the end-to-end architecture of the organisation’s BI/MI application estate.

In this strategic role, you will define the technical direction for reporting, semantic modelling, and data visualisation. You will be instrumental in driving long-term architectural improvements, establishing robust data governance, and ensuring a scalable, secure, and highly performant BI platform that supports enterprise-wide decision-making.

Key Responsibilities

• End-to-End BI Architecture: Own the architecture of the Power BI application estate, designing robust semantic/data models (star schema, DAX) and defining standards for datasets, dataflows, workspaces, and report design.
• Platform & Integration Strategy: Architect Power BI integration with Azure/AWS cloud data platforms, and define Premium/Fabric capacity, gateway, and CI/CD deployment pipeline strategies.
• Governance, Security & Compliance: Implement tenant-level governance (workspace structures, access controls, sensitivity labels) and establish patterns for Row-Level Security (RLS) to ensure compliance with data protection policies.
• Technical Leadership & Assurance: Act as the senior technical authority for BI/MI architecture decisions, translating complex business reporting needs into scalable solutions while mentoring developers and BI engineers.

Essential Skills & Experience

• Active Security Clearance (SC): Candidates must hold active SC clearance and have resided in the UK for the past 5 years to meet eligibility criteria.
• Technical Mastery: Expertise in Power BI Service, DAX, Power Query (M), data modelling, SQL, and cloud data platform integration (Azure/AWS).
• Governance & Deployment: Proven experience implementing tenant governance, RLS, and automated BI deployment pipelines.
• Stakeholder & Advisory Skills: Exceptional communication skills with a demonstrable ability to explain complex BI architecture to varied audiences and advise senior stakeholders on strategic technical decisions.