Power BI Administrator

Who We Are: CAE Vision: Our vision is to be the worldwide partner of choice in defense and security, and civil aviation by revolutionizing our customers’ training and critical operations with digitally immersive solutions to elevate safety, efficiency and readiness. CAE Defense & Security Mission: CAE's Defense and Security business unit focuses on helping prepare military customers to develop and maintain the highest levels of mission readiness. CAE Values: Empowerment, Innovation, Excellence, Integrity and OneCAE make us who we are and we strive to make a difference in the world while helping each other succeed. What We Have to Offer: Comprehensive and competitive benefits package and flexibility that promotes work-life balance A work environment where all employees are valued, respected and safe Freedom to succeed by enabling team members to deliver, take initiatives and make decisions Recognition, professional development, advancement and having fun! Summary 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). This role ensures secure, reliable, scalable BI environments; enables CI/CD deployment pipelines for Power BI; manages workspace governance; and ensures robust connectivity and refresh architecture with Snowflake. The position serves as the enterprise expert and technical authority for Power BI platform operations and capacity management. Essential Duties and Responsibilities Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 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. Preferred Skills Experience with Microsoft Fabric and Snowflake administration. Knowledge of data governance, security compliance, and role‑based access control. Familiarity with automation via PowerShell, Fabric APIs, or REST APIs. Experience managing enterprise‑scale BI transformation programs. Strong communication skills and ability to collaborate across technical and non‑technical teams. Security Responsibilities Must comply with all company security and data protection/usage policies and procedures. Personally responsible for proper marking and handling of all information and materials, in any form. Shall not divulge any information, or afford access, to other employees not having a need to know. Shall not divulge information outside the company without management approval. All government and proprietary information will be accessed and stored electronically on company provided resources. Incumbent must be eligible for DoD Personal Security Clearance. Work Environment Duties performed in an office environment and manufacturing facility. Must be able to work overtime on and off‑shifts as required. The employee is on call 24x7 for the resolution of problems and issues. Physical Demands Must be able to sit or stand at a workstation for extended periods. Must be able to lift up to 25 lbs. for equipment setup or maintenance. Other Duties Please note this job description is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities required of the employee. Duties, responsibilities, and activities may change at any time with or without notice. Equal Opportunity Employer We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin or any other protected factor. Data Privacy We value the privacy of our prospective employees and employees. All data collected through the application process is handled in accordance with our privacy policies. #J-18808-Ljbffr CAE