Senior Analyst, Inventory & Controls

Dollarama; Mount Royal; On-site; CAD 90,000 - 120,000; Full time

Job summary

Dollarama is seeking a finance/inventory analyst to build analytical models and an inventory database, supporting decision making and KPIs such as turnover, margins, and aging. You will analyze shrinkage, prepare monthly/quarterly financial analyses, and develop Power BI dashboards to reveal inventory performance by SKU, store, and region.

You will validate data during system changes, work with cross-functional teams, and help optimize inventory controls and forecasting.

Qualifications

• Bachelor’s degree in finance, accounting, or related field.
• 5+ years in a similar financial 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) and Power BI or similar visualization tools.
• Strong ability to manage and interpret large, complex datasets.

Responsibilities

• Develop optimized analysis models to support decision-making and inventory tracking.
• Perform in-depth analysis of inventory shrinkage across store type, region, departments, and product categories.
• Prepare monthly and quarterly financial analyses and presentations.
• Provide insight into inventory forecast factors (levels, margins, cost drivers).
• Develop and maintain Power BI dashboards for inventory metrics at SKU/store/region levels.
• Support system implementations by validating inventory data and reporting outputs.
• Lead transition and optimization of inventory reporting into Power BI with testing and documentation.
• Collaborate with Replenishment, Accounting, FP&A, and Operations to align initiatives.

Skills

Advanced analytics

Strong communication

Attention to detail

Problem solving

Education

Bachelor’s degree in finance or accounting

Tools

SAP

Excel

Power BI

Job description

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:
• 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

Professional Attributes

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