1. Proper Job Description
Technical Skills:
Power BI administration
• Manage and troubleshoot Power BI Gateway and Report Server issues from an administrative perspective.
• Perform fabric capacity planning to optimize resource utilization. FUAM and Fabric Capacity complete understanding.
• Administer Power BI Gateway Server, Report Server, and SSRS environments.
• Manage Power BI Data Gateway Clusters, user access, data connections, and configurations.
• Develop monitoring solutions and automation scripts to ensure system uptime and health.
• Work on Windows on-premises server platforms for deployment, maintenance, and upgrades.
• Manage Power BI Premium capacities, including workspace and group management in the cloud.
• Install, configure, and maintain Power BI Desktop, Power BI Report Builder, and Power BI Report Server applications.
• Set up data sources and configure drivers for Oracle, SQL Server, DB2, MySQL, and Azure Synapse.
• Expertise in integrating Power BI with Azure and Databricks.
• Develop, test, and enhance Power BI audit reports during maintenance activities.
• Integrate Power BI report server metadata with Collabra and manage SSL certificate renewal processes.
• Create and maintain advanced performance analysis reports for Power BI models, DAX queries, and system metrics.
• Monitor and analyse Gateway metrics to identify performance issues.
• Collaborate on Power BI audit report enhancements and assist with Hyperion to Power BI migration audits.
• Implement Azure Blob Storage solutions for copying Gateway statistics using PowerShell scripts.
• Manage service account configurations and automate offline data source refreshes with Power Automate.
• Perform Power BI Gateway upgrades and apply key configuration changes for system stability.
• Support Power BI report server setup, maintenance, and metadata management.
• Document best practices, troubleshooting procedures, and performance optimization strategies.
• Strong automation expertise using Python and PowerShell scripting is essential.
• Hands on experience in creating ad hoc Power BI reports for audit requirements is required.
Responsibilities:
• Respond to and resolve tickets on technical issues related to Power BI Platform within defined SLA.
• Work closely with users assisting with Power BI issues, training, and building good working relationships.
• Assist user and project support for all BI Systems.
• Creation and maintenance of system documentation related to the Power BI environment.
• Ability to prioritize and work on multiple tasks simultaneously.
• Strong communication and organizational skills.
• Document the issues in knowledgebase entry and train the team to handle the recurring issues.
2. Primary Skills in 5 liners that manager cannot negotiate on –
• Expertise in complete Power BI administration, including workspace, capacity, and gateway management.
• Strong knowledge of tenant settings, security configurations, and governance best practices.
• Hands on experience with Power BI Service, monitoring, auditing, and usage analytics.
• Proficiency in managing data refreshes, gateways, deployments, and workspace lifecycle.
• Ability to enforce compliance, optimize performance, and support enterprise level Power BI environments.
Skills Required
Oracle Sql Server, Power Bi Desktop, Azure, Azure Synapse, Ssrs, Db2, Power Automate, Mysql, Databricks, Python, Powershell