Supply Chain Operations Analyst

Position:                                Supply Chain Operations Analyst     

Department:                       Operations Department - Boylan Bottling Company

Reports To:                           Director of Supply Planning

Employment Status:       Full-Time

Office Location:                  22 Vanderbilt, New York, NY (Remote Optional)

 

Job Summary

The Supply Chain Operations Analyst is an entry-level position responsible for ensuring the timely and accurate recording of inventory purchases, production activity, inventory movements, supplier invoices, and inventory adjustments within Microsoft Dynamics 365 Business Central.

This position works closely with Supply Chain, Operations, Accounting, co-packers, third-party logistics providers (3PLs), and suppliers to ensure ERP transactions accurately reflect physical inventory activity.

The position requires a high degree of accuracy, attention to detail, organization, follow-through, and the ability to research and resolve inventory and transaction discrepancies.

Job Specific Responsibilities and Duties: 

Inventory Purchase Transactions

• Receive and post raw materials, packaging materials, and other inventory purchases against approved purchase orders in Microsoft Dynamics 365 Business Central.
• Verify quantities received against purchase orders, receiving documentation, supplier documentation, and warehouse or co-packer records.
• Identify quantity, cost, or receiving discrepancies and investigate differences before transactions are finalized.
• Ensure inventory receipts are entered accurately and within established processing timelines.

Production Posting

• Record monthly production activity for approximately five co-packer locations.
• Review production reports received from co-packers for completeness and accuracy prior to posting.
• Post finished goods production into Business Central.
• Record raw material and packaging component consumption associated with production.
• Record production scrap, waste, and other adjustments as required.
• Review production transactions for reasonableness and identify unusual material usage or production variances.
• Investigate discrepancies between reported production, material consumption, and expected production quantities.

Inventory Transfers

• Process inventory transfer orders for finished goods moving from co-packers to approximately four third-party logistics providers.
• Record truckload transfers accurately and timely within Business Central.
• Verify quantities shipped from co-packers against quantities received by 3PL locations.
• Investigate in-transit, shipping, receiving, or system discrepancies.
• Ensure transfer orders are properly completed and closed once inventory has been received.

Supplier Invoice Processing

• Process management-approved supplier invoices for raw materials, packaging materials, and other inventory-related purchases.
• Match invoices to the appropriate purchase order and inventory receipt before posting.
• Verify supplier pricing, quantities, freight charges, and other applicable costs.
• Post approved supplier invoices in Business Central.
• Investigate invoice discrepancies involving price, quantity, receipt, or purchase order differences.
• Coordinate with Supply Chain, suppliers, Accounting, and other internal stakeholders to resolve discrepancies.
• Maintain appropriate documentation supporting invoice transactions.

Inventory Reconciliation

• Reconcile Business Central inventory balances to inventory reports provided by co-packers and 3PL partners.
• Research differences between ERP inventory and physical or third-party inventory records.
• Identify missing receipts, production transactions, transfers, consumption postings, or adjustments.
• Work with internal teams, co-packers, and 3PLs to resolve inventory discrepancies.
• Prepare required inventory adjustments for review and approval.
• Maintain documentation supporting inventory reconciliation activity.

Quarterly Physical Inventory

• Participate in quarterly physical inventory counts at co-packer and 3PL locations.
• Assist with planning and coordinating inventory count activities with internal teams and external warehouse partners.
• Perform or observe physical counts of finished goods, raw materials, packaging materials, and other inventory as assigned.
• Compare physical inventory results to Business Central balances and third-party inventory records.
• Research and document inventory variances identified during physical counts.
• Work with co-packers, 3PLs, Supply Chain, and Accounting to determine root causes of inventory discrepancies.
• Prepare inventory adjustment documentation for management review and approval.
• Verify approved inventory adjustments are accurately posted in Business Central.
• Maintain supporting count sheets, reconciliation documentation, and variance explanations for audit and quarter-end purposes.
• Identify recurring inventory accuracy issues and escalate trends or control weaknesses to management.

Supply Chain Analysis

• Monitor and analyze inventory discrepancies and recurring transaction issues.
• Analyze purchase price variances between purchase orders and supplier invoices.
• Review material usage variances associated with production runs.
• Monitor production yields and identify unusual results requiring further investigation.
• Identify recurring errors or process gaps and recommend improvements to transaction accuracy and internal controls.
• Assist management with ad hoc supply chain reporting and analysis as needed.

Month-End Close Support

• Ensure all inventory receipts, production transactions, material consumption, inventory transfers, and approved supplier invoices are posted prior to month-end close.
• Review outstanding transactions that could impact inventory or cost accuracy.
• Reconcile key inventory records as required.
• Investigate and resolve transaction discrepancies prior to close.
• Coordinate with Accounting and Supply Chain management to ensure month-end deadlines are met.
• Maintain supporting documentation for month-end inventory transactions and reconciliations.

Qualifications: 

• Bachelor’s degree in Supply Chain Management, Business, Operations, Accounting, Finance, or a related field preferred; equivalent relevant experience may be considered.
• 0–2 years of experience in supply chain, inventory, purchasing, operations, accounting, or a related field.
• Strong attention to detail and commitment to transaction accuracy.
• Strong organizational skills and ability to manage multiple transaction types and deadlines.
• Basic understanding of inventory, purchasing, production, and accounting concepts.
• Strong problem-solving skills and ability to investigate discrepancies.
• Comfortable communicating with suppliers, co-packers, warehouses, 3PL providers, Accounting, and internal management.
• Proficiency in Microsoft Excel.
• Ability to work independently while escalating significant discrepancies appropriately.
• Ability to travel periodically to co-packer and 3PL locations for quarterly physical inventories, as required.

Key Performance Indicators: 

• ERP Transaction Accuracy: Percentage of transactions posted correctly without requiring correction.
• Transaction Timeliness: Inventory receipts, production, transfers, and invoices posted within established deadlines.
• Inventory Reconciliation Accuracy: Timely identification and resolution of differences between Business Central, co-packer, and 3PL inventory.
• Physical Inventory Accuracy: Accuracy of physical inventory results versus ERP and third-party inventory records.
• Month-End Close Completion: All required supply chain transactions completed by the established accounting close deadline.
• Invoice Accuracy: Percentage of supplier invoices posted without subsequent correction.
• Production Posting Accuracy: Accuracy of finished goods, material consumption, scrap, and production-related transactions.
• Discrepancy Resolution: Timeliness and effectiveness of resolving inventory, invoice, transfer, and production discrepancies.
• Production Yield and Material Variance Monitoring: Identification and escalation of unusual production or material usage variances.

 

 

The job description outlined above is considered a core list of job duties/requirements.  This document should not be considered a complete or comprehensive list.  The incumbent assigned to this position is required to perform the duties listed above.  The incumbent is also expected to adapt to changes and/or additions as needed.  Nothing contained within this document is intended or shall be construed to create or constitute a contract of employment between any employee or group of employees and Emigrant Savings Bank and its Subsidiaries.  Emigrant Savings Bank and its Subsidiaries retains and reserves any and all rights to change, modify, amend, add to or delete from any section of this document as it deems, in its judgment, to be proper.