Data-Driven Strategic Sourcing Intern — Summer 2027

HexArmor; Grand Rapids (MI); On-site; USD 25,000 - 36,000; Full time

Job summary

HexArmor is seeking a Strategic Sourcing Intern for Summer 2027 in Grand Rapids, MI. You will support cost analysis, supplier sourcing, and process documentation across procurement, logistics, and product management.

You will work with Excel, SAP Business One, and Tableau, cleaning large datasets, benchmarking pricing, and turning manual processes into SOPs. 14-week full-time internship with 40 hrs/week.

Qualifications

• Currently pursuing a degree in Supply Chain, Business, or Finance. Seeking 2027 and 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 handle 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 as they occur.

Skills

Excel

Data analysis

Attention to detail

Communication

Organizational skills

Problem solving

Fast-paced environment

Supplier communication

Education

Pursuing degree in Supply Chain/Business/Finance

Tools

SAP

Tableau

Job description

HexArmor is seeking a Strategic Sourcing Intern for Summer 2027 in Grand Rapids, MI. You will support cost analysis, supplier sourcing, and process documentation across procurement, logistics, and product management.

You will work with Excel, SAP Business One, and Tableau, cleaning large datasets, benchmarking pricing, and turning manual processes into SOPs. 14-week full-time internship with 40 hrs/week.