Inventory Analyst

About Us

Aquiform is the largest Canadian wholesale distributor to the pool and spa industry. We take pride in promoting and growing new and exciting pool and spa products and delivering them on time to an extensive customer base, supported by an experienced sales team with deep industry roots.

Job Summary

Aquiform is looking for an analytical and detail-oriented Inventory Analyst to help us make better Aquiform is looking for an analytical and detail-oriented Inventory Analyst to analyze inventory and sales data, identify stockouts and excess inventory, and provide actionable recommendations to support purchasing decisions.

The ideal candidate has strong Excel skills, enjoys working with data, and can turn information into practical business insights. This is an inventory analysis role, not a production scheduling or logistics position.

This is a full-time, on-site position, five days per week.

Key Responsibilities

Inventory Analysis and Optimization

• Analyze inventory levels, sales history, stockouts, excess inventory, and slow-moving products.
• Identify inventory risks and opportunities, including products that are likely to run out or accumulate excess stock.
• Investigate the causes of inventory issues and recommend practical solutions.
• Identify opportunities to reduce aged inventory and improve inventory turnover.
• Monitor inventory performance across product categories and highlight areas requiring attention.

Sales Analysis and Replenishment

• Analyze historical sales, seasonality, demand changes, and product trends.
• Use inventory on hand, open purchase orders, supplier lead times, and sales data to develop suggested reorder quantities.
• Identify products requiring increased or decreased inventory investment.
• Support replenishment planning by providing data-driven recommendations to the Purchasing team.
• Help evaluate the impact of purchasing decisions on inventory availability and excess stock.

Reporting and Data Analysis

• Develop, maintain, and improve Excel-based reports, dashboards, and inventory analysis tools.
• Analyze large data sets to identify trends, exceptions, discrepancies, and opportunities for improvement.
• Automate recurring reports and improve the accuracy and efficiency of reporting processes.
• Establish and monitor key inventory performance measures.
• Translate complex data into clear findings and actionable recommendations for Purchasing and Management.

Purchasing and Cross-Department Support

• Provide the Purchasing team with accurate inventory analysis and replenishment recommendations.
• Highlight products requiring purchasing attention based on inventory performance and demand trends.
• Investigate discrepancies in inventory, sales, and purchasing data.
• Collaborate with Purchasing, Sales, Warehouse, and Management to resolve inventory-related issues.
• Participate in inventory analysis projects and continuous improvement initiatives.

Qualifications

• 2–5 years of experience in inventory analysis, inventory management, business analysis, purchasing analysis, or a related analytical role.
• Strong Excel skills, including PivotTables, lookup functions, formulas, data manipulation, and analysis of large data sets.
• Demonstrated ability to analyze data, identify trends, investigate discrepancies, and develop practical recommendations.
• Experience working with sales, inventory, or purchasing data.
• Experience using ERP, inventory management, or business reporting systems.
• Strong analytical thinking, problem-solving, and attention to detail.
• Ability to organize information, prioritize issues, and work independently.
• Strong communication skills, including the ability to explain findings and recommendations to non-technical colleagues.

Post-secondary education in Business, Analytics, Finance, Supply Chain, or a related field is preferred.

Experience with Power Query, Power BI, or reporting automation would be an asset.

What We Offer

• Competitive salary starting at $65,000 annually.
• Comprehensive benefits.
• Professional development and career growth opportunities.
• A collaborative, team-oriented environment.
• The opportunity to use data and analysis to make a meaningful impact on inventory performance and business decisions.

The Ideal Candidate

The ideal candidate is curious, analytical, proactive, and comfortable working with data. They enjoy digging into the numbers, asking questions, and finding ways to improve business performance.

They don't simply report inventory levels. They investigate the reasons behind them and identify what should happen next.

They are the type of person who can look at an inventory or sales report and answer:

• What is happening?
• Why is it happening?
• Which products need attention?
• What should we do differently?

This person will help Aquiform improve inventory availability, reduce excess stock, and make better-informed purchasing decisions.

This is a new position.

Aquiform is committed to promoting accessible recruitment as outlined in the Accessibility for Ontarians with Disabilities Act. Accommodations will be provided upon request throughout all stages of the recruitment process.