Retail Data Analyst Assistant

Job Description

The Retail Data Analyst Assistant plays a crucial role in supporting the data team at 99 Ranch Market. Key responsibilities include data entry, maintenance, and adjustments of product information, as well as effective communication with stores, distribution centers, and the purchasing department.

This position focuses on enhancing operational efficiency through the use of data automation, process optimization, and data analysis tools. By ensuring accurate and smooth product data operation, this role contributes to supply chain management, inventory optimization, and the execution of merchandising strategies, providing an enhanced shopping experience and improved operational performance.

Main 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.
• Regularly review and validate product data to ensure it meets company standards and industry compliance.
• 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.

Required Skills and Qualifications:

• 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.
• $0 per hour.