Senior Business Intelligence Developer

Work Location

About the Role

We are seeking a Senior BI Developer to play a key role in the modernization of our enterprise data platform built on Microsoft Fabric and Power BI. This role is responsible for engineering scalable high-performance Power BI solutions built on governed semantic models and standardized enterprise KPIs.

This is not a dashboarding role. It requires deep expertise in semantic model design advanced DAX optimization dimensional modeling and performance tuning.

The successful candidate will operate within a medallion architecture (Bronze/Silver/Gold) and collaborate closely with Data Engineering and Analytics Engineering to ensure alignment across ingestion transformation modeling and reporting layers.

Key Responsibilities

Power BI Development & Delivery

• 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

Semantic Model & Data Modelling Collaboration

• 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

Performance & Governance

• 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

Business Engagement

• 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

Required Qualification

Technical Skills

• 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

Modelling and Architecture Awareness

• 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

Soft Skills

• Strong communication skills
• Structured problem-solving approach
• Ability to balance speed and scalability
• Comfortable working in evolving platform environment

Targeted Compensation - $100000 - $110000

What Makes SNDL a Great Place to Grow:

• 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

We are grateful for the interest in this role from all candidates however we will be contacting only those that are selected for next steps in the hiring process.

Our Commitment to Diversity & Inclusion

SNDL is an equal opportunity employer. We are committed to building a welcoming inclusive diverse and safe workplace where all of our team members have equal opportunity to succeed. We know this begins with recruitment. To honor our commitment SNDL encourages applications from individuals of all backgrounds sexual orientation gender identity ancestry ages and abilities.

About SNDL

SNDL is one of Canadas leading and fastest-growing liquor and cannabis companies. As the countrys largest private-sector retailer our portfolio includes well-known banners such as Wine and Beyond Liquor Depot Ace Liquor Value Buds Spiritleaf and Cost Cannabis.

Were also one of Canadas largest vertically integrated cannabis producers recognized for our innovation low-cost manufacturing and award-winning brands including Top Leaf Contraband Palmetto Bon Jak La Plogue Versus Grasslands Vacay Pearls by Grön No Future and Bhang Chocolate.

Driven by purpose performance and people SNDL is shaping the future of retail and cannabis by bringing people together through exceptional products and experiences.

Learn more about SNDL