cover image
Collabera

BI Developer (Architect) - Power BI Databricks and SSRS SSAS

On site

Toronto, Canada

Freelance

28-01-2026

Share this job:

Skills

Communication SQL power bi SQL Server Recruitment Databricks DAX

Job Specifications

The expected per hour range for this position is $70/Hr - $90/Hr depending on experience, skills, and internal equity.
The Company offers a total rewards package for this position that may include employer-sponsored benefits, where applicable and subject to eligibility requirements, such as supplemental health and dental coverage, life insurance, disability insurance, retirement or savings programs, paid time off, and other benefits.
The availability, structure, and scope of benefits may vary based on role, employment status, work location, and applicable federal and provincial laws.
The Company provides all statutory entitlements, including public holidays, vacation, leaves of absence, and government-mandated benefits, in accordance with applicable law
We may use AI-enabled and/or automated tools to support parts of our recruitment process, including application screening, interview scheduling, and candidate communications.
These tools are used to enhance consistency and efficiency.
All hiring decisions involve human review and are not based solely on automated processing.

Role Overview / Team Context:

Reporting team focused on presenting data & insights to business stakeholders, executives, and occasionally external clients/executives
High-visibility deliverables → strong communication + visualization skills are critical
Active parallel projects include:
Migration from Databricks → SSRS (SQL Server Reporting Services)
Migration from SSAS (SQL Server Analysis Services) → Fabric
Current team: 10 FTEs + 13 Contractors
Growth plan: Actively planning to hire 4-5 additional resources

Core Technical Requirements (Must-Haves)

Power BI development - strong hands-on experience
Advanced DAX
Power Query (M language)
Databricks - solid practical experience
SSRS (SQL Server Reporting Services) - development & deployment experience
SSAS (SQL Server Analysis Services) - development & modeling experience

Nice-to-Haves:

Fabric - exposure or hands-on experience (especially relevant given active migration project)

Interview Process:

2 rounds total:

Virtual Technical Screening - 45 minutes
In-person Technical Round - 30 minutes (Toronto onsite)

Key Takeaways:

Looking for a very strong Power BI + Databricks profile
Must be comfortable with legacy BI stack (SSRS & SSAS) due to ongoing migrations
Fabric knowledge would be a strong differentiator
Candidate should be prepared to discuss executive-facing reporting / dashboard delivery experience

About the Company

In our relentless pursuit of greatness, we are dedicated to developing individuals, creating exceptional teams, and cultivating a unique culture of unity and care. As providers of digital talent solutions, we aim to positively impact businesses and communities globally. We would be honored to be your trusted and uncommon partner on this journey. Know more