Procurement Analyst & Data-Driven Ops (Hybrid)

Harvard University; Boston (MA); Hybrid; USD 55,000 - 75,000; Full time

Benefits offered by this job

Tuition assistance and reimbursement

Gym reimbursements

Commuter benefits

Job summary

The Wyss Institute at Harvard University is seeking a collaborative Procurement Assistant to support accounting, customer service, and office operations. The role is based at a Harvard campus location with 3–4 days on site and some remote work options, reporting to the Procurement Manager.

You will leverage advanced Excel skills and SQL to analyze procurement data, generate reports, and ensure quality in purchasing; you may serve as a backup to the reimbursements team during peak periods.

Qualifications

• Two or more years of office experience required; Excel proficiency (pivot tables, VLOOKUP/XLOOKUP, data analysis) is required.
• Hands-on experience querying databases using SQL or equivalent tools is highly preferred.
• Familiarity with financial and purchasing systems (e.g., Oracle, Jaggaer) is a strong plus.

Responsibilities

• Interface with customers, vendors, and Central Administration finance to ensure QA on purchasing transactions.
• Maintain documentation to verify requisitions comply with University policies.
• Ensure proper account code selection and order information accuracy.
• Generate and place purchase orders, create receipts, and maintain proof of delivery docs.
• Coordinate with suppliers on receipt status, price/quantity discrepancies, replacements, credits, and returns; complete procure-to-pay cycle.

Skills

Advanced Excel

Pivot tables

VLOOKUP/XLOOKUP

Data analysis

SQL querying

Customer service

Cross-functional collaboration

Education

Bachelor’s degree preferred

Tools

Oracle

Jaggaer

Microsoft Excel

Job description

The Wyss Institute at Harvard University is seeking a collaborative Procurement Assistant to support accounting, customer service, and office operations. The role is based at a Harvard campus location with 3–4 days on site and some remote work options, reporting to the Procurement Manager.

You will leverage advanced Excel skills and SQL to analyze procurement data, generate reports, and ensure quality in purchasing; you may serve as a backup to the reimbursements team during peak periods.