Inventory Specialist

Rubicon is seeking a highly analytical, detail-oriented, and proactive Inventory Specialist to support inventory control, reconciliation, reporting, and data integrity activities across company-operated facilities and multiple third-party logistics (3PL) locations. The Inventory Specialist plays a critical role in maintaining accurate inventory records for Biomass, Packaging Materials, Work-in-Process (WIP), and Finished Goods (CPG) through inventory reconciliations, variance analysis, transaction reviews, reporting, and inventory control activities.

Working closely with Logistics, Finance, Supply Chain, Warehouse, Production teams, and 3PL partners, the Inventory Specialist is responsible for ensuring inventory records within Microsoft Dynamics 365 (D365) accurately reflect physical inventory and operational activity. This role owns the day-to-day execution of inventory reconciliation processes, inventory reporting, variance investigations, inventory transaction accuracy, and inventory data management while supporting audit readiness, inventory governance, and continuous improvement initiatives across the supply chain network.

The successful candidate will leverage advanced Microsoft Excel and D365 reporting capabilities to analyze inventory data, identify trends, monitor inventory performance, and provide actionable insights that improve inventory accuracy, visibility, and operational effectiveness.

This role will be based at our Delta facility, reporting to the Warehouse Manager.

• Perform weekly, monthly, quarterly, and annual inventory reconciliations across company-operated and 3PL locations.
• Reconcile inventory balances for Biomass, Packaging Materials, Work-in-Process (WIP), and Finished Goods (CPG).
• Validate inventory transactions and ensure inventory records accurately reflect physical inventory and operational activities.
• Investigate inventory variances, identify root causes, and coordinate corrective actions with stakeholders.
• Review inventory movements, transfers, receipts, adjustments, and consumption transactions for accuracy and completeness.
• Maintain inventory reconciliation documentation and support audit-ready inventory records.
• Support month-end, quarter-end, and year-end inventory close activities in partnership with Finance.
• Escalate significant discrepancies and inventory control concerns to leadership.
• Inventory Validation & Analysis
• Review and validate inventory count results completed by Inventory Coordinators and 3PL partners.
• Participate in cycle counts, spot audits, recounts, and inventory validation activities.
• Analyze physical versus system inventory variances and support timely resolution.
• Monitor inventory adjustment activity and track variance trends.
• Document findings, root causes, and corrective actions.
• Support initiatives designed to improve inventory accuracy and control.

• Coordinate inventory reconciliation activities with third-party logistics providers.
• Review and validate inventory reports received from 3PL facilities.
• Investigate discrepancies between D365 records and 3PL inventory balances.
• Work with warehouse partners to resolve inventory issues and obtain supporting documentation.
• Monitor inventory aging, excess inventory, and slow-moving inventory at external locations.
• Maintain inventory visibility and reporting across all warehouses and 3PL locations.

• Maintain inventory transaction accuracy and integrity within Microsoft Dynamics 365.
• Review and correct inventory transaction errors and system discrepancies.
• Support inventory master data maintenance and warehouse location accuracy.
• Ensure compliance with inventory controls, policies, and approval processes.
• Support inventory-related system testing, enhancements, and process improvements.
• Assist in maintaining inventory management procedures and documentation.

• Prepare and distribute recurring inventory reports, reconciliation summaries, and variance analyses.
• Generate inventory performance reports for Supply Chain, and Finance teams.
• Develop and maintain Excel-based reports, reconciliation tools, dashboards, and KPI reporting.
• Analyze inventory trends and identify opportunities to improve inventory performance.
• Support inventory planning, forecasting, optimization, and working capital initiatives.
• Provide ad hoc analysis and reporting as required.

• Partner with Finance, Procurement, Planning, Production, Supply Chain, Warehouse, Logistics teams, and 3PL providers to resolve inventory issues.
• Communicate inventory risks, discrepancies, and corrective action plans.
• Support inventory financial reconciliation and close activities.
• Participate in inventory review meetings and process improvement initiatives.
• Promote inventory control best practices and compliance.

• Maintain inventory records and supporting documentation for audits.
• Ensure compliance with…