Sales Analyst

Leggett & Platt • Detroit, MI

40d

About The Position

We make life more comfortable. Leggett & Platt’s overall mission is a commitment to enhance lives – by delivering quality products, offering empowering and rewarding careers, and doing our part in bringing about a better future. Leggett & Platt’s inventive heritage and leadership in the residential products industry span more than 130 years. As The Components People , we are the leading supplier of a wide range of products and components for all areas of life, including mattress springs and carpet cushion, as well as bedding machinery and erosion-control products. From aerospace tubing and fabricated assemblies to flooring underlayment and carpet cushion, Leggett & Platt has divisions that design, manufacture, and sell a variety of products. Our reliable product development and launch capability, coupled with our global footprint, make us a trusted partner for customers in the aerospace, hydraulic cylinders, flooring, textile, and geo components industries. Learn more about the history of Leggett: https://leggett.com/history Automotive Leggett & Platt Automotive is a global provider of wire forms, mechanical control cables, wireless charging, as well as seat lumbar, suspension, bolster, actuator, and motor systems. In addition to these award-winning, category-leading products, we offer tailored goods due to our expertise in product development and attention to market trends. Our unique competitive advantages give us unmatched insight into the demands of the consumer. Learn more about Leggett & Platt Automotive: Leggett & Platt Automotive Our Executive offices are located in both Downtown Detroit and Troy, MI. Potential candidates need to be able to commute to both locations. Leggett & Platt Automotive Division is currently seeking a Sales Analyst to collect & analyze NBO, Award, Pricing, DR and AR data from sales, finance, demand planners & additional functions as needed, to generate reports, analysis, dashboards, globally/regionally, product group/product type related on weekly sales reports, monthly MBR and not only, to support sales, management and business decisions.

Requirements

• College Diploma or bachelor’s degree in business, or equivalent
• 1-2 years relative experience, automotive/ industry / manufacturing preferred
• Strong analytic, problem-solving, & Excel skills
• Excellent written & verbal communication skill
• Knowledge of MS Office
• Good English level

Responsibilities

• Accountable of the Global Sales Plan Data base, updating and maintaining as needed, adding formulas and drop down menus, defining report format.
• Analyze sales & demand data, creating various reports as input for monthly demand meetings and for all S&OP meetings as needed.
• Generate the sales KPI's, such as in time quote preparation, award winning, sales forecast, win rate, A&R and DSO thru the weekly sales Exec Perf Dashboard and commercial demand slides. Communication liaison between sales and branch finance departments and other regions' Sales Analysts.
• Responsible of monitoring all Customer PO's and upload prices in GFP after Customer PO release in QStrat; close communication with Sales Directors & Managers, Sales Coordinators, Finance Directors, Branch Controllers, Senior Business Directors and Business Analyst, ensuring correct and timely price updates
• Responsible to capture all LTA's, Quick Savings, rebates or any other savings from QStrat, issuing and updating a report (commercial data base) to share with Sales and Finance.
• Actively participates in all requirements necessary for annual QS & Audit certifications on any commercial information from the Global Sales Plan, QStrat, DR & A&R
• Deputy for the Sales Coordinator, to enter any new PTS data into the global sales plan and to consolidate the weekly A&R reports and issue the AR Dashboard
• Deputy for the Demand Planner, using Control Tower for current and future business, 18 month forecast, 5 year forecast, and all current opportunities worked by sales.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level