Sales Data & Administration Specialist (Bilingual-Korean)

Sales Data & Administration Specialist

Position Summary
We are looking for a Sales Data & Administration Specialist to join our team. This position is responsible for compiling sales data from the ground up, organizing it into structured Excel files, and keeping the Sales Master File and KPI Tracker accurate and up to date. The role serves as a key communication point with the SCM team on sales activity and supply status, and with the Business Management team on revenue, ensuring the sales organization always works from a single, reliable set of data.

Sales Data Compilation & Excel Management

• Collect and compile raw sales data (POs, shipments, invoices, deductions) from source systems on a bottom-up basis
• Build and maintain structured Excel files so that all sales data is analysis-ready for the sales and management teams
• Consolidate monthly revenue figures by customer, channel, and SKU based on received Purchase Orders (PO)
• Perform regular data validation and reconciliation to ensure accuracy and consistency across all files
• Prepare standardized data sets, pivot tables, and summary views to support revenue analysis
• Maintain and update the Sales Master File, keeping item, customer, price, and promotion data current
• Update and maintain the KPI Tracker, reflecting the latest actuals against targets
• Apply version control and ensure data accuracy across all master files and trackers
• Cross-functional Communication

• Communicate regularly with the SCM team on inventory, shipment, and supply status to support sales activity and revenue analysis
• Cook with the Business Management team on revenue figures, monthly closing, and revenue reporting
• Share sales data and schedule updates with Sales, SCM, Procurement, and Finance teams on a set cadence
• Escalate and follow up on issues quickly to keep data, shipments, and revenue records aligned

Sales Activity & Revenue Reporting

• Support Prepare monthly revenue and sales activity summaries from the compiled raw data
• Track Plan vs. Actual at the data level and flag gaps for the sales team's review
• Support the sales team with ad-hoc data pulls and customer-level reporting requests

HQ Reporting

• Prepare and submit regular HQ reports (monthly/quarterly) based on consolidated data files
• Respond promptly and accurately to ad-hoc data requests from senior management and HQ
• Compile reporting packages covering revenue status, schedules, and KPI Tracker results

Requirements

• 0-2+ years of experience in sales administration, sales support, or data management
• Strong communication, organizational, coordination, and follow-up skills, with the ability to work daily with SCM and Business Management teams
• Advanced Microsoft Excel skills (pivot tables, VLOOKUP/XLOOKUP, data consolidation and cleansing); experience with ERP systems (SAP preferred)
• Bilingual proficiency in English and Korean
• Preferred Qualifications: Experience in the food industry, managing trade promotions and deductions, working with key retail or distributor accounts, extracting and reorganizing sales data from ERP or reporting systems for analysis

Pay & Benefits

The base salary for this position is between $28-33/per hour. Actual compensation will depend on a variety of factors, including qualifications, experience, and location. This position may also be eligible for additional compensation and benefits, including an annual incentive bonus, medical/dental/vision insurance, life insurance, PTO/FTO, and a 401(k) plan with company match.

Equal Employment Opportunity

Samyang America is committed to providing equal employment opportunities to all individuals. We do not discriminate in employment decisions on the basis of race, color, religion, sex, national origin, age, disability, genetic information, or any other status protected by applicable federal, state, or local laws.