Power BI Administrator-EN

About the role

The Power BI Administrator is responsible for the enterprise administration, configuration, governance, and optimization of CAE’s Power BI ecosystem, including Power BI Pro, Premium Per User (PPU), and Premium Capacities (P1–P5).

Responsibilities

• Serve as the enterprise administrator and subject matter expert for Power BI Pro, PPU, and Premium Capacity (P1–P5).
• Architect, configure, and maintain Power BI Premium capacities, including workload settings, autoscale policies, refresh optimization, and performance monitoring.
• Implement and manage CI/CD pipelines for Power BI deployment using GitHub.
• Govern and manage workspace design, workspace roles, security groups, and access policies.
• Administer tenant settings, licensing, gateways, and Power BI configurations.
• Monitor and optimize dataset refresh schedules, gateway performance, and Snowflake connections.
• Establish and maintain best practices for dataset modeling, refresh design, and capacity allocation.
• Provide enterprise governance documentation, standards, and compliance controls for Power BI usage.
• Troubleshoot and resolve issues related to dataset failures, refresh errors, capacity overload, and gateway connectivity.
• Partner with Data Engineering and Cloud teams to optimize Snowflake-to-Power BI performance and reliability.
• Conduct capacity utilization reviews and recommend scaling or reallocation actions.
• Support operational readiness, including monitoring, alerting, and performance dashboards for BI infrastructure.
• Train and mentor analysts, report developers, and business users in Power BI governance, usage, and administration best practices.

Qualifications and Education Requirements

• 5+ years of hands-on experience administering and managing Power BI, including Power BI Pro, PPU, and Premium capacities (P1–P5).
• Expert knowledge of Power BI Service administration, tenant settings, workspace governance, licensing models, gateways, and security.
• Strong experience implementing CI/CD for Power BI dashboards and datasets using Azure DevOps, Git integration, or related tools.
• Experience with DAX, data modeling, and enterprise BI development best practices.
• Familiarity with Power BI Admin Portal.
• Strong reasoning, analytical, and troubleshooting skills.

Relevant certifications preferred: Microsoft Certified: Power BI Data Analyst Associate.

Due to U.S. Government contract requirements, only U.S. citizens are eligible for this role.