Senior Business Intelligence Developer
Top Benefits
About the role
Work Location
Edmonton Corporate Office
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 - $100,000 - $110,000
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 Canada’s leading and fastest-growing liquor and cannabis companies. As the country’s 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.
We’re also one of Canada’s 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
Not the right fit? Search for Business Intelligence Developer jobs in Ottawa, ON
About SNDL Inc.
SNDL is a public company whose shares are traded on Nasdaq under the symbol "SNDL."
SNDL is the largest private-sector liquor and cannabis retailer in Canada with retail banners that include Ace Liquor, Wine and Beyond, Liquor Depot, Value Buds, Spiritleaf, Superette and Firesale Cannabis.
SNDL is a licensed cannabis producer and one of the largest vertically integrated cannabis companies in Canada specializing in low-cost biomass sourcing, premium indoor cultivation, product innovation, low-cost manufacturing facilities, and a cannabis brand portfolio that includes Top Leaf, Contraband, Citizen Stash, Sundial Cannabis, Palmetto, Bon Jak, Spiritleaf Selects, Versus Cannabis, Value Buds, Vacay and Grasslands.
Please reach out to our investor relations department at investors@sndl.com with any investor-related questions.
Similar jobs you might like
Senior Business Intelligence Developer
Top Benefits
About the role
Work Location
Edmonton Corporate Office
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 - $100,000 - $110,000
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 Canada’s leading and fastest-growing liquor and cannabis companies. As the country’s 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.
We’re also one of Canada’s 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
Not the right fit? Search for Business Intelligence Developer jobs in Ottawa, ON
About SNDL Inc.
SNDL is a public company whose shares are traded on Nasdaq under the symbol "SNDL."
SNDL is the largest private-sector liquor and cannabis retailer in Canada with retail banners that include Ace Liquor, Wine and Beyond, Liquor Depot, Value Buds, Spiritleaf, Superette and Firesale Cannabis.
SNDL is a licensed cannabis producer and one of the largest vertically integrated cannabis companies in Canada specializing in low-cost biomass sourcing, premium indoor cultivation, product innovation, low-cost manufacturing facilities, and a cannabis brand portfolio that includes Top Leaf, Contraband, Citizen Stash, Sundial Cannabis, Palmetto, Bon Jak, Spiritleaf Selects, Versus Cannabis, Value Buds, Vacay and Grasslands.
Please reach out to our investor relations department at investors@sndl.com with any investor-related questions.