Senior BI Analytics Engineer
- Markham, ON, Canada
Contract
Applications open in a new tab.
Job details
- Job type
- Contract
- Apply by
- Experience
- 3+ years of hands-on experience developing and supporting Power BI solutions in a production environment.
- Posting language
- English
- Posted
Original job description
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.
More about this job
Responsibilities
Develop, maintain, and troubleshoot shared Power BI semantic models and reports using Microsoft Fabric and Direct Lake, while validating data and resolving production issues. Work with business and technical stakeholders to understand reporting needs, explain technical findings, assess change impacts, and deliver reliable solutions.
Requirements
Requires at least three years of hands-on experience developing and supporting production Power BI solutions, along with Microsoft Fabric and Direct Lake experience. Candidates need strong dimensional modeling, advanced DAX and SQL skills, production troubleshooting experience, and the ability to work independently and communicate effectively with stakeholders.
Skills
- Microsoft Fabric
- Power BI
- Direct Lake
- Semantic Modeling
- Dimensional Modeling
- Star Schema Design
- DAX
- SQL
- Data Profiling
- Data Reconciliation
- Lakehouses
- Delta Tables
- Production Support
- Performance Optimization
- Stakeholder Management
- Requirements Gathering
Visa sponsorship
Not detected in the job text
Categories
- Data & Analytics
- Technology
- Software
- Customer Service & Support
Keywords
- Microsoft Fabric
- Power BI
- Direct Lake
- Customer Service Reporting
- Semantic Models
- Shared Power BI Models
- Dimensional Modeling
- Fact Tables
- Dimension Tables
- Star Schemas
- Grain Definition
- Surrogate Keys
- Business Keys
- Relationship Design
- DAX
- Filter Context
- Time Intelligence
- Virtual Tables
- SQL
- Data Profiling
- Data Reconciliation
- Root Cause Analysis
- Data Validation
- Fabric Lakehouses
- Delta Tables
- Production Incident Resolution
- Regression Impact Assessment
- Performance Optimization
- Requirements Gathering
- Stakeholder Management