Cloud Data Administrator - Power BI (6-11 yrs)

Admin :

- Report on usage and performance of Power BI premium capacities.

- Setup alerts in case of Power BI capacity overloading.

- Establish/extend monitoring of Power BI and Power BI premium capacities.

- Analyze top 5 most used workspaces regarding workloads using Log Analytics data.

- Get understanding of what reports and datasets are causing high workloads using Log Analytics data.

- Grant access rights to PBI developers using AD group concept on PBI workspaces.

- Establish Azure connections for dataset backup/restore and Log Analytics on PBI workspaces.

- Manage PBI gateways with NOC Team i.e. connect PBI workspace to Azure storage accounts; SQL MI DBs; SQL Pools etc.

- Based on log data point out slow DAX/MDX user queries as well as long running data sets

- Manage power bi premium capacities.

- Understand report usage metrics and identify slow performant visuals and work with developers on how to finetune underlying queries associated to the report visuals.

Support :

- Handle support tickets issued by PBI users and developers (1 st , 2 nd and 3 rd level)

- Fix connection issues

- Check and resolve reason for long running reports/cubes

- Check and resolve reason for error messages

- Work close together with report and dataset developers giving them information to improve their reports and datasets

Skills :

- Very good knowledge on Power BI admin portal

- Very good knowledge of managing Power BI workspaces

- Very good knowledge of PBI system architecture (data access infrastructure using gateways, Power BI premium

- Very good understanding of DAX and Power Query (M query) and it's CPU and memory impact

- Proactive mindset to ensure overall good system performance (I.e.: prevent performance degradation and system downtime)