PARTS DATA COORDINATOR

Job DetailsJob Location: S&L Inc - Office - Lenexa, KS 66215Position Type: Full TimeSmith & Loveless is united under one cause: “Protecting Water. Protecting People.”  We are seeking a Parts Data Coordinator to partner with our experienced Parts & Retrofit Team in this environmentally focused industry.   A Parts Data Coordinator at Smith and Loveless is responsible for data collection for the Parts Division, supporting the Parts Division General Manager. Downloads raw data from multiple databases and manipulates into workable Excel spreadsheets using VLOOKUP, IF variation formulas, Pivot Tables, Subtotals, and other Microsoft Excel functions & formulas. Creates and maintain weekly reports for tracking unit sales, open orders, various sales goals, and other reports as needed. Reviews data for errors or inconsistencies and bring to the attention of the Parts General Manager.   Benefits & Perks 401(k) Retirement Plan with automatic enrollment + employee-directed investment options Discretionary 401(k) Match based on performance (100% vested after 3 years) Annual Profit-Sharing Bonus 100% Employer-Paid Benefits including life insurance & disability coverage Paid Time Off - 10 Paid Holidays; 2 weeks’ Vacation (3 weeks after 5 years); 6 Paid Sick/Personal Days annually Insurance & Financial Benefits - Medical Plans (PPO & High-Deductible options); Dental Insurance with preventative care covered at 100%; Short-Term & Long-Term Disability Coverage; Group Life & AD&D Insurance (company-paid) Additional Benefits - Flexible Spending Account (FSA); Health Savings Account (HSA) (for HDHP participants); Voluntary Life & AD&D Coverage for employees and dependents   Job duties   Responsible for data collection within the Parts Division. Download order Data from Kinetic and Maximizer on a daily basis to check for errors and forward to Parts Supervisor for correcting if needed. Update Maximizer Order Data daily to assist with tracking order status. Report weekly Bookings & Shipments for the Parts Supervisor, Parts General Manager, and Parts Vice President. Update and track the Parts Shortage Report weekly and note any week-to-week changes that occur on orders to bring to the attention of the Parts General Manager. Attending all meetings necessary to track these changes. Research Orders on a Weekly basis tracking credit holds, user holds, and payment status to confirm all steps for order processing have been completed. Research historical orders and invoices that have open questions and report findings to the Parts General Manager Update Unit Sales and Rep Sales Data monthly for review and analysis by the Parts General Manager while reviewing data for errors or inconsistencies. Once per quarter downloading and Part Cost information and updating the Part Cost workbook for review by the Parts General Manager. Other duties as assigned by Parts General Manager or Parts Vice President. Keep work area neat and clean. QualificationsSkills/Requirements Associate’s degree in business or higher. Must be capable of developing Microsoft Excel pivot tables and cell formulas (including VLOOKUP and IF formulas) as well as generating reports and analyzing data. Functional knowledge of Microsoft Excel, Microsoft Word, Microsoft Outlook, and Maximizer. Attention to detail.                                                                                                                         Physical requirements The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this position.  Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions: Required to sit, stand and walk. Use hands to finger, hand or feel objects, tools or controls. Frequent stooping, bending, pulling and pushing. Reach with hands and arms. Required to talk and hear consistently. Ability to occasionally lift, carry and/or drag up to twenty-five (25) pounds if necessary. Specific vision abilities required by the role include the ability to distinguish the nature of objects by using the eye. Ability to ascend and descend two (2) flights of stairs.   About us For over 75 years, Smith & Loveless has provided innovative environmental engineering ingenuity and quality craftsmanship to the water industry by pioneering superior pre-engineered pumping, treatment and headworks systems to a global customer base.  A true pioneer in the water and wastewater pumping industry, Smith & Loveless manufactures cost-effective, operator safe and efficient pump stations for municipalities, developments, industrial, governmental, and military facilities across the globe.   Our energy-efficient and durable systems deliver unrivaled life-cycle cost savings.   With tens of thousands of installations in more than 70 nations on all seven continents, our innovative wastewater/reuse engineered products allow us to maintain our market leadership in lift stations, grit removal systems and over a complete range of wastewater treatment systems.    Check us out Here:      https://smithandloveless.com/smith-loveless-careers-0       Agency Policy: We are not accepting new contract agreements or unsolicited resumes from third-party recruiters or agencies. Any resumes submitted without a signed agreement in place will be considered the property of our company.