BI Developer

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 lawWe 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