Senior Power BI Consultant, Keyrus

• 5+ years of experience in Business Intelligence, Data Analytics, or related fields, with strong Power BI delivery experience
• Deep expertise in Power BI, including DAX, Power Query (M), semantic modelling, and advanced visualisations
• Strong experience designing and building enterprise-scale data models using star and snowflake schema principles
• Experience with composite models, aggregations, and incremental refresh strategies
• Solid understanding of SQL, relational databases, and data warehousing concepts
• Experience with ETL/ELT processes and integrating Power BI with Azure data services (ADF, Synapse, ADLS, Azure SQL)
• Strong knowledge of Power BI governance, security, and access control frameworks, including Row-Level Security (RLS) and Object-Level Security (OLS)
• Experience implementing Power BI deployment pipelines, ALM, and CI/CD practices
• Ability to optimise Power BI performance using tools such as DAX Studio and VertiPaq Analyzer
• Experience supporting self-service BI initiatives, governance frameworks, and Centre of Excellence practices
• Proven experience working directly with senior business and technology stakeholders
• Strong workshop facilitation, communication, and stakeholder management skills
• Ability to translate business requirements into scalable technical solutions and articulate technical concepts to non-technical audiences
• Experience creating client-facing deliverables such as assessments, roadmaps, strategies, and recommendations
• Commercial awareness and consulting mindset
• Bachelor’s degree in Computer Science, Data, or related field
• Fluency in English

Desirable

• As a Senior Power BI Consultant, you will operate at the intersection of data, analytics, technology, and business strategy, helping clients transform complex data ecosystems into scalable, governed, and high-impact analytics solutions
• This is not a traditional dashboard development role
• We are looking for a technically exceptional, client-ready consultant who combines deep hands-on Power BI expertise with advisory capabilities across governance, architecture, self-service enablement, and Microsoft Fabric adoption
• You will engage directly with senior stakeholders, lead the design and delivery of enterprise-scale Power BI solutions, and contribute to the growth of Keyrus UK's Data & Analytics practice
• 🕒 Contract type: Permanent
• ⏰ Working hours: Full-time (40h/week)
• Enterprise Power BI Delivery
• Design and deliver end-to-end enterprise Power BI solutions across modelling, transformation, visualisation, governance, and deployment
• Architect and build complex semantic models using star and snowflake schema principles
• Develop advanced DAX solutions leveraging evaluation context, iterators, calculation groups, and time intelligence patterns
• Design composite models, aggregations, and incremental refresh strategies for large-scale datasets
• Build robust Power Query/M transformations, including custom functions and query folding optimisation
• Optimise Power BI performance using tools such as DAX Studio and VertiPaq Analyser
• Deliver paginated reports for operational and regulatory reporting requirements where needed
• Architecture & Platform Advisory
• Provide guidance on Power BI, Microsoft Fabric, the semantic layer, and analytics architecture decisions
• Design and implement secure Power BI environments, including Row-Level Security (RLS) and Object-Level Security (OLS)
• Define and promote Power BI governance frameworks, development standards, and best practices
• Support tenant administration, workspace architecture, deployment pipelines, and CI/CD implementation
• Advise clients on Microsoft Fabric adoption strategies, migration roadmaps, and platform scaling
• Self-Service BI & Governance
• Design self-service BI operating models and data democratisation strategies
• Establish governance frameworks covering data lineage, endorsement, sensitivity labels, audit logging, and access control
• Build certified dataset strategies and reusable analytics assets
• Contribute to Power BI Centre of Excellence initiatives and community enablement programs
• Client Advisory & Stakeholder Engagement
• Act as a trusted advisor to senior client stakeholders, including Heads of Analytics, CDOs, CTOs, and business leaders
• Facilitate workshops, discovery sessions, architecture reviews, and executive briefings
• Translate complex technical concepts into business value and actionable recommendations
• Support analytics maturity assessments, roadmap creation, and BI strategy definition
• Contribute to proposals, solution scoping, effort estimation, and practice development activities
• Enablement & Knowledge Sharing
• Deliver training, workshops, and knowledge transfer sessions for technical and business audiences
• Mentor junior consultants and contribute to internal communities of practice
• Support the continuous evolution of Keyrus methodologies, frameworks, and reusable assets
• You will work in complex, evolving client environments
• You are expected to balance delivery quality with pragmatism
• You will collaborate with diverse profiles across functions and cultures
• Autonomy increases with seniority — so does responsibility
• You will operate at both the architectural and stakeholder strategy levels

• We usually respond within a week
• 🗓 Target start date: July 2026