What are the responsibilities and job description for the weekend assistant position at 99 Ranch Market?
Job Description:
The Merchandising Assistant plays a critical support role in the data team, responsible for the entry, maintenance, and adjustment of product information, as well as effective communication with stores, distribution centers (DCs), and the purchasing department.
Key Responsibilities:
- Accurately input product information, including product names, specifications, categories, and supplier details, ensuring data completeness.
- Update and modify product information as needed, keeping system data timely and accurate.
- Leverage data automation tools to streamline product data entry and updates, reducing manual efforts and improving efficiency.
- Use Excel or SQL to automate price entry processes, minimizing errors and ensuring faster updates.
- Promptly respond to inquiries from stores and DCs regarding product, inventory, and order status, providing operational support.
- Help resolve issues related to product distribution, restocking, or inventory discrepancies, ensuring smooth product flow between stores and DCs.
- Develop and maintain automated reports for store and DC teams to track product availability and inventory levels.
- Review and update purchase prices, including input and adjustments of supplier quotations, ensuring accuracy and consistency in price data.
- Address inquiries related to order status, supplier information, and delivery schedules, maintaining close communication with the purchasing team to ensure seamless supply chain operations.
- Automate order entry and update processes to improve speed and reduce manual errors.
- Develop automated checks and reports to ensure data consistency, quality, and compliance with internal standards.
- Collaborate with merchandising, purchasing, and logistics teams to optimize data processes and improve workflow efficiency.
- Use tools such as Power BI and Tableau to analyze product data, generate insights, and provide recommendations for data-driven decision-making.
- Assist in analyzing product performance and inventory trends, supporting the team in optimizing product assortment and placement.
- Support the team's daily administrative tasks, such as scheduling and recordkeeping.
Requirements:
- An Associate's degree in Business Administration, Marketing, or a related field is required; a Bachelor's degree is preferred.
- Bilingual in English and Mandarin is preferred.
- Proficiency in Microsoft Office Suite (Word, Excel, PowerPoint) and advanced Excel skills are required.
- Experience with data analysis tools like Power BI or Tableau is highly preferred.
- Experience with SQL for managing and querying product data is a plus.
- Strong programming skills in Python or VBA for automating data processing are highly desirable.
- Strong analytical and problem-solving abilities to interpret data and make data-driven decisions.
- Strong attention to detail skills with a keen eye for visual presentation and product placement.
Benefits:
- Medical, Dental, Vision, and Life Insurance
- 401(k) Retirement Saving Plan with 4% Company Match
- $50 per hour
Salary : $50