Job TypePart-timeDescription
The sales Data Clerk job is to support data work, updating, and summarizing data every month, and analyze data occasionally according to the direction from Sales Director. The data is basically monthly base, so working cycle is monthly base basically. The role needs to treat excel data with 10K rows x more than 100 columns and must have experience to work with excel- pivot, formular, such as “sumif†“ifâ€or “vlook-upâ€, etc. The data includes sales data, forecast data, promotion data, and its analysis. Accuracy of deliveries and meeting the due dates- these are critical factors to meet for that position. Requirements
Duties of Position (Noted Essential Functions*)
Responsibilities – Department-specific (50% of annual business contribution/evaluation weight)
- Responsible for data works assigned by Sales Director.
- Sales data updates by region and national for the forecast sheets
- Forecast summary and simple analysis
- VP (promotion) data work
Knowledge of:
· Experience to use Excel for work or study.
Skills
· High or at least intermediate Excel for work or study. (Must skillful to use pivot, vlook-up, sumif, etc multiple formula, graph, etc) – to check the excel sheet work, want to have small work to assess the skill.
- Have basic concept of sales/promotion(sales deduct).
- Can communicate smoothly without any conflicts/difficulties.
Abilities
- Strong commitment to meet the due date and accuracy
Working Conditions & Physical Requirements
Expected working hour is 30-40 hours / month.
Working time is flexible as long as meeting each data due date with high accuracy.
No need to come to the office physically.
Be able to check in for the hours that spent for data work.
If there is rework happens due to lower accuracy and it happens often, the contract is revisited.
Education/Training & Experience
· As long as skillful in Excel, no other requirements.
· Proficient with MS Office