CPFR / Sales Analyst, Department Stores MX

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 is on a mission to inspire imagination and creativity through innovative toys, entertainment, and experiences that transform play into limitless possibilities. As the largest privately held toy and entertainment company in the U.S., MGA is a global leader in designing and delivering world-class consumer products that spark wonder and drive play forward. Headquartered in Los Angeles with offices worldwide, MGA’s portfolio spans a dynamic range of original and licensed brands — from toys, dolls, games, and electronics to fashion, home décor, and entertainment content including hit movies and TV series. The company is recognized for its bold approach to storytelling, trendsetting design, and deep commitment to quality. The award-winning MGA family includes fan-favorite brands such as L.O.L. Surprise!™, Little Tikes®, Rainbow High™, Bratz®, MGA’s Miniverse™, Yummiland™, CarTuned™, Ninjombie™, Wonder Factory™, DohKins™, BABY born®, and Zapf Creation®. To learn more, visit www.mgae.com and follow MGA on LinkedIn, TikTok, Instagram and Facebook.

Mission:

Provide analytical and operational support to the Department Stores channel by 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.

Key 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.

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.

Skills and Competencies:

• Strong analytical skills and ability to identify trends from sell-out data.
• Understanding of department store commercial cycles and promotional calendars.
• Accuracy, attention to detail, and ability to deliver under strict timelines.
• Communication and presentation skills to support sales in negotiations.
• Team-oriented mindset, collaborating with Sales, Trade Marketing, and Demand Planning.
• Proactivity and problem-solving attitude.

Salary:

Standard (Base + Bonus): $28,000 – $38,000 MXN / month + 5–10% annual bonus.

Integrated (No Bonus Policy): $30,000 – $42,000 MXN / month.