Merchandising Analyst

**Merchandising Analyst**

**ABOUT AGLC**
Alberta Gaming, Liquor & Cannabis (AGLC) is a dynamic organization leading Alberta’s gaming, liquor and cannabis industries. Our team of high performers is driven to provide our customers with outstanding service and Albertans with choices they can trust.

**ABOUT CANNABIS**
The Cannabis branch collaborates with many internal and external stakeholders and suppliers to ensure a balance between consumer demand, social responsibility, product selection and economic benefit for the province. They also oversee the operations of retailer relations and the commercial cannabis strategy.

**ABOUT THE POSITION**

**Merchandising Analyst**
**Job Req**:2003
**Location**:St. Albert Office
**Division/Branch**:Liquor & Cannabis / Cannabis
**Classification**:Research Officer 3 (247)
**Status**:Union
**Employment Status**:Permanent Full Time
**Salary**:$75,653.46 - $99,125.19
**Closing Date: July 25, 2023**

**JOB SUMMARY**
The Merchandising Analyst will partner with the Merchandise Planning, Category Management Specialists, and Cannabis Operations teams to develop, review/ report monthly onCannabis business KPI’s, develop inventory purchase, sales and revenue forecasts and insights to assist the Cannabis team in making data driven decisions. The Merchandising Analyst will assess reporting needs and use AGLC’s datasets to create and maintain Cannabis business’ reporting tools including PowerBI Dashboards. As well the job will entail managing some operational tasks. The Merchandising Analyst will use their strong attention to detail to evaluate process and look for areas of improvement to better support a cohesive execution to further serve our stakeholders.

This position is focused on effective use of monetary resources to achieve optimal merchandise turns. It requires hypothesis-driven, data analysis and critical thinking to come up with actionable strategies. It also requires awareness of external and internal inputs and how they impact inventory management as it relates to our external stakeholders. This position will require bringing forward recommendations that will increase efficiencies for all stakeholders and to drive results within the department and other functional groups. Also, the position is responsible for working cross-functionally to develop initial departmental operational and revenue budgets and performing any reforecasts and variance analysis. The incumbent will recommend and provide guidance to cross-functional teams on product calls, price changes and volume forecasts.

**SKILLS & ABILITIES**
- Bachelor’s Degree in business administration, finance, applied statistics or a related discipline with an emphasis on economics, data analysis and scenario modelling or equivalent experience.
- 4+ years of experience in data science, data analytics, data management, reporting and dashboarding preferred.
- 3+ plus years in Cannabis industry or related industry.
- Strong knowledge and experience working with Power BI is required.
- Advanced Excel skills, Intermediate level skills in Outlook, Word, and PowerPoint.
- SQL Knowledge and experience (Training and Certification preferred).
- Excellent understanding of budgeting, business planning and business case modelling.
- Economic modelling and analysis techniques.
- Excellence in interpretation of market research data and results for analytical purposes.
- Sound organizational, analytical, judgement and decision-making skills.
- Proven ability to work cross-functionally with diverse teams, communicate effectively and handle multiple deliverables.
- Ability to work within a fast-paced environment with changing priorities.
- Experience in business process development and optimization.

**NOTE**:

- To be eligible to work for AGLC, you must be a Canadian citizen, permanent resident or eligible to work in Canada.
- As a condition of employment, you will be required to obtain a satisfactory security clearance and clean drivers abstract (if necessary) prior to employment.
- AGLC is committed to creating a diverse environment and is proud to be an equal opportunity employer.