Hybrid Procurement Assistant - Excel and Data Insights

Wyss Institute at Harvard University; Boston (MA); Hybrid; USD 60,000 - 80,000; Full time

Benefits offered by this job

Generous paid time off

Medical, dental, and vision insurance

Tuition assistance and reimbursement

Retirement plans

Job summary

Wyss Institute at Harvard University is seeking a Collaborative Procurement Assistant to handle diverse accounting, customer service, and office support duties within the procurement function. The role reports to the Procurement Manager and is based at a Harvard campus location with 3–4 days on site and some remote work options.

You will interface with customers and vendors, ensure compliance with policies, generate purchase orders, and use advanced Excel and SQL to analyze procurement data for

Qualifications

• Two or more years of office experience required. Proficiency in Microsoft Excel (including pivot tables, VLOOKUP/XLOOKUP, and data analysis functions) are required.
• Bachelor’s degree preferred. Hands‑on experience querying databases using SQL or equivalent tools are highly preferred.

Responsibilities

• Interface with customers, vendors, and Central Administration finance offices to provide quality assurance on purchasing transactions.
• Maintain proper documentation to verify requisitions comply with policies and procedures.
• Ensure proper account code selection and usage and assess order information for completeness and accuracy.
• Generate and place purchase orders, create electronic receipts and maintain required proof of delivery documentation.
• Work with suppliers to confirm receipt and status updates, investigate discrepancies, and coordinate returns and credits.
• Analyze procurement data using Excel and SQL to generate reports and track spending trends.
• Serve as a trained backup for the reimbursements team and cover related processes when needed.

Skills

Advanced Excel (Pivot Tables, VLOOKUP,

Customer service

Data analysis

Education

Bachelor's degree preferred

Tools

SQL

Oracle

Jaggaer

Job description

Wyss Institute at Harvard University is seeking a Collaborative Procurement Assistant to handle diverse accounting, customer service, and office support duties within the procurement function. The role reports to the Procurement Manager and is based at a Harvard campus location with 3–4 days on site and some remote work options.

You will interface with customers and vendors, ensure compliance with policies, generate purchase orders, and use advanced Excel and SQL to analyze procurement data for