Inventory Analyst

Ontario Medical Supply; Mississauga; On-site; CAD 60,000 - 85,000; Full time

Job summary

Ontario Medical Supply is seeking an Inventory Analyst to drive data-driven decision making across inventory and planning operations. You will transform raw data into actionable insights, build dashboards, and support ERP data integrity to improve service levels and cost performance.

The role requires strong Excel skills and experience with Power BI/Tableau, plus familiarity with ERP systems and SQL/Python for data manipulation.

Qualifications

• Bachelor’s degree in Supply Chain, Operations, Business Analytics or related field.
• APICS/ASCM CPIM or CSCP certification.
• 2–4 years of experience in supply chain analysis, inventory planning, or operations analytics.

Responsibilities

• Analyze inventory, purchasing, demand forecasts, and supply chain KPIs.
• Identify patterns, risks, and opportunities to improve efficiency, service levels, and costs.
• Develop simulation and what-if analyses for planning scenarios.
• Design, automate, and maintain dashboards (Power BI, Tableau) for inventory performance and metrics.
• Prepare weekly and monthly leadership reporting packs highlighting variances and root causes.
• Support demand and replenishment planning with data-backed inputs.
• Collaborate with purchasing and warehouse to align stock with demand trends.

Skills

Communication

Organization

Negotiation

Data skills

Attention to detail

Initiative

Fast-paced

Education

Bachelor’s degree in Supply Chain, Operations, Business Analytics

APICS CPIM

CSCP

Tools

Power BI

Tableau

Excel

SQL

Python

ERP systems

Job description

Ontario Medical Supply is a Leading Distributor of medical equipment, supplies, and services for healthcare organizations and home healthcare clients across Ontario. Specializing in long term care, assisted living, retirement and home health care. Ontario Medical Supply is partnered for success with Royal Drugs. Royal Drugs is a healthcare company providing specialty pharmacy, infusion therapy, and retail pharmacy services. Together, we work towards supporting optimal health outcomes and better quality of life.

Purpose:

In this role the Inventory Analyst will be the analytical foundation for our inventory and planning operations. Your work will significantly influence strategic and operational decisions by transforming raw data into insights, actionable dashboards, and supply chain strategies. You will help improve service levels, optimize inventory management, and enhance ERP data integrity.

Position: Inventory Analyst

No. of Positions: 1

ATR: #5188

Type: Full Time, Permanent

This job posting is for an existing vacancy

Job Responsibilities:

Data Analytics & Insights

• Perform in-depth analysis on inventory, purchasing, demand forecasts, and supply chain KPIs.
• Identify patterns, risks, and opportunities to improve efficiency, service levels, and cost performance.
• Develop simulation and what-if analysis for key planning scenarios.
• Design, automate, and maintain dashboards (using tools such as Power BI, Tableau, or similar) for inventory performance, order fulfillment, supplier reliability, and system optimization metrics.
• Prepare weekly and monthly reporting packs for leadership, identifying key variances and root causes.

Planning Support

• Support demand and replenishment planning by providing accurate, data-backed inputs.
• Collaborate with purchasing and warehouse teams to align stock levels with demand trends and customer requirements.
• Assist in safety stock analysis, min/max planning, and ABC categorization.

ERP & Master Data Integrity

• Assist in ensuring the ERP system reflects accurate lead times, order quantities, and item attributes.
• Partner with the Inventory and Purchasing Manager to enhance master data quality and maintain accurate planning parameters.

Cross-Functional Collaboration

• Work closely with warehouse, sales, finance, and customer service teams to align operations and mitigate supply chain risks.
• Support ad hoc analysis requests from business stakeholders

Qualifications:

• Bachelor’s degree in Supply Chain, Operations, Business Analytics, or related field.
• APICS/ASCM or other supply chain certification (CPIM, CSCP).
• 2–4 years of experience in supply chain analysis, inventory planning, or operations analytics.
• Strong Excel skills (pivot tables, lookups, advanced formulas); experience with data visualization tools (e.g., Power BI, Tableau).
• Experience working with ERP systems (preferably in the distribution or medical products sector).
• Experience with SQL, Python, or other data tools.Familiarity with demand planning, S&OP, or inventory optimization methodologies.

Skills:

• Candidates must demonstrate strong communications skills (both verbally and written), organization, ability to --negotiate, good mathematical skills, sound judgment and initiative
• Strong attention to detail, curiosity, and ability to turn data into decisions.
• Must be a highly-motivated, self-driven person who can learn quickly and be comfortable in a fast-paced environment
• Proficient in Microsoft Office Tools (excel, pivot tables, Power BI etc.) Use of SAP, WMS, Pronto etc.

Human Resources:

While we thank you for your interest, only select applicants will be contacted regarding the position.

Ontario Medical Supply is an inclusive and equal opportunity employer committed to providing diversity and accommodations for applicants upon request at any stage of the recruitment process in accordance with the Accessibility for Ontarians with Disabilities Act (AODA) and the Ontario Human Rights Code. All applicants must make their requirements known when contacted.

The company reserves the right to close the competition based on business need and a sufficient pool of candidates who have applied.

AI will be used in the recruitment process.