Talent.com
Senior Power BI Consultant / Team Lead
Senior Power BI Consultant / Team LeadKagool • mohali, gujarat, in
No longer accepting applications
Senior Power BI Consultant / Team Lead

Senior Power BI Consultant / Team Lead

Kagool • mohali, gujarat, in
18 hours ago
Job description

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

  • Own the Power BI workstream for the company code segmentation project.
  • Work closely with the Project Lead, Azure Engineering Lead and consult with the SAP / BW Lead.
  • Lead, coach and coordinate 2–3 Power BI engineers, including work allocation and review of deliverables.
  • Translate SAP and business design decisions into a clear remediation plan for Power BI models, reports and dataflows.
  • Maintain and refine the overall approach to segregating the new company code within Power BI.
  • 2. Environment and Impact Analysis

  • Use Power BI Admin APIs and existing PowerShell scripts to scan the tenant (workspaces, reports, datasets, tables, columns, measures, Power Queries, datasources, users).
  • Understand and enhance existing scanner exports and Excel-based trackers that categorize Power BI assets by company or segment.
  • Lead the identification of objects impacted by the new company code and related SAP changes (e.g. filters, joins, mappings, hard-coded values).
  • Own and refine the Excel-based impact tracker and ensure it remains accurate, complete and up to date.
  • 3. Design and Remediation Planning

  • Work with SAP, Azure and business stakeholders to understand how old and new company codes flow from SAP via BW / Azure into Power BI.
  • Define standard patterns and guidelines for modifying datasets, models, queries and reports.
  • Decide and document when changes should be made by IT versus business users (especially for non-SAP sources such as Excel and file shares).
  • Create and maintain simple decision flows that show what needs to change, who should change it and how to prioritize the changes.
  • 4. Hands-on Power BI Engineering and Troubleshooting

  • Review and, where necessary, refactor Power BI datasets, including data model design and relationships.
  • Debug and fix Power Query (M) and DAX, including issues such as mismatching values before and after segmentation.
  • Resolve common Power BI issues, including refresh failures and performance problems.
  • Ensure updated models correctly handle new company code mappings, filters and any security logic (e.g. row-level security).
  • 5. Stakeholder Management and Communication

  • Act as the primary Power BI point of contact for the project.
  • Run working sessions with report owners, analysts and business users to explain the impact of SAP company code changes and what they need to change in their own reports and data sources.
  • Prepare clear, non-technical summaries for leadership showing scale of impact, key risks and progress against the remediation plan.
  • Support cutover and go-live activities from a Power BI perspective, including testing, validation and hypercare.
  • 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)

  • The consultant has a solid understanding of the company code segmentation design and the current Power BI landscape.
  • There is a clear, actively maintained inventory of impacted objects and users, with remediation status tracked.
  • The 2–3 Power BI engineers are working effectively under a coherent plan with consistent technical patterns.
  • Key reporting for both the new and existing company codes is functioning correctly and reliably after the SAP changes, with minimal disruption to business users.
  • 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.

    Create a job alert for this search

    Power Bi Consultant • mohali, gujarat, in

    Related jobs
    Power BI Developer

    Power BI Developer

    Flyers Soft • Surat, IN
    Power BI (DAX, M Query, data modelling).SSRS (hands-on report development).SSAS Tabular (hands-on model development).Power BI Certification (latest). Interested candidates please share your resume w...Show more
    Last updated: less than 1 hour ago • Promoted • New!
    SAP Lead- UI5 FIORI

    SAP Lead- UI5 FIORI

    HCLTech • Surat, IN
    Experience in customization / extending standard Fiori Applications using either WebIDE or SAP Business Application Studio. Experience in customization of standard oData Services.Experience in the dev...Show more
    Last updated: less than 1 hour ago • Promoted • New!
    Team Lead -Power Bi

    Team Lead -Power Bi

    Programmers.io • surat, India
    Shift Timings : Should be able to work until 10 : 30 PM IST.Location : PAN INDIA Remote, Work from Home.Experience Required : 7 - 15 Years. Strong expertise in Power BI, DAX, SQL, Data Modelling, PowerBi...Show more
    Last updated: 15 days ago • Promoted
    Power BI Developer

    Power BI Developer

    Confidential • Surat
    Dashboard & Report Development.Design, develop, and maintain interactive dashboards and reports using Power BI.Create and optimize robust data models, including effective star / snowflake schemas.Dev...Show more
    Last updated: 30+ days ago • Promoted
    Senior Consultant

    Senior Consultant

    Proglite • Surat, IN
    We are seeking a motivated and skilled.Network / Cloud / Security Engineer.AWS, Google Cloud Platform (GCP), Cisco Meraki, and Palo Alto firewalls. The ideal candidate will be responsible for design...Show more
    Last updated: 30+ days ago • Promoted
    Senior Power BI Consultant / Team Lead

    Senior Power BI Consultant / Team Lead

    Kagool • surat, India
    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 c...Show more
    Last updated: 13 hours ago • Promoted • New!
    SAP CPI Consultant

    SAP CPI Consultant

    iPivot • Surat, IN
    We are looking for an experienced.SAP and non-SAP systems using SAP Cloud Platform Integration (CPI) / SAP Integration Suite. The ideal candidate will have strong expertise in integration flows (iFl...Show more
    Last updated: 20 hours ago • Promoted • New!
    SAP IBP Consultant(Support & Enhancement Project)

    SAP IBP Consultant(Support & Enhancement Project)

    Ampstek • Surat, IN
    Title : SAP IBP Consultant(Support & Enhancement Project).We are seeking a skilled SAP IBP Consultant for a support project focused on Demand Planning, Supply Planning, Inventory Optimization, and C...Show more
    Last updated: 15 days ago • Promoted
    Senior SAP Consultant

    Senior SAP Consultant

    Mythri Consulting LLC • Surat, IN
    Exciting Remote Roles for Experienced SAP Professionals in India".SAP expert with extensive project experience and a passion. SAP Consultant – ABAP Developer.Strong functional and technical expertis...Show more
    Last updated: 26 days ago • Promoted
    Power BI & Oracle ERP Dashboard Optimization Consultant

    Power BI & Oracle ERP Dashboard Optimization Consultant

    RapidBrains • Surat, IN
    We are seeking an experienced Power BI Consultant with strong expertise in Oracle ERP data integration to enhance and optimize our existing Power BI dashboards. These dashboards currently support Pr...Show more
    Last updated: 1 day ago • Promoted
    Team Lead BD (Forex & CFD)

    Team Lead BD (Forex & CFD)

    PU Prime • Surat, IN
    The Business Development Manager will be responsible for generating sales and driving revenue growth by offering CFD, Forex products and services. This role involves identifying new sales opportunit...Show more
    Last updated: 20 hours ago • Promoted • New!
    Senior Consultant

    Senior Consultant

    Valorant • Surat, IN
    Valorant is a fast-growing consulting firm at the intersection of procurement and AI.We help global clients — across private equity, technology, life sciences, financial services, industrials, and ...Show more
    Last updated: 30+ days ago • Promoted
    SAP Senior Data Migration Consultant

    SAP Senior Data Migration Consultant

    delaware India • Surat, IN
    We are a renowned global corporation dedicated to delivering advanced business, IT solutions and services, assisting organizations in their business and digital transformations.Our primary goal is ...Show more
    Last updated: 1 day ago • Promoted
    Senior SAP PP Consultant

    Senior SAP PP Consultant

    Quantum Integrators • Surat, IN
    Job Title : Lead SAP PP Consultant / Sr.Work Location : Pune (Work from office, 5 days a week).Full-time with Quantum Integrators. Facilitate the implementation and support of SAP PP Module.Perform de...Show more
    Last updated: less than 1 hour ago • Promoted • New!
    Data Analytics Test Lead

    Data Analytics Test Lead

    Birlasoft • Surat, IN
    Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company’s consultative and design-thinking appro...Show more
    Last updated: less than 1 hour ago • Promoted • New!
    Senior Consultant - CPI

    Senior Consultant - CPI

    valantic • Surat, IN
    We are looking for an experienced.SAP Cloud Platform Integration (CPI).This role requires a deep understanding of APIs, system connectivity, and modern integration practices.Design, build, and deli...Show more
    Last updated: 14 days ago • Promoted
    Team Lead

    Team Lead

    Zensar Technologies • surat, gujarat, in
    ZENSAR -TEAM LEAD | PROJECT MANAGER OPPORTUNITY FOR GEN AI PROJECT.Dear Aspirant, Greetings from Zensar!!.We are a technology consulting and services company with over 11,500 associates in 33 globa...Show more
    Last updated: 12 days ago • Promoted
    Power Bi & Oracle Erp Dashboard Optimization Consultant

    Power Bi & Oracle Erp Dashboard Optimization Consultant

    RapidBrains • Sūrat, Republic Of India, IN
    We are seeking an experienced Power BI Consultant with strong expertise in Oracle ERP data integration to enhance and optimize our existing Power BI dashboards. These dashboards currently support Pr...Show more
    Last updated: 1 day ago • Promoted