Senior BI Analytics Engineer

WE'RE HIRING: Senior BI / Analytics Engineer – Microsoft Fabric & Power BI (Direct Lake)

Location: Markham, ON Canada (Hybrid) - 2 days in office, Tuesday mandatory, second day candidates’ choice

Duration: 12+ Months Contract

MUST HAVES:

- hands-on Microsoft Fabric and Direct Lake experience

- experience across both data analytics and Power BI, not someone focused solely on dashboard development

- no time for ramp up need to be self sufficient

- Equally important are communication and stakeholder management skills. This individual will work directly with business users to understand issues, explain technical concepts, gather requirements, and drive solutions.

Customer Service Reporting | Power BI / Microsoft Fabric

Required Qualifications

3+ years of hands-on experience developing and supporting Power BI solutions in a production environment.

Experience designing, maintaining, and troubleshooting shared or centralized Power BI semantic models supporting multiple reports.

Hands-on experience with Microsoft Fabric and Direct Lake semantic models.

Strong dimensional modelling skills, including fact and dimension design, star schemas, grain definition, surrogate or business keys, and relationship design.

Advanced DAX skills, including filter context, relationship behaviour, virtual tables, time intelligence, reusable measures, and performance-aware calculation design.

Strong SQL skills for data profiling, reconciliation, root cause analysis, and validation.

Experience working with Fabric Lakehouses and Delta tables, including validating data between Lakehouse tables and semantic model outputs.

Experience resolving production incidents involving missing data, unexpected totals, filter behaviour, model changes, or report performance.

Experience assessing model dependencies and regression impacts before deploying changes.

Ability to document technical findings clearly and work independently with business and technical teams.