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.