Procurement Intern: Fast-Paced Supply Chain & Data Analytics

Barnes Aerospace; East Granby (CT); On-site; USD 2,066,000 - 3,031,000; Part time

Job summary

Barnes Aerospace East Granby is offering a Procurement Intern position to actively support day-to-day purchasing for direct, indirect, and services. You will analyze spend, supplier performance, and market trends while collaborating with Buyers and cross-functional teams.

The role emphasizes ERP data accuracy, RFQ support, and continual process improvement. Ideal for a rising junior or senior pursuing a related bachelor's degree, with strong Excel and Power BI skills.

Qualifications

• Strong verbal and written communication skills.
• Ability to work in a business environment.
• Ability to schedule and organize time and tasks effectively.
• Ability to work in a challenging and schedule driven environment.
• Possess analytical and technical skills required to understand business practices and recommend proper automation opportunities.
• Familiarity with intermediate (V-lookup/Pivot tables) and advanced (What-If, Power Query) Excel functions.
• Familiarity with basic Power BI functions and ability to learn Articulate 360 software for standard work training creation.
• Must be an innovator and embrace lean enterprise, principles and practices.

Responsibilities

• Support the Procurement team with day-to-day purchasing activities for direct material, outside services, and indirect requirements.
• Analyze purchasing data and prepare reports on PO placement, late-to-release activity, supplier on-time delivery, open-order status, spend, PPV, RFQs, and market-index trends.
• Assist Buyers with supplier follow-up, including obtaining order acknowledgments, updated delivery commitments, pricing, lead times, and documentation.
• Support RFQ and sourcing activities by compiling bid packages, comparing supplier quotations, evaluating cost/lead-time tradeoffs, and maintaining sourcing records.
• Help maintain accurate supplier, pricing, lead-time, and PO data within ERP systems and related procurement trackers; identify and correct data-integrity issues.
• Assist with supplier performance reporting, including supplier scorecards, corrective-action follow-up, and preparation for supplier business reviews.
• Support maintenance of the Approved Supplier List (ASL), supplier onboarding documentation, and supplier portal activities in coordination with Quality and other cross-functional teams.
• Support procurement standard work, training materials, work instructions, and the department skills matrix.
• Partner with Planning, Operations, Quality, Engineering, Finance, IT, Legal, and HR on assigned supply-chain initiatives.
• Complete assigned internship projects, analyze findings, recommend improvements, and present results to Procurement leadership.
• Perform other duties as assigned.

Skills

Strong communication

Analytical skills

Organizational skills

Lean thinking

Education

Rising junior or senior pursuing bachelor's degree

Tools

Excel

Power BI

Articulate 360

ERP systems

Job description

Barnes Aerospace East Granby is offering a Procurement Intern position to actively support day-to-day purchasing for direct, indirect, and services. You will analyze spend, supplier performance, and market trends while collaborating with Buyers and cross-functional teams.

The role emphasizes ERP data accuracy, RFQ support, and continual process improvement. Ideal for a rising junior or senior pursuing a related bachelor's degree, with strong Excel and Power BI skills.