Admin Sales MT

Tanggung Jawab

• Monitor and prepare daily Modern Trade (MT) sales reports to ensure sales performance is tracked accurately and consistently.
• Filter, process, and consolidate sales data from various sources, including B2B systems and daily sales reports from distributors.

Maintain sales dashboards and pivot reports covering sales performance by account, Purchase Order (PO), daily store sell-out, and product to support effective sales monitoring.

• Provide sales data and analysis to support PPL requirements and promotional program evaluations.
• Support the preparation and administration of Modern Trade claim documents, ensuring all supporting documents are complete and accurate.
• Compile and update daily price revision records to ensure pricing data remains accurate and up to date.
• Consolidate invoices and tax invoices, ensuring all supporting documents are complete before submission to the Finance team.
• Provide accurate and well-structured raw sales data to support analysis and reporting needs across relevant teams.

Perform data validation, maintain organized documentation, and coordinate with cross-functional teams to ensure smooth sales administration processes.

Kualifikasi

Minimum Diploma (D3) or Bachelor's degree (S1) in any field, preferably in Business Administration, Management, Accounting, or a related discipline.

Minimum 1 year of experience in Sales Administration, Sales Reporting, Data Administration, or a similar role. Experience in the Modern Trade channel is an advantage.

• Proficient in Microsoft Excel, particularly Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, IF functions, and large-scale data processing.
• Able to filter, consolidate, validate, and analyze sales data from multiple sources.
• Experienced in creating structured, accurate, and easy-to-understand sales dashboards and reports.
• Familiarity with invoice administration, tax invoices, price revisions, and claim documentation is an advantage.
• Detail-oriented, analytical, well-organized, and able to coordinate effectively across teams.
• Able to work independently, manage multiple tasks, and meet daily reporting deadlines.