Purchasing Data Specialist- Remote

Title: Purchasing Data Specialist (Hospital)Duration: 6 monthsRate: $35-$40/hr100% Remote!Job DescriptionOur 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 WorkIdentify and prioritize non-acute suppliers using accounts payable (AP) data to determine where purchasing activity existsAcquire, 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 deploymentConduct 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.DeliverablesComprehensive 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 TablesVLOOKUP/XLOOKUPData manipulationSortingFilteringData cleansingConsolidating multiple worksheetsWorking with large datasetsCSV file conversionData formattingData validationData quality analysisCandidates should understand:Invoice headersPurchase OrdersVendor invoicesBasic AP terminology