Inventory Analyst
TalentSphere
- Niagara Falls, ON
- Permanent
- Full-time
(Relocation Expense!)
Industry /Business: Consumer Goods, E-CommerceAbout the Job:
Reporting to the Logistics Manager at our Niagara Falls location, the successful candidate will be responsible for managing inventory levels, analyzing trends, and developing plans to optimize stock and minimize waste. Additionally, they will be responsible for providing accurate and timely financial analysis to support decision making for the company.Responsibilities:
- Utilize historical data, market trends, and sales projections to forecast inventory levels accurately
- Monitor inventory turnover rates and adjust forecasts accordingly to optimize inventory levels
- Process vendor invoices in a timely manner and ensure payments are made according to terms and agreements
- Compile data from multiple sources and utilize advanced Excel functions to analyze inventory data, generate reports, and identify trends or anomalies
- Ensure accurate and up-to-date data entry in the ERP system to facilitate efficient inventory tracking and reporting
- Collaborate with the Warehouse team to coordinate flow of goods
- Develop and maintain positive relationships with vendors to facilitate smooth communication and transactions
- Resolve discrepancies between physical and inventory and records and investigate and resolve issues with damaged or missing inventory
- Recommend changes to current inventory policies and procedures
- Conduct analysis of product viability to identify trends, recommend solutions, and support decision-making
- Develop and present financial plans, forecasts, and reports to senior management using Excel spreadsheets
- Analyze gross margins by division, category, and item and compare to what has been forecasted
- Conduct research and monitor real time trends on economic indicators such as fluctuation on foreign exchange rates and market trends
- Identify opportunities to reduce costs by recommending process improvements
- Prepare and present insightful reports on inventory performance, margin analysis, and other key metrics to support decision-making
- Undertake related duties as assigned to achieve the company objectives and goals
- College diploma or university degree in Business Administration, Accounting, Economics, or a related field
- Three (3) years of inventory management and forecasting experience
- Two (2) years of financial analysis experience
- Experience extracting data from an ERP system
- Experience working with freight forwarders considered (asset)
- Proficiency using Microsoft Office
- Advanced Microsoft Excel knowledge (VLOOPUPS, Pivot Tables, IF Statements, Macros)
- Experience managing a large volume of data in Excel
- Analytical and highly motivated self-starter
- Detail oriented problem solver
- Strong communication and interpersonal skills
- Ability to work in a fast-paced ever-changing environment
- Experience using NetSuite (asset)
- Experience using Power BI (asset)