Celebal Technologies logo

Business Intelligence Lead

Celebal Technologies

4 - 8 years

Delhi

Posted:4 hours ago

Job Description

JD - BI Lead

Location - New Delhi

Working Mode - 5 days working (Onsite)

Experience Required - Team Management

Immediate Joiners are preferred

Power BI & Microsoft Fabric

Position Overview

BI Lead Power BI & Microsoft Fabric

scalability, security, performance, reliability, and governance

technical leadership, Microsoft Fabric platform administration, Power BI development, semantic model optimization, COE governance, production support, stakeholder management, and team leadership

Key Responsibilities

1. Power BI & Microsoft Fabric Administration

  • Administer and manage enterprise

    Power BI Service and Microsoft Fabric

    environments.
  • Govern workspaces, semantic models, reports, dashboards, and dataflows.
  • Manage tenant-level configurations and platform settings.
  • Establish and enforce Power BI/Fabric governance standards and best practices.
  • Monitor platform health, adoption, utilization, and performance.
  • Ensure compliance with organizational security and governance policies.

2. Fabric Capacity Management & Governance

  • Monitor

    Microsoft Fabric Capacity

    utilization, workloads, and resource consumption.
  • Analyze capacity performance and identify optimization opportunities.
  • Investigate capacity-related performance issues and workload bottlenecks.
  • Recommend capacity scaling and optimization strategies based on business demand.
  • Conduct periodic capacity health assessments.
  • Establish governance practices for enterprise Fabric workloads.

3. Semantic Model & Performance Optimization

  • Review and optimize Power BI semantic models for performance and scalability.
  • Optimize

    DAX, relationships, aggregations, storage modes, and model design

    .
  • Implement appropriate incremental refresh and semantic model optimization strategies.
  • Analyze resource utilization and identify performance bottlenecks.
  • Establish and maintain enterprise semantic model standards.
  • Guide development teams on performance-oriented Power BI development practices.

4. Refresh Monitoring & Production Operations

  • Monitor scheduled and on-demand semantic model refreshes.
  • Perform

    Root Cause Analysis (RCA)

    for refresh failures and recurring incidents.
  • Coordinate with Data Engineering and Infrastructure teams to resolve backend and platform issues.
  • Ensure adherence to refresh and operational SLAs.
  • Troubleshoot Power BI reports, semantic models, gateways, and refresh-related issues.
  • Provide Level 2/Level 3 production support.
  • Establish preventive actions for recurring operational issues.

5. Security & Access Management

  • Manage Power BI workspace access, permissions, and security groups.
  • Implement and manage

    Row-Level Security (RLS)

    and

    Object-Level Security (OLS)

    .
  • Conduct periodic access reviews and security audits.
  • Manage enterprise application configurations within

    Microsoft Entra ID

    .
  • Support application registrations, service principals, authentication, and role assignments.
  • Ensure secure integration between Power BI, Fabric, and external enterprise systems.

6. BI Solution Development & Architecture

  • Lead the design and development of enterprise Power BI reporting solutions.
  • Review Power BI reports, dashboards, semantic models, and technical solutions.
  • Establish visualization, KPI, and reporting standards.
  • Ensure consistency and standardization of business metrics and KPI definitions.
  • Provide technical direction to BI developers and analysts.
  • Review and approve BI solutions before production deployment.

7. Business Requirement & Stakeholder Management

  • Conduct requirement-gathering workshops and stakeholder discovery sessions.
  • Translate business requirements into scalable technical BI solutions.
  • Define reporting roadmaps, priorities, and delivery plans.
  • Validate requirements, KPIs, acceptance criteria, and expected business outcomes.
  • Act as the primary technical point of contact for BI initiatives.
  • Communicate project status, risks, dependencies, and technical decisions to stakeholders.
  • Manage stakeholder expectations and competing priorities.
  • Facilitate executive-level reporting and analytics discussions.

8. Release & Deployment Management

  • Manage the Power BI solution lifecycle across

    Development, Test, and Production

    environments.
  • Implement controlled deployment processes using

    Power BI Deployment Pipelines

    .
  • Establish release governance, approvals, and deployment standards.
  • Coordinate production releases and rollback procedures.
  • Ensure production deployments follow enterprise governance and change-management practices.

9. Power BI / Fabric Center of Excellence Leadership

  • Lead and continuously enhance the organization's

    Power BI & Fabric Center of Excellence (COE)

    .
  • Define and maintain enterprise BI/Fabric standards and best practices.
  • Establish workspace onboarding and project onboarding/offboarding guidelines.
  • Develop reusable frameworks, templates, accelerators, and governance artifacts.
  • Drive adoption of enterprise BI and Microsoft Fabric capabilities.
  • Maintain technical documentation, standards, and governance frameworks.
  • Conduct knowledge-sharing sessions and technical enablement programs.
  • Drive initiatives to improve organizational BI maturity.

10. Team Leadership & Capability Development

  • Lead, mentor, and guide BI developers and analysts.
  • Conduct technical reviews, code reviews, and solution reviews.
  • Allocate resources based on business priorities and project requirements.
  • Support recruitment, onboarding, and performance evaluation activities.
  • Identify technical skill gaps and define training requirements.
  • Promote adoption of modern Microsoft Fabric capabilities.
  • Drive continuous improvement across the BI development and support lifecycle.

11. Cross-Functional & Vendor Management

  • Collaborate with

    Data Engineering, Infrastructure, Security, Application, and IT support teams

    .
  • Drive cross-functional resolution of technical issues and dependencies.
  • Coordinate with vendors and technology partners where required.
  • Support enterprise-wide analytics and digital transformation initiatives.
  • Ensure alignment between BI strategy, platform capabilities, and business requirements.

12. Monitoring, Audit & Compliance

  • Conduct periodic Power BI and Fabric platform health reviews.
  • Review workspace governance and compliance.
  • Audit security access, licensing utilization, and platform adoption.
  • Track Power BI/Fabric usage and adoption metrics.
  • Ensure adherence to organizational data governance standards.
  • Support internal and external audit activities.
  • Maintain documentation required for governance, audit, and compliance.

Required Technical Skills

Mandatory

  • Strong hands-on experience with

    Microsoft Power BI

    .
  • Strong understanding of

    Power BI Service and Semantic Models

    .
  • Experience with

    Microsoft Fabric

    administration and governance.
  • Strong knowledge of

    DAX and Power BI performance optimization

    .
  • Strong understanding of data modeling and enterprise semantic models.
  • Experience with

    Power BI Deployment Pipelines

    and release management.
  • Experience with Power BI workspace and access management.
  • Knowledge of

    RLS and OLS

    .
  • Experience with Power BI refresh monitoring and RCA.
  • Experience with

    Microsoft Entra ID

    , security groups, application registrations, and service principals.
  • Experience managing or governing

    Fabric Capacity

    .
  • Strong understanding of BI governance and enterprise reporting standards.

Good to Have

  • Experience with Fabric workloads such as:
  • Lakehouse
  • Warehouse
  • Data Factory
  • Dataflows
  • Notebooks
  • Knowledge of Azure services and cloud-based data platforms.
  • Experience with Microsoft Purview and enterprise data governance.
  • Experience with Tabular Editor or other semantic model development tools.
  • Knowledge of CI/CD and DevOps practices for BI solutions.
  • Exposure to AI/Copilot capabilities within the Microsoft data and analytics ecosystem.

Leadership & Soft Skills

  • Strong technical leadership and decision-making capability.
  • Excellent stakeholder and communication skills.
  • Ability to translate business requirements into technical solutions.
  • Strong problem-solving and RCA capabilities.
  • Ability to manage multiple priorities and enterprise-level initiatives.
  • Strong mentoring and team-management capabilities.
  • Ability to establish and enforce governance standards.
  • Strong documentation and knowledge-sharing skills.
  • Ability to work effectively across business and technical teams.

Interested candidate can share their CV on shilpi.kumari@celebaltech.com

Skills Required

Power Bi Dax Intelligence SQL Data Modeling Microsoft Azure Business intelligence

Learn the skills this job asks for

See your skill gap for Data Analyst →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Business Intelligence Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Celebal Technologies logo
Celebal Technologies

RecommendedJobs for You

Celebal Technologies logo

Business Intelligence Lead

Celebal Technologies

Delhi

Fastenal logo

Bengaluru

E

Business Intelligence Lead

Euphoric Thought Technologies Pvt Ltd

India

Celebal Technologies logo

Business Intelligence Lead

Celebal Technologies

Delhi

Fastenal logo

Bengaluru

E

Business Intelligence Lead

Euphoric Thought Technologies Pvt Ltd

India