Location Address: Toronto
Hybrid: currently 2-3 days in-office and 4 days from September.
Anchor days: Monday, Wed
Contract Duration: ASAP to 10/31/2025.
Possibility of extension: Yes
Conversion to FTE: yes, based on performance and business needs
Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week
Business group: Data Models & Analytics
Project: Software currency Remediation project
Reason: Server upgrade to address vulnerabilities identified.

JOB SUMMARY

We are seeking a highly experienced and technically proficient Power BI Report Server Administrator to manage, maintain, and optimize our Power BI Report Server infrastructure. The ideal candidate will have extensive experience in server migrations, report lifecycle management, and enterprise-level BI deployments. This role requires deep technical expertise, strategic thinking, and the ability to collaborate across teams to ensure high availability, performance, and scalability of reporting solutions.

TECHNICAL SKILLS:

• Power BI Report Server: Deep expertise in administration, configuration, and optimization, and report build.
• Data Modelling: Strong understanding of data modeling, DAX and Power Query., ETL processes, and data warehousing concepts.
• Server Migrations: Proven experience with planning and executing complex migrations (e.g., Windows Server, SQL Server, Power BI Report Server).
• SQL Server: Advanced knowledge of SQL Server (SSRS, SSAS, SSIS), including performance tuning and database management.
• Windows Server Administration: Strong skills in managing Windows Server environments, including networking, firewalls, and domain services.
• PowerShell Scripting: Ability to automate tasks and manage server configurations using scripts.
• Active Directory & Kerberos: Experience with authentication mechanisms and integration with enterprise identity systems.
• Cloud Platforms: Familiarity with Azure (especially Power BI Service, Azure SQL, and Azure Active Directory) is a plus.
• Monitoring Tools: Experience with tools like System Center, SolarWinds, or custom dashboards for server health and performance.
• Backup & Recovery: Knowledge of disaster recovery planning and implementation for BI environments.

MUST HAVE SKILLS:

1) Minimum 10 years of experience in IT infrastructure or BI administration roles.
2) Minimum 5 years of hands-on experience with Power BI Report Server.
3) 5+ years of experience with Server Migrations: Proven experience with planning and executing complex migrations (e.g., Windows Server, SQL Server, Power BI Report Server).
4) 8+ years of experience SQL Server: Advanced knowledge of SQL Server (SSRS, SSAS, SSIS), including performance tuning and database management.
5) Previous experience working in a project-based environment is required.

SOFT SKILLS REQUIRED:

• Strong analytical and problem-solving skills.
• Excellent communication and documentation abilities.
• Ability to work independently and manage multiple priorities.

EDUCATION:

• Bachelor’s or Master’s degree in Computer Science, Information Systems, or related field
• Certifications such as Microsoft Certified: Power BI Data Analyst Associate, MCSE: Data Management and Analytics, or equivalent are preferred.
  Best VS. Average Candidate:
  Seeking a highly experienced and technically proficient Power BI Report Server Administrator to manage, maintain, and optimize our Power BI Report Server infrastructure. The ideal candidate will have extensive experience in server migrations, report lifecycle management, and enterprise-level BI deployments. This role requires deep technical expertise, strategic thinking, and the ability to collaborate across teams to ensure high availability, performance, and scalability of reporting solutions.

Please refer the Job description for details