The PowerBI Platform Administrator will be responsible for maintaining and improving the PowerBI platform. The focus area of this position will be to advance the future state of self-service analytics.
The associate should have at least relevant experience in Power BI administration of 5+ years
Roles and Responsibilities:
- Administer Microsoft Power BI platform and On-Premise Gateways, lead upgrade planning, configuration, and capacity planning
- Coordinate with Microsoft Premium Support and other IT team members when troubleshooting and resolving performance issues
- Guide Power BI Dashboard developers and other colleagues during dashboard development using Power BI and DAX to establish and promote best practices for dashboard and data set development and -publishing (location, layout, dataset access, DAX usage, security, performance tuning, naming conventions)
- Optimize Workspaces and datasets to promote ease of self-service, and provide a secure, structured organization of workspaces, apps, data sets and dashboards
- Work with business partners to migrate the existing workspaces and data sets into an organized catalogue of information areas and data sets
- Advance access control, and data security capabilities
- Establish monitoring and service performance reporting together with operational teams
- Automate data refreshes and other activities through PowerShell scripting
- Assess, build, and optimize new and existing reports and data visualization dashboard prototypes using Power BI and DAX as required to triage issues, or to recommend improvements
- Self-starter, can troubleshoot complex data problems, brings strong analytical skills with a focus on detail, thoroughness, and quality and must be a team player with strong attention to detail and able to work independently and good awareness of Power BI Premium Capacity Metrics
- Experience performing Power BI On-Prem Data Gateway installation, upgrades, and configurations
- Has a solid understanding of Power BI security capabilities (access control, data row-level security, use of roles to control sharing, publishing, data export)
- Is proficient in SQL and experience in relational databases / data warehouses (Oracle, SQL Server)
- Good to have solid experience with Power Automation and Power apps and their configuration and integration with other Azure components.