Admin Sales MT
FACETOLOGY (PT Facetology Innovation Technology) · Jakarta Selatan, Indonesia
Deskripsi pekerjaan
Responsibilities
- 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.
Requirements
- 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.