Demand Planning Coordinator

Pepsico; Xico; Presencial; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A leading global beverage company in Veracruz, Mexico, seeks a Planning & Forecasting Analyst. This role involves analyzing purchase requisitions based on demand and inventory plans, ensuring on-time deliveries, and preparing financial projection reports. Candidates should have 2-3 years of Supply Chain experience and be fluent in English and Spanish, with strong skills in POWER BI and Advanced Excel. A commitment to customer service and cross-functional collaboration is essential for success.

Formación

• 2-3+ years of experience in Supply Chain and Planning.
• Fluent in English and Spanish.
• Proficient in POWER BI and Advanced Excel.
• High customer focus with a results-driven mindset.
• SQL language proficiency for using ACCESS.

Responsabilidades

• Analyze and manage purchase requisitions based on demand and inventory.
• Ensure on-time deliveries and troubleshoot supply issues.
• Prepare financial shipping and inventory projection reports.
• Facilitate monthly demand forecast meetings with cross-functional teams.

Conocimientos

Supply Chain and Planning experience

Excellent communication skills in English and Spanish

Ability to work independently

Coordinate and communicate with cross-functional departments

Customer focus

POWER BI usage

Advanced Excel skills

SQL language proficiency

Ability to drive for results

Herramientas

SAP

Excel Macros

Descripción del empleo

Planning & Forecasting Analyst (Supply Planner)

We are one of the world’s largest apparel, footwear and accessories companies connecting people to the lifestyles, activities and experiences they cherish through our family of iconic outdoor, active and workwear brands. At the heart of our journey lies our company-wide purpose: We power movements of sustainable and active lifestyles for the betterment of people and our planet. This is our purpose. It’s the reason we come to work every day. It’s a commitment shared by all of our global associates across brands. Our purpose unites us and leads us to pursue our goals, together. This is our calling.

We believe that when you discover the difference between a career and a calling, you get so much more out of life. When those lines begin to blur, you start to limit yourself much less and start aiming for more. That’s what we want for everyone who joins us at VF. And frankly, that’s what it takes to thrive here.

Here you can do the best work of your life. We are purpose led and performance driven, people-focused and supportive. Most importantly, we believe that everyone should be empowered to be their authentic self and we power an internal movement of inclusion and belonging. Our teams are built on a global mindset, sparked by sharp minds of diverse individuals and reflect the global consumers we serve.

Bring your energy and fresh perspective, contribute to our movement and build your future with us.

Position Summary:

This position will analyze, manage, and execute purchase requisitions based on demand, forecast, and inventory plans. Works with appropriate cross functional teams to ensure on time deliveries (both vendor and customer) and completes root cause analysis when they are late. Maintains proper inventory mix and helps to dispose of excess inventory. Analyze current and historical trends to make forecast recommendations to a cross functional team of Finance, Sales, and Merchandising to support the financial goals along with securing appropriate production capacity. Prepares financial shipping and inventory projection reports. Develops seasonal forecasts with monthly flows as required to secure capacity including, but not limited to style and color levels.

Skills:

• 2-3+ years in experience in Supply Chain and Planning.
• Excellent communication (oral and written) skills. English and Spanish required.
• Ability to work independently
• Ability to coordinate and communicate between cross functional departments worldwide
• Ability to support a team for any meetings or special projects
• Operates with discipline
• High customer focus with an ability to drive for results
• POWER BI usage is required. Knowledge of DAX language is desirable.
• Advanced Excel skills are required. SAP usage is desirable. BW or other query tools are also desirable.
• SQL language proficiency is highly desirable for using ACCESS and Excel Macros. PYTHON usage is desirable.

***US VISA REQUIRED FOR TRAVEL.

Main Responsibilities

• Develop capacity constrained supply requirements for vendors that support customer service, inventory, and cost objectives based on consensus forecasts.
• Execute purchase requisitions according to lead time calendars.
• Work closely with Customer Service, Distribution, Sourcing, and Logistics on a daily basis to ensure on time shipments to customers. Troubleshooting supply actual vs requested as needed.
• Accountable for overall inventory levels for assigned product group, including working with sales team on managing distressed inventory.
• Responsible for maintaining system integrity (demand and supply data) as well as updating the appropriate “age” of the inventory according to the seasonal calendar.
• Responsible for monthly S&OP reporting/improvement plans of KPI’s, inventory, and forecasts.
• Prepare and facilitate monthly cross functional demand forecast meetings with Sales, Finance, and Merchandising by analyzing historical demand and current trends with focus on reaching consensus on the final forecast.
• Convert demand forecast into financial ship forecast by analyzing the current order base, carryover, and ship assumptions. Facilitate monthly meeting with Finance and Sales to recommend ship forecast and reach agreement on financial forecast submission to corporate.
• Prepare monthly inventory roll incorporating ship forecast, receipt plan from Planning and Retail open to buy. Facilitate monthly meeting with Finance to review receipt plan and actual/projected inventory vs plan.
• Recommend style and color forecasts to Merchandising and Sales by analyzing historical trends and understanding future initiatives and strategies. Develop seasonal/monthly flows to meet financial goals and provide detailed forecasts for Sourcing to secure capacity.