Overview
As a Junior Sales Analyst, this individual will be responsible for collecting, analyzing, and ensuring data accuracy at the customer and SKU level that make up the company’s rolling monthly forecast. This position will also drive continuous improvement to provide strategic recommendations and utilize business intelligence software to build dashboards for more accurate and consistent reporting. Furthermore, the successful candidate will analyze submitted data to validate the logic and identify inconsistencies or issues with submitted data and work with Sales to resolve. This candidate will be a key member to the operational excellence of the sales organization. The ideal candidate is hands-on, detail-oriented, analytical, and enthusiastic about solving complex problems to help our sales organization grow and succeed.
Company Summary
Founded in 1944, HSM is a third generation privately held company which offers a proud rich history immersed in manufacturing innovation and our commitment to our people. We have 25 unique locations across the United States. Our Corporate Headquarters is in Hickory, NC and houses our leadership, Finance, EHS, Human Resources, Benefits, and additional teams.
HSM specializes through its subsidiaries, in the manufacturing of components for furniture, bedding, transportation, packaging, automotive, and healthcare industries. We also design and construct automated production machinery for these industries. We likely have manufactured something you use every day like sofa or bed springs, pool noodles, recliner mechanisms, packaging supplies, fabricated sofa cushions, bus seats, and much more.
Our commitment to excellence goes far beyond our products and processes; it is centered on the people who make it all possible. If you're interested in learning more about our company culture, as well as the benefits we offer our employees, please visit our website or social media pages.
Responsibilities
Distribute and consolidate the rolling 18-month customer sales forecast.
Use continuous improvement and user feedback to streamline the sales forecast input process to be less burdensome and more accurate.
Constantly strive to improve the accuracy of the forecasts and automate as much as possible. This includes using historical seasonality to accurately break forecast down to a weekly basis.
Use dashboards to identify the root cause of deviations between forecasts and actual performance, and drive improvements to forecast accuracy each month.
Utilize Business Intelligence software to build dashboards for more accurate and consistent reporting to company leadership.
Analyze products at the Customer/SKU level to verify and forecast profitability.
Highlight any SKUs that project margin compression, communicate with the product manager, and provide insight to future adjustments needed to align with company goals.
Verify sales data integrity between various software systems.
Other analyses and support of the Sales & accounting functions as assigned.
Qualifications
Education in Computer Science, Mathematics, Data Science, or related focus
1-3 years of experience or relevant advanced degree
Proficient in Business Intelligence software.
Proficiency with Microsoft Office. (PowerBI in particular).
Strong cognitive and analytical skills.
Excellent verbal and written communications skill set.
Must be able to handle sensitive and proprietary information in a confidential manner.
Ability to lead effective training sessions and conduct one-on-one training
Must have strong interpersonal skills, an ability to develop relationships within the organization, and strong business judgment to ask clarifying questions when data doesn’t look accurate.
JD Edwards or Planful experience preferred.
Top Benefits
As a Junior Sales Analyst at HSM, you’ll enjoy:
401k Contribution Match up to 4% (100% Vested from Day 1), 9 paid holidays, 3 Weeks of PTO (Eligible after 60 days), Affordable Total Package Benefits offerings for you and your family, On-Site No-Cost Medical Clinics for you and Covered Dependents, Teladoc 24/7 ($0 copay), Global Healthcare and Tuition Reimbursement & Professional Development Assistance.
EEOC
HSM prohibits discrimination based on any protected status, workplace harassment/bullying, and retaliation for filing a complaint or providing information related to a complaint. HSM provides equal employment opportunity to all employees and applicants without regard to an individual's protected status: race/ethnicity, color, national origin, ancestry, sex/gender, gender identity/expression, sexual orientation, marital/parental status, pregnancy/childbirth or related conditions, religion, creed, age, disability, genetic information, veteran status, or any other protected status.