Hybrid Procurement Associate — Excel & Data Skills

Harvard University; Massachusetts; Hybrid; USD 57,000 - 78,000; Full time

Benefits offered by this job

Tuition assistance

Gym reimbursements

Parental leave

Paid time off

Retirement plans

Job summary

Harvard University seeks a talented Procurement Assistant to perform accounting, customer service, and office support within the Wyss Institute. Reporting to the Procurement Manager, you will manage purchase orders, verify requisitions, and support data-driven decisions using Excel and SQL.

This on-site role requires 3–4 days per week on campus with some remote work options; visa sponsorship is not provided. applied benefits and 35-hour weeks are noted.

Qualifications

• Two+ years of office experience required. Proficiency in Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, and data analysis functions) is required.
• Bachelor’s degree preferred. 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 offices to provide quality assurance on purchasing transactions.
• Maintain proper documentation to verify that all requisitions comply with University 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 for orders as necessary.
• Work with suppliers to confirm receipt and status update of orders, investigate price/quantity discrepancies, coordinate the replacement, credit, and return of unsatisfactory deliveries; ensure completion of the procure-to-pay cycle; and elevate issues when needed.
• Leverage advanced Microsoft Excel skills (pivot tables, VLOOKUP/XLOOKUP, data modeling) and database querying (SQL or equivalent) to analyze procurement data, generate reports, track spending trends, and support data-driven decision making; ability to work independently with large datasets is essential.
• Serve as a trained backup for the reimbursements team, cross-trained in the reimbursement process, policies, and procedures; this role is expected to step in seamlessly during periods of high volume or staff absence to ensure continuity of operations

Skills

Advanced Excel

SQL querying

Customer service

Data analysis

Attention to detail

Education

Bachelor’s degree preferred

Tools

Oracle

Jaggaer

SQL

Job description

Harvard University seeks a talented Procurement Assistant to perform accounting, customer service, and office support within the Wyss Institute. Reporting to the Procurement Manager, you will manage purchase orders, verify requisitions, and support data-driven decisions using Excel and SQL.

This on-site role requires 3–4 days per week on campus with some remote work options; visa sponsorship is not provided. applied benefits and 35-hour weeks are noted.