Senior Analyst, Inventory & Controls

Dollarama•Mont-Royal, QC

About The Position

The role involves developing analytical models and an inventory database to effectively support decision-making and monitor key performance indicators such as inventory turnover, margins, inventory in transit, and aging, while conducting in-depth analyses of inventory shrinkage to identify trends, root causes, and opportunities for improvement.

Requirements

Bachelor’s degree in finance, Accounting, or related field.
5+ years of experience in a similar role or financial/accounting analysis role with exposure to inventory, forecasting, and margin/cost analysis.
Experience working with a large ERP system (SAP strongly preferred).
Advanced analytical capabilities, including: Excel (Advanced), Power BI or similar visualization tools, Strong ability to manage and interpret large, complex datasets
Strong attention to detail with a high degree of accuracy
Proactive mindset with the ability to identify issues and drive solutions independently.
Ability to work effectively in a fast-paced, dynamic environment with competing priorities.
Strong communication skills (written/verbal).

Nice To Haves

Highly analytical, with proven experience working with high-volume data and translating it into business insights.
Strong attention to detail paired with an ability to understand the broader financial and operational impacts.
Experience in forecasting, modeling, and variance analysis.
Collaborative team player with strong communication and stakeholder engagement skills.
Proactive, curious, and continuously looking to improve processes and add value.
Preparation for implementation of new DC in Calgary on a new warehousing system.
Transition of many key inventory reports from BW to Power BI.
Optimization of shrink analysis process and posting to deliver quicker financial results and optimize visibility on financial results in our system.
Support with knowledge sharing with TRS for best practices.

Responsibilities

Develop optimized analysis models to support decision-making, including building and maintaining the inventory database to track key performance measures (inventory turnover, margin, inventory in transit, age of inventories, etc.).
Perform in depth analysis of inventory shrinkage across many dimensions (store type, region, departments, product categories, etc.) to highlight trends, root causes and opportunities to improve shrinkage.
Prepare financial analysis and reporting for monthly and quarterly financial and presentations.
Provide insight and analysis on key factors impacting the inventory forecast (inventory levels, margins, key cost drivers, etc.).
Develop, maintain, and enhance Power BI dashboards to provide visibility into inventory performance metrics (aging, turns, margins, shrink) at various levels (SKU, store, region).
Support system implementations, enhancements, and testing (e.g., new distribution centers, process changes) by validating inventory data and reporting outputs.
Led the transition and optimization of inventory reporting into Power BI, including testing, validation, and documentation.
Partner cross-functionally with Replenishment, Accounting, FP&A, and Operations to ensure alignment and successful execution of inventory-related initiatives and process improvements.
Ensure strong internal controls over inventory, including monitoring accuracy, completeness, and integrity of inventory records (Compliance with 52-109).
Support internal and external audit processes by preparing timely and accurate documentation and reconciliations.
Collaborate with FP&A and project teams to evaluate shrink reduction initiatives, including the financial impact, coordination of counts with stores to support the payback analysis.
Prepare and analyze estimated store inventory level to support operational planning, including labor budgeting for inventory counts.
Validate third-party inventory count results and ensure accurate receipt and transmission of master data files.