Sr. Analyst, Business Intelligence

The opportunity

Business intelligence solutions

• Translate business questions and performance needs into reporting, analytics, and visualization requirements.
• Build timely, consistent dashboards and reports and clarify metrics, definitions, business rules, and expected outputs with stakeholders.
• Simplify recurring reporting, reduce manual analysis, and improve access to trusted information.

Data modeling and development

• Design, develop, and maintain reusable, scalable Power BI semantic models using dimensional modeling, including star schemas, fact and dimension tables, relationships, hierarchies, and appropriate granularity.
• Build and optimize DAX measures and Power Query transformations for accurate calculations, efficient models, and consistent reporting.
• Configure refresh strategies, model relationships, and row-level security.

Integration, quality, and governance

• Develop and support ETL and ingestion from Excel/CSV files, SharePoint, APIs, and other internal and external sources.
• Reconcile source data to reports and perform quality checks to identify gaps, inconsistencies, and unexpected changes before publication.
• Maintain source mappings, transformation logic, data lineage, and schema-change controls; investigate issues and coordinate corrective action with business and technical partners.

Documentation and analytics enablement

• Document business rules, measure definitions, source mappings, transformations, lineage, and solution requirements.
• Manage BI solutions across development, test, and production using version control and Power BI or Microsoft Fabric deployment pipelines.
• Partner with stakeholders from requirements through testing, deployment, and production support; support process automation and analytics platform development, including relevant Microsoft tools.

What you bring

• Bachelor’s degree in computer science, business intelligence, analytics, or a related field.
• At least 5 years of relevant BI, analytics, or comparable experience, including hands-on Power BI development and multi-source data integration.
• Advanced Power BI Desktop and Power BI Service expertise; strong semantic and dimensional modeling knowledge.
• Proficiency in SQL, DAX, and Power Query.
• Experience with ETL, row-level security, model and report optimization, data governance and lineage, version control, and deployment pipelines.
• Strong analytical, organizational, documentation, and stakeholder communication skills.

Assets

• A relevant data, analytics, or Microsoft certification, such as Microsoft Power BI PL-300, is an asset.
• Experience with Microsoft Fabric, Power Apps, Power Automate, or cannabis-industry commercial data is an asset.

Benefits

• The employer offers company-paid comprehensive benefits and education assistance.