Senior Business Intelligence Developer
SNDL Inc.
full-time
Posted on:
Location Type: Hybrid
Location: Edmonton • Canada
Visit company websiteExplore more
Salary
💰 CA$100,000 - CA$110,000 per year
Job Level
About the role
- Build reusable, scalable report templates
- Implement advanced DAX measures aligned to standardized KPI definitions
- Optimize performance of semantic models and reports
- Support migration of legacy reports into Fabric/Power BI
- Design and maintain enterprise Power BI semantic models
- Implement star schema models using conformed dimensions
- Collaborate with Senior Analytics Engineer on schema design
- Ensure consistent use of conformed dimensions and measures
- Avoid metric duplication and shadow calculations
- Support RLS implementation and governance controls
- Tune DAX and model performance
- Implement incremental refresh where appropriate
- Maintain alignment with SOX-related controls and documentation standards
- Follow Dev/Test/Prod deployment processes
- Contribute to BI standards and best practices
- Translate business requirements into scalable BI solutions
- Partner with Finance, Operations, Retail, and other stakeholders
- Support KPI clarification and validation
- Improve report usability and adoption
Requirements
- 5+ years experience in Power BI development
- Advanced DAX (CALCULATE, context transition, time intelligence, optimization)
- Strong understanding of star schema and dimensional modeling
- Experience building and managing semantic models
- Experience implementing Row-Level Security (RLS)
- Strong SQL skills
- Experience with Power BI CI/CD, including deployment pipelines, version control, and Dev/Test/Prod promotion.
- Experience working in Azure or Microsoft Fabric environment
- Understanding of medallion architecture (Bronze/Silver/Gold)
- Ability to work within governed data models
- Familiarity with SCD concepts and fact grain principles
- Awareness of data governance and compliance considerations.
Benefits
- Competitive compensation including performance-based bonuses and annual salary reviews.
- Comprehensive health and dental benefits, including a Healthcare Spending Account.
- Three weeks of paid vacation with annual rollover.
- Flexible, hybrid work arrangements to support work-life balance.
- Recognition and rewards programs that celebrate individual and team achievements.
- Employee & Family Assistance Program (EFAP) with mental health, financial, and family support.
- Employee perks and discounts program, offering savings across fitness, wellness, lifestyle, retail, and everyday services.
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
DAXSQLPower BIsemantic modelsstar schemaRow-Level Securityincremental refreshdata governancedimensional modelingmedallion architecture
Soft Skills
collaborationcommunicationproblem-solvingattention to detailadaptabilitystakeholder engagementanalytical thinkingusability improvementKPI validationrequirements translation