Business Intelligence Specialist

Alcool NB Liquor; Fredericton; Remote; CAD 75,000 - 85,000; Full time

Job summary

A provincial Crown corporation in New Brunswick is seeking a Business Intelligence Specialist to support a multi-year business transformation project. The role involves implementing a modern analytics platform and ensuring scalable data solutions. Candidates should have expertise in data analysis and Microsoft technologies, including Power BI and Azure. Competitive salary and benefits are offered, with remote work options available.

Benefits

Comprehensive benefits package

Flexible work arrangements

Leadership Development Program

Qualifications

• Minimum three years of experience in data analysis, engineering, and insights development.
• Proficiency in Power BI for data visualization and report development.
• Hands-on experience with the Microsoft Power Platform.

Responsibilities

• Collaborate with teams to enhance operational effectiveness using data.
• Implement BI solutions for reporting and strategic insights.
• Develop BI deliverables including pipelines and data models.

Skills

Data analysis

Power BI

Data modeling

Analytical thinking

Education

Degree or diploma in Business Administration or Computer Science

Tools

Microsoft Fabric

Azure Synapse

SQL Server

Job description

Overview

Business Intelligence Specialist

Term ending in October 2026

Alcool NB Liquor

Essential role information

Title : Business Intelligence Specialist

Language requirement : Spoken and written competence in English

Location : Reporting to the Project Galileo office in Fredericton NB – remote work within New Brunswick is possible

Duration : term ending in October 2026

Closing : Who we are

As one of Atlantic Canada’s Top Employers for 2025 ANBL is proud of the people-first culture we’ve built together with our team members and the passion our team brings to work every day.

Alcool NB Liquor (ANBL) is a provincial Crown corporation responsible for the purchase, importation, distribution, and retail activity for all beverage alcohol in the province. We are passionate about our purpose of giving back to New Brunswickers by responsibly enhancing occasions, providing a superior service experience to our customers, spending time in our communities, and fostering strong relationships with our industry and vendor partners.

Cannabis NB (CNB), our sister company, also a provincial Crown corporation, manages retail cannabis sales for the province, providing a range of safe, legal products. The core focus of our retail model is ensuring the thriving cannabis industry developing in New Brunswick is safe and responsible. At CNB, our goal is to deliver a world class customer experience built on good information, a safe high-quality product offering and a highly trained and engaged team. Our mandate is public education and protection, and everyone at Cannabis NB is committed to it.

Every year, we return 100% of profits to the Government of New Brunswick to benefit of all New Brunswickers. As a provincial Crown corporation, we serve the public and licensee community through a network of corporate retail stores and private retail operators. Our mandate is to responsibly manage a successful business for the people of New Brunswick and to deliver the best value for your investment in us.

Corporate Social Responsibility at ANBL

At ANBL, we take our social responsibility seriously. With our Corporate Social Responsibility Strategy to guide us, we are committed to :

• Responsible selling through our CHECK 30 program, which specifies that customers who look younger than 30 will be asked for valid photo identification.
• Food security through our partnership with Food Depot Alimentaire to help get more food to the New Brunswickers who need it.
• Helping New Brunswickers get home safely through our Safe Ride program, providing FREE transportation at ANBL-sponsored events.

None of these efforts would be possible without the more than 800 team members who are the lifeblood of our organization and choose ANBL as their employer.

What’s in it for you?

Being part of the ANBL team means being part of an organization that values its employees, where everyone has a voice and uses it in the best interest of the organization and our people. We are all proud of what we contribute to the betterment of our province, and we take that responsibility seriously.

In addition to offering a market competitive salary, we ensure that our employees can enjoy work-life balance by offering a comprehensive benefits package, including medical, dental and a generous pension plan. Employees also have access to a Health Spending Account or Wellness Subsidy, and opportunities to utilize flexible work arrangements, such as remote or hybrid work.

At ANBL we value the growth of our employees both personal and professional. We offer various types of external and internal development activities, including a robust internal Leadership Development Program.

About the Business Intelligence Specialist

Alcool NB Liquor is currently undergoing an exciting multi-year business transformation project, including the implementation of Microsoft Dynamics 365, a new ecommerce platform and the Microsoft Fabric data platform, which provides end-to-end analytic capabilities.

We are seeking a Business Intelligence Specialist to join our team. The role involves supporting the implementation of a modern analytics platform and ensuring scalable data solutions that meet organizational needs. Expertise in ingesting, processing, and transforming data using Microsoft technologies, including Fabric and Power Platform tools, is required. The successful candidate will collaborate with various departments to create and test data workflows, dashboards and reports.

Reporting to the Business Intelligence Functional Lead, this role will integrate existing BI activities into modern analytics solutions, including migrating reports and datasets to Microsoft Fabric and aligning them with the new system architecture. As a process expert, you will work across teams to enhance our BI capabilities, ensuring alignment with best practices and evolving business needs.

Responsibilities

• Collaborate with internal teams to understand business challenges and opportunities for using data to enhance operational effectiveness and support informed decision-making.
• Implement BI solutions that support reporting and strategic insights, ensuring they are performant, user-friendly, and meet business requirements.
• Participate in workshops to gather and define data and reporting requirements.
• Develop BI deliverables including pipelines, data models, and reports using Microsoft Fabric components such as Dataflows, Lakehouses, and PowerBI.
• Support testing activities, including SIT and UAT, to validate data mapping, transformation logic, and report accuracy between source and target systems.
• Apply and promote best practices that balance business needs with industry-leading approaches.
• Follow established data governance practices and standards to ensure consistency and compliance.
• Create and maintain documentation for data models, pipelines, and reporting logic for knowledge sharing and supportability.

Qualifications

• What you need to be successful:
• Degree or diploma in Business Administration, Computer Science, or similar. While a formal degree or diploma is preferred, we value practical experience and are open to considering candidates with equivalent experience in lieu of educational qualifications.
• A minimum of three (3) years of progressive experience in data analysis, engineering, modeling, and insights development.
• Proficiency in Power BI for data visualization and report development.
• Experienced in building scalable data warehouses, data modeling, and using cloud platform tools such as Microsoft Fabric, Azure Synapse, Data Factory.
• Analytical thinking and problem-solving abilities to translate complex data into actionable insights, with strong technical skills and high attention to detail.
• Understanding of Performance Measurement Frameworks (PMFs) including metrics, dimensions, benchmarks, and KPIs.
• Strong knowledge of database platforms and storage solutions such as SQL Server and Azure Data Lake Storage.
• Hands-on experience with the Microsoft Power Platform (Power BI, Power Apps, Power Automate).
• Proficient in scripting and debugging using T-SQL, PySpark, M, and DAX.
• Exceptional communication skills with the ability to build strong professional relationships in functional and technical areas.
• Confidentiality and discretion required.
• Assets (nice-to-have):
• Experience in Retail, CPG, FMCG or beverage alcohol industries.
• Experience with Microsoft Dynamics 365 or another ERP.
• Knowledge of data governance and metadata management.
• Microsoft certifications related to analytics (PL-300, DP-600, DP-700).
• Project Management skills.

Key Competencies

• Manages Complexity : Makes sense of complex, high quantity, and sometimes contradictory information to effectively solve problems. For example, asks questions to encourage others to think differently and enrich their analyses of complex situations. Accurately defines the key elements of complex, ambiguous situations.
• Optimizes Work Processes : Knows the most effective and efficient processes to get things done, with a focus on continuous improvement. For example, encourages and rewards continuous improvement and quality outcomes. Equips others to handle day-to-day tasks effectively on their own. Integrates systems to improve quality and service.
• Cultivates Innovation : Creates new and better ways for the organization to be successful. For example, offers creative ideas, finds unique connections between previously unrelated elements. Actively encourages and supports others\' creativity; builds upon and strengthens new solutions in a positive and collaborative manner.
• Communicates Effectively : Develops and delivers multi-mode communications that convey a clear understanding of the unique needs of different audiences. For example, tailors communication content and style to the needs of others. Pays attention to others\' input and perspectives, asks questions, and summarizes to confirm understanding

Language competencies

• Bilingualismin both official languagesis an asset, but not required

Work location

• The Project Galileo Office is located in Fredericton, New Brunswick.
• The successful candidate must be based in New Brunswick, remote work is possible.
• Semi-regular travel for meetings and project work may be required.

Note

• Only candidates with legal authorization to work in Canada will be considered
• Accommodation may be provided to candidates upon request, in all aspects of the selection process.