Warehouse Analyst & Reporting

PT Delta Djakarta Tbk; Bekasi; On-site; IDR 140,000,000 - 210,000,000; Full time

Job summary

PT Delta Djakarta Tbk is seeking an Inventory Data Analyst to collect, validate, reconcile, and report on finished goods and returnable bottles. You will support accurate stock records, ensure product availability, and provide data-driven insights for continuous improvement across warehouse operations.

Responsibilities include analyzing movements, validating ERP/WMS records, and producing SKU-level reports with dashboards using Excel, Power Query, and Power BI.

Qualifications

• Bachelor's degree in a related discipline.
• Proficient in advanced Excel and data visualization tools.

Responsibilities

• Monitor and analyze finished goods movements and inventory data.

Skills

Advanced Excel (PivotTables, XLOOKUP,

Power Query

Data analysis

Analytical thinking

Structured problem-solving

Attention to detail

Communication

Cross-functional collaboration

Education

Bachelor's degree in Supply Chain Management

Bachelor's degree in Logistics

Bachelor's degree in Industrial Engineering

Bachelor's degree in Statistics

Tools

ERP/WMS transactions

Inventory management systems

Job description

To collect, validate, reconcile, analyze, and report operational and inventory data for Finished Goods and Returnable Bottles accurately and on time. The role supports reliable inventory records, product availability, returnable bottle circulation, efficient warehouse operations, and evidence-based management decisions. It identifies exceptions, investigates data discrepancies, and provides actionable insights for continuous improvement.

Key responsibilities

• Monitor and analyze finished goods movements, including production receipts, storage, stock transfers, dispatches, and customer returns.
• Validate physical stock balances against the Enterprise Resource Planning (ERP), Warehouse Management System (WMS), or other approved inventory records.
• Prepare SKU-level inventory reports by product, brand, packaging format, production batch, expiry date, and storage location.
• Analyze inventory aging, slow-moving and non-moving stock, damaged goods, and products approaching expiry.
• Monitor the receipt and recorded movement of empty returnable bottles from distributors, customers, and other authorized collection channels.
• Reconcile bottle movements by type, size, source, condition category, and applicable return documentation.
• Collect, verify, consolidate, and report warehouse operating data on a daily, weekly, and monthly basis.
• Produce accurate inventory movement reports, returnable bottle statements, and reconciliation summaries.
• Develop and maintain standardized reporting templates, databases, dashboards, and data visualizations using Excel, Power Query, Power BI, or approved corporate applications.
• Reconcile inventory records among the warehouse, ERP/WMS, transaction documents, and physical count results.

About you

• Bachelor's degree in Supply Chain Management, Logistics, Industrial Engineering, Statistics, or a related discipline.
• Preferably one to three years of relevant experience in warehouse administration, inventory control, data analysis, or operational reporting.
• Advanced Microsoft Excel skills, including PivotTables, XLOOKUP, SUMIFS, and Power Query.
• Practical knowledge of ERP/WMS transactions, inventory movements, cycle counting, and inventory reconciliation.
• Understanding of FIFO/FEFO, inventory aging, stock accuracy, and warehouse performance indicators.
• Ability to design clear management reports and translate operational data into actionable insights.
• Analytical thinking and structured problem-solving.
• Accuracy, attention to detail, and strong data integrity.
• Effective communication and cross-functional collaboration.
• Time management, reporting discipline, and follow-through.

About us

PT Delta Djakarta Tbk operates in the food and beverage manufacturing sector with finished goods and returnable packaging operations.