Admin Sales MT

FACETOLOGY; Jakarta Pusat; Presencial; IDR 78.120.000 - 111.600.000; Jornada completa

Descripción de la vacante

Facetology, a local startup in Indonesia's beauty and personal care industry, is hiring a Sales Administration specialist to monitor MT data, consolidate sources, and maintain dashboards.

You will support PPL requirements, process invoices and price revisions, coordinate with Finance, distributors, and cross-functional teams, and ensure timely daily updates in a fast-paced environment with meticulous attention to detail.

Formación

• Experience in Sales Administration or Sales Reporting is preferred.
• Ability to filter, consolidate, validate, and analyze data from multiple sources.
• Proficient with Excel functions and large-scale data processing.

Responsabilidades

• Monitor and prepare daily Modern Trade sales reports.
• Filter, process, and consolidate sales data from various sources.
• Maintain sales dashboards and pivot reports by account and PO.
• Provide data for MT requirements and promotional evaluations.
• Support Modern Trade claim documentation and price revisions.
• Consolidate invoices and tax invoices for Finance.
• Provide raw sales data for analysis across teams.
• Perform data validation and coordinate with cross-functional teams.

Conocimientos

Pivot Tables

VLOOKUP/XLOOKUP

Data Analysis

Sales Dashboard

Independent Work

Educación

Diploma / Bachelor

Herramientas

Microsoft Excel

Data Visualization

Descripción del empleo

• 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.

Facetology is a local startup dedicated to advancing Indonesia’s beauty and personal care industry. Our mission is to inspire individuals to embrace their natural beauty and strengthen their self-confidence, while continuously developing innovative products that position us at the forefront of the industry. We believe our people are the foundation of this transformation.

At Facetology, creativity, expertise, and passion come together to meet the diverse needs of consumers nationwide. With an unwavering dedication to quality and innovation, we aim to set new standards and shape the future of beauty and personal care in Indonesia.

Innovating beauty, together with Facetology

#BeOneofOurFaces

Cosmetics

Location

Company Size

Culture

We strive to constantly pursue innovation of our products and services

Progressive

Continuous ambition for progress and finding the best means to make it happen

Quality

We put great emphasis on preserving the high existing standard of our products/services