21 Oct
|
Dollarama
|
Mt Royal
21 Oct
Dollarama
Mt Royal
Job Summary 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. Key Accountabilities
• 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. Job 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: o Excel (Advanced) o Power BI or similar visualization tools o 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 quick-paced, dynamic environment with competing priorities.
• Strong communication skills (written/verbal). Key Profile types :
• 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. On going key initiative in inventory:
• 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. We thank all interested applicants. Only those selected for an interview will be contacted by our recruitment team.
📌 Senior Analyst, Inventory (Mt Royal)
🏢 Dollarama
📍 Mt Royal