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
We are looking for an experienced BI Lead Power BI & Microsoft Fabric to lead the design, development, administration, governance, and operational management of enterprise Business Intelligence solutions.
The role will be responsible for ensuring the scalability, security, performance, reliability, and governance of the organization's Power BI and Microsoft Fabric ecosystem. The BI Lead will work closely with business stakeholders, Data Engineering, Infrastructure, Security, and Application teams while leading BI developers and analysts.
The position combines 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.
- Robust documentation and knowledge-sharing skills.
- Ability to work effectively across business and technical teams.
Interested candidate can share their CV on
[email protected]
📌 Business Intelligence Lead (New Delhi)
🏢 Celebal Technologies
📍 New Delhi