Senior Analyst, Inventory & Controls

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 fast-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.