Power BI Administrator

We are seeking a highly skilled and detail-oriented Power BI Administrator with hands-on experience in managing enterprise-scale Power BI environments. The candidate will play a crucial role in ensuring secure, scalable, and optimized reporting operations while enabling seamless collaboration between business users, developers, and IT teams. The role involves overseeing the complete administration of Power BI service, including workspace governance, deployment pipelines, access/security controls, data gateway configuration, license management, performance monitoring, and compliance support.

This position will be instrumental in supporting the transition from MicroStrategy to Power BI, ensuring smooth migrations, enforcing governance policies, and maintaining high availability of business-critical dashboards and reports.

Key Responsibilities :

1. Workspace & Pipeline Management :

- Design, create, and manage Power BI workspaces for different environments (Development, UAT, and Production).

- Configure and monitor deployment pipelines to ensure controlled and seamless movement of reports, datasets, and dashboards across environments.

- Manage Active Directory (AD) groups for role assignments and enforce secure access to Power BI resources.

- Configure Row-Level Security (RLS) and Object-Level Security (OLS) to safeguard sensitive data.

- Ensure compliance with organizational security policies while providing appropriate levels of access for developers, analysts, and end-users.

3. Report Deployment & Migration :

- Manage the end-to-end migration of reports and datasets from MicroStrategy and other BI platforms into Power BI.

- Ensure version control and consistency of reports while deploying updates or enhancements across environments.

- Collaborate with development teams to maintain release notes, rollback strategies, and deployment documentation.

4. Data Gateway & Refresh Management :

- Install, configure, and manage On-Premises Data Gateways for hybrid data connectivity.

- Monitor and troubleshoot scheduled refresh failures, ensuring business-critical reports remain up to date.

- Work with database teams to maintain stable data source connections and resolve credential/permission issues.

5. Monitoring & Optimization :

- Monitor Power BI Service health, including usage metrics, refresh performance, and capacity utilization.

- Proactively identify and resolve performance bottlenecks in datasets, reports, and dashboards.

- Optimize queries, model designs, and refresh schedules to maintain high-quality reporting experience.

6. Licensing & Governance :

- Manage Power BI licensing (Pro, Premium, Fabric/Capacity nodes) for users and teams.

- Enforce governance frameworks, including naming conventions, workspace usage policies, and security guidelines.

- Maintain audit logs and ensure adherence to organizational standards and compliance requirements.

7. Collaboration & Stakeholder Management :

- Act as the primary liaison between developers, business teams, and IT administrators to ensure alignment of requirements.

- Provide guidance and training to developers and analysts on Power BI best practices.

- Support business teams in adopting Power BI by enabling self-service BI within governance boundaries.

8. Issue Resolution & Support :

- Troubleshoot and resolve user access issues, refresh failures, and performance degradation.

- Provide L2/L3 level support for Power BI incidents escalated by end-users or IT support teams.

- Ensure minimum downtime and fast resolution for business-critical reporting issues.

9. Audit, Compliance & Documentation :

- Maintain detailed logs and records of workspace changes, user access, and activity monitoring.

- Support compliance audits by providing evidence of security controls, access history, and governance policies.

- Document processes, SOPs, and best practices for Power BI environment management.

Required Skills & Competencies :

- Strong hands-on experience (4+ years) in Power BI Administration.

- Expertise in managing Power BI Service, Workspaces, and Deployment Pipelines.

- Strong knowledge of Row-Level Security (RLS), OLS, and AD group management.

- Proficiency in Power BI Gateway setup and refresh troubleshooting.

- Experience in managing licenses (Pro, Premium, Fabric/Capacity) and monitoring usage metrics.

- Ability to analyze and resolve performance issues in reports/datasets.

- Familiarity with compliance, audit, and governance frameworks for BI tools.

- Strong collaboration and communication skills with cross-functional teams.

- Exposure to MicroStrategy to Power BI migration (preferred).

- Good problem-solving, troubleshooting, and documentation skills.

Nice to Have :

- Knowledge of PowerShell scripting for Power BI administration tasks.

- Familiarity with Fabric/Power Platform ecosystem (Power Apps, Power Automate).

- Prior experience in large-scale BI transformations and cloud migration projects.

- Exposure to SQL, DAX, Azure Data Services (ADF, Synapse, Data Lake).