Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Experis Canada

NewBe an early applicant

Business Intelligence Engineer

Posted

Summary

12-month contract BI Analytics Engineer in Markham (hybrid, 2 office days/week) building and supporting production Power BI semantic models on Microsoft Fabric with Direct Lake, Delta Lakehouse tables, advanced DAX, dimensional modelling, and SQL to validate data and resolve reporting incidents.

Job Title: BI Analytics Engineer

Location: Markham - ON

Hybrid: 2 days in office, Tuesday mandatory, second day candidates’ choice

Contract: 12 months + Extendable


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
  • 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.


Skills

Apply

See also

Data Analytics jobs by country — openings, pay and top skills →