Power BI Administrator/Architect

HCLTech; Lucknow; On-site; INR 3,500,000 - 5,500,000; Full time

Job summary

HCLTech in Lucknow, India, seeks an experienced Power BI Administrator to lead the administration of Power BI Service, Premium Capacity, and Fabric environments. You will configure tenants, workspaces, datasets, and reports, while ensuring high availability of gateways and monitoring service health.

Strong security and governance practices are essential. The role requires 10+ years in Power BI, expertise in data modeling and performance optimization, and collaboration with business stakeholders

Qualifications

• 10+ years of Power BI administration experience.
• In-depth knowledge of Power BI tenant, workspace, dataset, and report configuration.
• Experience with On-Premises Data Gateway management and troubleshooting.
• Strong understanding of Power BI security models (RLS/OLS).
• Experience monitoring capacity metrics and troubleshooting dataset refresh and performance issues.

Responsibilities

• Manage Power BI Service, Premium Capacity, and Fabric environments.
• Configure and maintain Power BI tenants, workspaces, datasets, and reports.
• Manage gateways (On-Premises Data Gateway) and ensure high availability.
• Monitor Power BI service health, performance, and capacity utilization.
• Implement and maintain backup, disaster recovery, and governance policies.

Skills

Power BI Admin

Power BI Service

Premium Capacity

Security: RLS/OLS

Data Gateway

Performance Tuning

Backups & DR

Stakeholder Communication

Troubleshooting

Tools

Azure DevOps CI/CD

Job description

Skill Requirements

• Proven experience min 10 years in administering Power BI environments, including Power BI Service and Premium Capacity.
• In-depth knowledge of Power BI tenant, workspace, dataset, and report configuration.
• Experience with On-Premises Data Gateway management and troubleshooting.
• Strong understanding of Power BI security models, including RLS and OLS.
• Hands-on experience in monitoring capacity metrics, optimizing resource utilization, and troubleshooting dataset refresh and performance issues.
• Proficiency in implementing backup, disaster recovery, and governance policies.
• Demonstrated experience in supporting CI/CD pipelines using Azure DevOps or Git.
• Excellent problem-solving abilities and experience providing advanced (L2/L3) support.
• Strong collaboration and communication skills with the ability to partner with technical and business stakeholders.

Other Requirements (Optional)

• Power BI or Microsoft certifications (e.g., DA-100, PL-300) are highly desirable.
• Experience in large-scale, enterprise Power BI deployments.
• Familiarity with data modeling, DAX query optimization, and report design best practices.
• Knowledge of cloud platforms (Azure) and related services.
• Prior experience in developing and delivering user training sessions.

Key Responsibilities

• Manage and administer Power BI Service, Power BI Premium Capacity, and Power BI Fabric environments.
• Configure and maintain Power BI tenants, workspaces, datasets, and reports.
• Manage gateways (On-Premises Data Gateway) and ensure high availability.
• Monitor Power BI service health, performance, and capacity utilization.
• Implement and maintain backup, disaster recovery, and governance policies.

Security & Governance

• Configure Row-Level Security (RLS) and Object-Level Security (OLS).
• Manage user roles, permissions, and workspace access.
• Implement tenant-level security settings and governance frameworks.
• Ensure compliance with organizational security standards and audit requirements.
• Monitor data access and usage through audit logs and activity reports.

Performance Optimization

• Monitor Premium Capacity metrics and optimize resource utilization.
• Identify and troubleshoot dataset refresh failures and performance bottlenecks.
• Work closely with developers to optimize DAX, data models, and report performance.
• Implement best practices for report development and deployment.

Monitoring & Support

• Provide L2/L3 support for Power BI users and stakeholders.
• Troubleshoot connectivity, refresh, gateway, and licensing issues.
• Create operational dashboards and reports for environment monitoring.
• Manage incidents, service requests, and root cause analysis.

Deployment & Release Management

• Support Dev, Test, and Production environments.
• Implement CI/CD pipelines using Azure DevOps or Git integration.
• Manage deployment pipelines and version control processes.
• Coordinate releases and production deployments.

Stakeholder Collaboration

• Partner with business users, BI developers, data engineers, and architects.
• Conduct user training and awareness sessions.
• Define governance standards and platform adoption strategies.