Parts Data Coordinator

Smith & 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.

• Responsible for data collection within the Parts Division.
• Download order data from Kinetic and Maximizer daily to check for errors and forward to Parts Supervisor for correction 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. Attend necessary meetings to track these changes.
• Research orders weekly tracking credit holds, user holds, and payment status to confirm all steps for order processing have been completed.
• Research historical orders and invoices with 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 download Part Cost information and update 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.

• Associate’s degree in business or higher.
• Must be able to develop Microsoft Excel pivot tables and cell formulas (including VLOOKUP and IF formulas) as well as generate reports and analyze data.
• Functional knowledge of Microsoft Excel, Microsoft Word, Microsoft Outlook, and Maximizer.
• Attention to detail.

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

• 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