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.