Senior Power BI Consultant

🌍 About Keyrus

Keyrus is a global consulting and technology company focused on architecting intelligence , helping organisations transform data, digital capabilities, and AI into sustainable business value.

Founded in 1996, Keyrus operates in 28+ countries across 5 continents , with more than 3,300 people worldwide . Our strength comes from combining deep expertise in Data & Analytics, AI, Digital, and Management Consulting with a strong understanding of business realities.

Data is never the goal in itself. We use data to shape understanding, design meaningful experiences, and enable better, real-life decisions .

At Keyrus, we also believe companies have a responsibility beyond performance. Through our Foundation and ESG initiatives , we actively contribute to sustainability, inclusion, and positive societal impact.

#OneTeamOneKeyrus

🎯 The Role

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.

📍 Job location: London, UK (Hybrid, 3 days on-site) 🕒 Contract type: Permanent 🗓 Target start date: July 2026 ⏰ Working hours: Full-time (40h/week) 💵 Compensation: £58,000 – £87,000 gross/year

💥 Your Impact

In this role, you will

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

⚡ What Makes This Role Challenging

•

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

👤 What We’re Looking For

Must-haves

•

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

Nice-to-haves

•

Experience in consulting environments

•

Financial Services (FSI) industry experience

•

Knowledge of Alteryx, Tableau, or Qlik as part of a broader analytics stack

•

Microsoft certifications such as PL-300, AZ-900, DP-900, or DP-600

•

Experience contributing to a Power BI Centre of Excellence

💰 How Our Salary Ranges Work

At Keyrus, salary ranges reflect different levels of mastery and impact within the same role — not different job titles.

•

Bottom of the range You meet the core requirements and will need ramp-up time and support.

•

Middle of the range You are fully autonomous from Day 1 and deliver consistently.

•

Top of the range You are a reference for the role, mentor others, and raise the bar for the team.

Final offers are based on experience, autonomy, scope, and market context , and are discussed transparently during the process.

🎁 What We Offer at Keyrus UK

•

Competitive holiday allowance

•

Private Medical & Dental Insurance (Bupa)

•

Group Life Insurance

•

Gym & fitness discounts via Pluxee (Sodexo)

•

On-site gym access at our London office

•

Access to lifestyle discounts (travel, retail, entertainment & more) via Pluxee (Sodexo)

•

Auto-enrolment pension scheme with Aegon .

•

Training & Development via KLX (Keyrus Learning Experience)

•

Strong focus on career development and internal mobility .

•

Electric & hybrid car scheme via Tusker

•

Annual discretionary bonus , based on individual and company performance

•

Referral bonus for introducing new colleagues.

💙 Why Keyrus?

Joining Keyrus means joining

•

A market leader in Data Intelligence

•

A company where people, trust, and diversity are core values

•

An environment that values ownership, flexibility, and innovation

•

A place where different backgrounds and perspectives are not just welcomed = they are essential

We believe diversity drives better thinking, stronger teams, and better outcomes. Everyone belongs at Keyrus.

At Keyrus, all stages of our recruitment process are conducted and evaluated by human recruiters and interviewers. To support accuracy and efficiency, AI may occasionally be used internally by our team exclusively for note-taking purposes during interviews . AI is never used to make hiring decisions or evaluate candidates.

🔒 To ensure fairness, authenticity, and the protection of confidential and proprietary information , the use of AI tools by candidates during the recruitment process is strictly prohibited .

Our commitment to responsible AI practices ensures that hiring decisions are based solely on each candidate’s own skills, experience, judgment, and expertise.

⚠️ Any use of AI assistance during the interview process may result in immediate disqualification from the recruitment process.

♿ Equal Opportunity Statement

We are committed to building an inclusive workplace and encourage applications from all backgrounds, regardless of race, ethnicity, gender identity, sexual orientation, age, disability, or any other protected characteristic.