Job Summary

Forecast Coordinator is responsible to ensure the daily operational demand in terms of quantitative analysis, reporting, and presentations elaboration to provide the Categories and management team with on time essential information to make strategic decisions to achieve to the growth objectives and generate new strategies to continue improving the presente performance in terms of sales, forecast accuracy, and profitability

About The Role

- Quantitative Analysis / Forecast

Promotional Forecast elaboration, GUT, Soft, Firm Commitments elaboration for product news, planning, Categories monthly trend (Product news, promotions, and regular line for each category), On demand analysis for Categories, CMS, and other areas, Weekly sales trend update, Quarterly meeting data base,
- Quantitative Analysis / Historical Data

Limited Editions, New Launches and Promotions Attractiveness, Categories Attractiveness Historical report, Support with Post Launch reports when needed, Price and Margin report for product news, Promotional Tracking report for categories inquiry, Monthly Attractiveness report for product news, Special Attractiveness analysis (special requests for categories), Order Now Historical report and analysis, Historical promotions tracking report, Postmortem Promotions analysis, report, and presentation for PM meeting including cannibalization analysis, Bimonthly results report analysis, Support Forecast Supervisor with GGSOP Report analysis when needed, Support Forecast Supervisor with Categories Dashboard monthly update when needed, Support Forecast Supervisor with Monthly Sales Report elaboration when needed
- Inventories Analysis & Support

Overstock tracking for monthly meeting with material team,



10 Projects with overinventory, Follow up Materials team action plan on overstock report, Promotional plan elaboration for overstock opportunities, Overstock products follow-up, Quantities inventory review with Materials and GIC teams
- POMS

Quantities upload / update twice per month, Monthly audit, Alignment with SharePoint bimonthly files for OFA meetings, Order Now, DEO and Biz Builders configuration in POMs
- Presentations for Strategic Meetings

Weekly meeting Forecast team for priorities follow up, Forecast Committee presentation, Monthly Meeting presentation for MX management team, Quarterly Meeting presentation, Support SBP, BP, and strategic presentations, Support Forecast Supervisor with Monthly sales report (Excel) when needed, Support Forecast Supervisor with Monthly Report (PPT) for regional and global teams when needed(overall promotions for each month), OFA Meeting presentation
- Strategic Projects

Continuous Improvement of forecast process, Product News and Promos consolidated spreadsheet for tracking of the latest quantities, dates, and changes, Support in new upcoming projects, Promo model that control our contribution margin goal.
- Calendars

Activities calendar for global and local teams (Excel), Order Now & Biz Builders Calendar, Product News Calendar monthly update for local and regional teams (Visual) Skills & Experience

Experience: 1-3 years in Finance, Engineering or Economics

Education: Bachelor/University - Finance or Engineering

Language: Fluent reading, writing, and speaking in English.

Additional Skills & Abilities

- Excel advanced
- Analysis capacity
- Numerical skills
- Proactivity
- Leadership
- Teamwork and communication
- Tableau
- Phyton

📌 Coord Planning & Forecasting (Monterrey)
🏢 Mary Kay de México
📍 Monterrey