Strategic Sourcing Intern: Data Analytics

HexArmor, Limited; Grand Rapids, Northern (MI, KY); Hybrid; USD 25,000 - 39,000; Full time

Job summary

HexArmor seeks a Strategic Sourcing Intern for Summer 2027 to support cost analysis, supplier sourcing, and process documentation across procurement, logistics, and product management. You will work with Excel, SAP Business One, and Tableau to clean and structure large data sets, break down supplier costs, and benchmark pricing.

You will collaborate with Category Managers, Product Managers, and Logistics Specialists daily.

Qualifications

• Currently pursuing a degree in Supply Chain, Business, or Finance (2027/2028 graduates).
• Proven Excel experience in generating and editing multiple interconnected spreadsheets.
• Comfort working with large, unstructured data sets.
• Solid decision making and problem-solving skills.
• Critical attention to detail.
• Strong organizational skills.
• Excellent written and oral communication skills, including direct communication with suppliers.
• Highly motivated and positive attitude.
• Ability to excel in a fast pace work environment by setting priorities and handling multiple simultaneous requirements.

Responsibilities

• Data cleansing and preparation of supplier, item, and pricing data for procurement and financial reviews.
• XLOOKUP/ Index Matching.
• Generating IF statements/formulas.
• Reformatting of exports and importing into existing spreadsheets.
• Identifying and correcting duplicate, incomplete, and inconsistent records.
• Support commodity reviews by compiling spend, volume, and pricing history by material and supplier.
• Build cost breakdown reviews on purchased items, separating material, labor, overhead, tooling, and freight.
• Support indirect vendor sourcing, including building bid lists, issuing RFQs, and summarizing quotes into a side by side comparison.
• Assist with supplier scorecarding by tracking on-time delivery, quality, and responsiveness, and preparing the results for supplier reviews.
• Create and update standard operating procedures for recurring procurement, logistics, and product management processes.
• Support supplier communication on quotes, order confirmations, lead times, and documentation requests.
• Daily operating within SAP Business One for retrieving purchase history, pricing, and item data.
• Support inbound freight review, comparing shipping methods and carriers against cost and transit time.
• Partner with Product Management on item specifications, bills of material, and sourcing needs for new product launches.
• Assist with analysis for improving department processes and procedures.
• Willingness to assist as needed on any necessary reporting or procurement related tasks.

Skills

Excel proficiency

Data analysis

Attention to detail

Communication skills

Organizational skills

Problem-solving

Time management

Supply chain knowledge

Fast-paced environment

Education

Pursuing degree in Supply Chain/Business/Finance

Tools

Excel

SAP Business One

Microsoft Teams

Job description

HexArmor seeks a Strategic Sourcing Intern for Summer 2027 to support cost analysis, supplier sourcing, and process documentation across procurement, logistics, and product management. You will work with Excel, SAP Business One, and Tableau to clean and structure large data sets, break down supplier costs, and benchmark pricing.

You will collaborate with Category Managers, Product Managers, and Logistics Specialists daily.