Power BI Report Server Administrator

LanceSoft Inc; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A consulting firm in Toronto is seeking an experienced Power BI Report Server Administrator to manage and optimize its reporting infrastructure. The ideal candidate has over 10 years of IT experience, including 5 years with Power BI Report Server, and extensive knowledge of server migrations and SQL Server management. This hybrid position offers flexibility with in-office days and the chance to work on critical BI projects.

Qualifications

• Minimum 10 years of experience in IT infrastructure or BI administration roles.
• Minimum 5 years of hands-on experience with Power BI Report Server.
• 5+ years of experience with Server Migrations.
• 8+ years of experience with SQL Server including performance tuning.
• Previous experience working in a project-based environment.

Responsibilities

• Manage, maintain, and optimize the Power BI Report Server infrastructure.
• Plan and execute complex server migrations.
• Ensure high availability, performance, and scalability of reporting solutions.

Skills

Power BI Report Server

Data Modelling

Server Migrations

SQL Server

Windows Server Administration

PowerShell Scripting

Active Directory & Kerberos

Cloud Platforms

Monitoring Tools

Backup & Recovery

Education

Bachelor’s or Master’s degree in Computer Science or related field

Job description

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.

Nice to have:
1) Previous experience working with TOP 5 Banks/FI
2) PowerShell Scripting: Ability to automate tasks and manage server configurations using scripts.
3) Cloud Platforms: Familiarity with Azure (especially Power BI Service, Azure SQL, and Azure Active Directory) is a plus.

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.

#NIT001