Sr Forecasting Analyst - Walmart

Sr Forecasting Analyst - Walmart Full-time Location: California - El Segundo Company: Mattel Sales Corp. Compensation: USD 69000 - USD 88000 - yearly Company Description CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers. The Team: Mattel is currently seeking a Sr. Analyst to lead the replenishment and planning for a top retailer. This role will be a member of a dynamic team focused on collaborative sales forecasting and inventory management. Job Description The Opportunity: The Sales & Planning Analysis (SPA) Senior Analyst will lead the day to day replenishment & execution of the business, in partnership with the Mattel commercial team and the retailer. This role spans all aspects of commercial execution including store level inventory management, order writing/analysis, internal inventory readiness, and order fulfillment, through to on shelf availability. This role is instrumental in supporting the sales team and driving the business with our Walmart partners. The individual will report into the Walmart Forecasting Sr. Manager. What Your Impact Will Be: Own store in-stock metrics by influencing the end-to-end order process including order creation, reviewing daily orders, maintaining perfect PO’s, and optimizing fill rate. Own the execution of our Direct Import business out of Asia, partnering closely with the Customer Service team in our Hong Kong office. Consumption execution – Drive a weekly shipping plan by item, by channel, to support POS plans, retailer in-stock and future order needs. Daily/Weekly involvement with the sales team coupled with retail analysts/buying team, joint business planning related to in season execution for promotional planning and fulfillment, domestic and import order reviews and chase/cancel with retailer. PO order recommendations for current and future looking domestic and direct import. Liaison between customer service and supply planning and allocations teams to maximize PO fill rates Actively lead and participate alongside Mattel sales team in key CPFR forecasting meetings with Walmart. Present business findings and recommend action plan for the season or year. Assist in managing and prioritizing follow-ups from meetings. Attend internal consensus meetings to present and share current execution at retail, provide key data findings to cross-functional S&OP teams to reach a consensus forecast on a month to month basis Reporting as requested to support the sales team / customer and other business needs. Qualifications What We’re Looking For: Key Characteristics Strong Analytical Skills – ability to coordinate diverse information, identify relevant data, recommend and implement corrective actions Solid Interpersonal and Communication Skills – ability to communicate effectively across all organizational levels and all functional areas, ability to understand, assess and present the viewpoints of others Sound Business Judgment – ability to interpret issues and recommend actions to best support group, division and corporate goals Process Oriented - Ability to identify and address process improvements and share expertise with others Basic Qualifications Proficient in MS Office, Excel Power User Direct replenishment experience planning in a