Purchasing Data Specialist- Remote

Title: Purchasing Data Specialist (Hospital) Duration: 6 months Rate: $35-$40/hr 100% Remote!

Job Description

• Our client is seeking a detail-oriented Data Analyst to support a large ERP implementation by preparing and transforming Accounts Payable (AP) and Purchase Order (PO) data for migration into the new ERP platform.
• This is not an accounting role and does not require healthcare experience.
• The ideal candidate is highly proficient in Excel, enjoys working with large datasets, and has enough AP knowledge to understand the relationship between invoice headers and purchase order line items.
• The analyst will collect supplier data, standardize multiple file formats, aggregate purchasing information, and prepare clean, accurate datasets for the implementation team responsible for loading data into the new ERP.

Scope of Work

• Identify and prioritize non-acute suppliers using accounts payable (AP) data to determine where purchasing activity exists
• Acquire, validate, and normalize supplier data into a consistent format suitable for analysis.
• Assess data completeness by identifying suppliers, facilities, and spend categories that are not currently represented in the available data.
• Develop baseline analytics that identify total spend, supplier distribution, contract compliance opportunities, and purchasing patterns across the non-acute continuum.
• Provide recommendations to improve purchasing visibility and establish a reliable data foundation in advance of the planned Infor CloudSuite deployment
• Conduct regular project status meetings with stakeholders to review supplier outreach progress, data acquisition status, and key findings.
• Deliver a final summary outlining data coverage, remaining gaps, recommendations for ongoing data acquisition, and considerations to support a successful non-acute ERP transition.

Deliverables

• Comprehensive non-acute supplier inventory.
• Consolidated non-acute spend data set.
• Gap analysis identifying missing suppliers and spend.
• Executive summary of findings and recommendations.

Required skills: Excel data manipulation for data aggregation and manipulation and experience with AP systems.

• Pivot Tables
• VLOOKUP/XLOOKUP
• Data manipulation
• Sorting
• Filtering
• Data cleansing
• Consolidating multiple worksheets
• Working with large datasets
• CSV file conversion
• Data formatting
• Data validation
• Data quality analysis

Candidates should understand:

• Invoice headers
• Purchase Orders
• Vendor invoices
• Basic AP terminology