Department Store Sales & CPFR Analyst

MGA Entertainment; Naucalpan de Juárez; On-site; MXN 312,000 - 424,000; Full time

Job summary

MGA Entertainment seeks an analytical and operational support role for the Department Stores channel, consolidating sell-out and catalog data, increasing forecast accuracy, and enabling effective seasonal execution. This role supports the Key Account Manager by ensuring insights and forecasts are aligned with customer expectations, especially during toy seasons.

The candidate will collect and report sell-out, stock and catalog performance, build forecast models, monitor product rotation, assist

Qualifications

• Bachelor’s degree in Business, Marketing, Economics, or related field.
• 2–3 years of experience in sales analysis, CPFR, or trade marketing (FMCG or fashion/retail preferred).
• Knowledge of department store dynamics (catalogs, seasonal campaigns) is a plus.
• Advanced Excel skills; Power BI or Tableau preferred.
• English: intermediate.

Responsibilities

• Collect, analyze, and report sell-out, stock, and catalog performance from department stores.
• Build and maintain forecast models, ensuring accuracy and alignment with business objectives.
• Monitor product rotation and availability, identifying risks of stock-outs or slow-moving SKUs.
• Support the KAM in catalog planning, exclusive launches, and seasonal promotional programs.
• Provide ROI analysis of promotions and catalog placements.
• Prepare commercial presentations and dashboards for negotiations and business reviews.
• Ensure timely and accurate delivery of commercial reports and insights to the KAM and channel team.

Skills

Advanced Excel

Power BI

Tableau

English (intermediate)

Analytical thinking

Presentation skills

Teamwork

Education

Bachelor’s degree in Business/Marketing/Economics

Tools

Power BI

Tableau

Job description

MGA Entertainment seeks an analytical and operational support role for the Department Stores channel, consolidating sell-out and catalog data, increasing forecast accuracy, and enabling effective seasonal execution. This role supports the Key Account Manager by ensuring insights and forecasts are aligned with customer expectations, especially during toy seasons.

The candidate will collect and report sell-out, stock and catalog performance, build forecast models, monitor product rotation, assist