Senior Power BI Consultant / Team Lead

About Kagool

We are a fast-growing IT consultancy specialising in the transformation of complex Global enterprises. We are looking for passionate and hardworking individuals that to help deliver for our global customer base. We embrace the opportunities of the future and work proactively to make good use of technology . As you can imagine, this means that we have a vibrant and diverse mix of skills and people making Kagool a great place to work.

Role Overview

Kagool is seeking a Senior Power BI Consultant to lead the Power BI workstream on a complex SAP company code segmentation project for a key US customer.

This is a hands-on leadership role. The consultant will :

• Lead a team of 2–3 Power BI engineers
• Own the end-to-end Power BI impact assessment and remediation for SAP company code and related SAP object changes
• Quickly get up to speed on the current analysis, scripts, and design already in place
• Act as the senior technical expert for Power BI debugging and troubleshooting

Key Responsibilities

1. Project and Technical Leadership

2. Environment and Impact Analysis

3. Design and Remediation Planning

4. Hands-on Power BI Engineering and Troubleshooting

5. Stakeholder Management and Communication

Required Skills and Experience

Technical

6–8+ years of experience working with Power BI in complex enterprise environments.

Advanced expertise in :

Power Query (M), including debugging and restructuring complex, multi-source queries.

DAX, including reading, writing and troubleshooting complex measures and optimizing performance.

Data modelling, including star schemas, fact and dimension design and model optimization.

Strong experience with Power BI Service and Power BI capacities (workspaces, dataflows, gateways, deployment patterns).

Experience using Power BI Admin APIs and PowerShell to inventory and scan tenant objects (workspaces, reports, datasets, tables, columns, measures, queries, datasources, users).

Good understanding of SAP → Azure → Power BI data flows, ideally including finance concepts such as PCA, COPA and CCA.

Leadership and Delivery

Proven experience leading small technical BI teams on data or analytics projects.

Strong ability to take over an in-progress project, absorb existing designs and analysis and drive it forward.

Comfortable working with cross-functional stakeholders across IT, SAP, data engineering, finance, operations and business user groups.

Track record of delivering structured analysis, clear remediation plans and high-quality technical outcomes under time pressure.

Soft Skills

Excellent written and verbal communication skills.

Able to explain complex technical topics in simple, business-friendly language.

Highly organised and detail-oriented, comfortable managing large numbers of objects and dependencies.

Proactive, self-driven and able to work independently while leading and supporting others.

Nice to Have

Experience with Tabular Editor or similar tabular model management tools.

Experience in energy, utilities, manufacturing or other asset-heavy industries.

Familiarity with the Azure data stack (e.g. Azure SQL, Synapse, Databricks).

Prior experience with segregation, carve-out or reorganisation projects involving company codes or similar master data changes.

What Success Looks Like (First 1–2 Months)

Career at Kagool

A career at Kagool will give you a path towards progression and opportunities, with the current rate of growth we at Kagool have dedicated time towards individual growth, recognizing individual contributions, filling the team with a strong sense of purpose along with providing a fun, flexible and friendly work environment.