Lead Service Engineer
Job Summary:
We are seeking an experienced Power BI Infrastructure Administrator to manage and maintain the Power BI environment within our organization. The ideal candidate will be responsible for governance, security, performance optimization, and administration of Power BI Service, Report Server, and data gateways. The role involves ensuring seamless integration with enterprise data sources while maintaining compliance, security, and scalability of the Power BI ecosystem.
Key Responsibilities:
Power BI Environment Management & Administration:
- Manage and administer Power BI Service (Cloud) and/or Power BI Report Server (On-Premises).
- Configure Power BI tenant settings, capacity management, workspace policies, and sharing permissions.
- Monitor and optimize Power BI Service performance, refresh schedules, and dataset processing.
- Manage Power BI Data Gateway setup, troubleshooting, and scaling for hybrid environments.
- Ensure seamless integration with Azure, SQL Server, SharePoint, and third-party data sources.
Security, Compliance & Governance:
- Implement role-based access controls (RBAC), row-level security (RLS), and object-level security (OLS).
- Configure Microsoft Entra ID (formerly Azure AD) authentication, conditional access, and MFA policies.
- Enforce data governance policies, compliance (GDPR, HIPAA, ISO 27001), and audit logging.
- Monitor Power BI tenant activity logs, audit reports, and security alerts using Microsoft Purview.
Infrastructure & Performance Optimization:
- Optimize Power BI Premium capacity, licensing, and workload management.
- Monitor dataset refresh failures, optimize DAX queries, and implement best practices for performance tuning.
- Work with Azure administrators to configure Azure Synapse Analytics, Data Lakes, and Data Factories for Power BI.
- Manage and troubleshoot Power BI Embedded for external reporting solutions.
Monitoring, Troubleshooting & Support:
- Proactively monitor Power BI health, performance, and resource utilization using PowerShell and Microsoft tools.
- Troubleshoot Power BI service outages, connectivity issues, and report performance bottlenecks.
- Provide L2/L3 support for Power BI infrastructure issues.
- Collaborate with Microsoft Premier Support for escalations and best practices.
Automation & Scripting:
- Develop and maintain PowerShell scripts for automated user provisioning, workspace management, and reporting.
- Utilize Power BI REST APIs and Graph APIs for automation and custom integrations.
- Implement monitoring dashboards for Power BI capacity, performance, and refresh failures.
Training, Documentation & Collaboration:
- Document Power BI configurations, security settings, best practices, and troubleshooting guides.
- Train end-users, developers, and analysts on Power BI governance, security, and optimization techniques.
- Work closely with Data Engineering, Security, and Compliance teams to enhance Power BI solutions.
Required Skills & Qualifications:
Technical Skills:
- 5-8 years of experience in Power BI administration and infrastructure management.
- Expertise in Power BI Service, Power BI Report Server, and Power BI Premium capacity management.
- Strong knowledge of Power BI Data Gateway, Direct Query, and dataset refresh optimization.
- Experience with PowerShell scripting for automation and administration.
- Understanding of security best practices, RBAC, RLS, OLS, and Microsoft Entra ID (Azure AD).
- Proficiency in SQL Server, Azure Synapse, and other enterprise data sources for Power BI.
- Experience with Power BI REST APIs, Graph APIs, and custom integrations.
- Experience with Azure Log Analytics, Microsoft Sentinel, and Power BI monitoring tools.
- Knowledge of third-party Power BI governance and monitoring solutions (Power BI Sentinel, Enterprise DNA, etc.).
- Experience with Power BI Embedded, paginated reports, and complex enterprise-scale BI deployments.
Soft Skills:
- Strong problem-solving and troubleshooting skills.
- Excellent communication and documentation abilities.
- Ability to work independently and collaborate in a fast-paced IT environment.
- Customer-oriented mindset with a focus on resolving technical issues efficiently.
Preferred Qualifications (Nice to Have):
- Microsoft certifications such as PL-300 (Power BI Data Analyst Associate) or DP-500 (Azure Enterprise Data Analyst Associate).