Assistant Analyst, Merchandising Planning

Reporting to the Manager, Central Planning, this position is to support the delivery of our central merchandising planning by analyzing data and generating reports using database management skills. Support includes the assistance of directing and managing the development and implementation of the enterprise planning system to connect and track all business commitments such as inventory level, fill rate, purchase order status, suppliers’ performance and ongoing shipments Collaboration with all relevant internal (IT, Merchandising, Operations) and external parties (software and hardware vendors) and following up on various projects is vital to the success of this role.

Reporting to the Manager, Merchandising Planning, this position is to support the delivery of our central merchandising planning by analyzing data and generating reports using database management skills. Support includes the assistance of directing and managing the development and implementation of the enterprise planning system to connect and track all business commitments such as inventory level, fill rate, purchase order status, suppliers’ performance and ongoing shipments Collaboration with all relevant internal (IT, Merchandising, Operations) and external parties (software and hardware vendors) and following up on various projects is vital to the success of this role.

You Will

• Monthly sales/inventory review to analyze abnormal sales history, review projections or forecast on sales, gross margin, and inventory is accurate
• Design and maintain replenishment data in systems in timely manner
• Able to manage vendors and work with shipping teams to make sure products arrival on time
• Meet replenishment KPIs (DOH/filled rate/in-stock rate) and able to maintain purchasing records, prepares summary statistical analysis; monitor safety stock level, fulfillment rate and inventory turnover rate
• Work with manager to maintain and generate various performance reports at all levels (category/department/ merchandise category/SKU)
• Extract data and prepare summary statistical analyses
• Assist in documenting and executing best practices, processes for developing, modifying, and configuring enterprise planning system services and integrations; review related documents and to ensure proper knowledge transfer within relevant teams
• Provide support and troubleshooting for the enterprise planning system and all related systems; communicate incident status with manager to ensure resolution delivery
• Enhance forecast accuracy by monitoring and addressing forecasting errors
• Provide feedback on capacity risks and supply issues to merchants and planning partners where necessary
• Closely collaborate with manager to provide data to relevant departments for the preparation of consolidations are accurate while to align supply and demand 
• Perform other duties and projects as directe

You Should Have / Be

• A bachelor’s degree in business administration, business analytics, mathematics, supply chain management, or other related disciplines
• 1-2 years’ experience in supply chain field is mandatory
• Previous experience in a fast-paced business environment, preferably in the strategy consulting, corporate strategy - retail industry, or supermarket chain store operations
• Knowledge of ERP system is an asset, understand clearly the concept of replenishment
• Ability to collaborate with multiple stakeholders, taking initiative and managing multiple priorities in a rapidly changing environment
• Analytical thinking and has ability to identify alternatives to solve problems
• Ability to work effectively in high-pressure situations that require sound decision making and may involve confidential or sensitive matters 
• Must have excellent time management, interpersonal, organizational, relationship-building, and negotiation skills and be able to deal effectively with all levels within and outside the organization
• Must have advanced level of computer skills in MS Word, Excel (formula, macros), Outlook & PowerPoint

This is an active job posting for a currently vacant position. We are recruiting to fill this role as part of our ongoing operational needs.

• Extended health/dental/vision care
• Retirement benefit
• Life/AD&D insurance 
• Paid vacation, sick, marriage, bereavement leaves
• 10% in-store staff purchase discount
• Subsidized staff meal

Safety continues to be T&T Supermarket’s top priority. We’ve established health and safety policies and measures to ensure our Stores, Food Processing & Production Centres and Warehouse & Distribution are as safe as possible.

T&T Supermarket is an Equal Opportunity Employer. We do not discriminate based on race, religion, color, national origin, gender, gender identity, age, veteran status, non-disqualifying physical or mental disability, or any other applicable characteristics protected by law.

Schedule

Full Time

Work hours

5-day work week (Monday to Friday), 9:00am – 5:30pm (Actual working hours may vary slightly by department, depending on operational needs.)

Salary

$45,000 - $55,000 / year

Salary notes

(Salary negotiable & commensurate with experience and qualifications.)