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.
- Identify and prioritize non-acute suppliers using Premier Health's accounts payable (AP) data to determine where purchasing activity exists outside of Medline.
- Engage identified suppliers to obtain detailed purchasing data (item-level utilization where available) for Premier Physicians Network (PPN) and other non-acute entities.
- Acquire, validate, and normalize supplier data into a consistent format suitable for analysis.
- Leverage the existing Medline Distribution Data Feed (DDS) to incorporate Medline purchasing into the overall non-acute data set.
- 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 for PPN.
- Conduct regular project status meetings with Premier Health 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.
- Comprehensive non-acute supplier inventory.
- Consolidated non-acute spend data set.
- Gap analysis identifying missing suppliers and spend.
- Executive summary of findings and recommendations.
- Readiness assessment to support the PPN Infor CloudSuite implementation in early 2027.
- Candidates do not need to be AP experts.
- Hiring Manager: "On a scale of 1–10, they only need to be around a 4 or 5."
- Invoice headers
- Purchase Orders
- Vendor invoices
- Basic AP terminology
- The hiring manager emphasized that Excel proficiency is more important than AP expertise, as advanced AP concepts can be learned on the job.
- Basic Accounts Payable knowledge
- Understanding of Purchase Orders
- SQL
- Database programming
- VBA/Macros
- Healthcare industry experience
- Product knowledge
- Highly organized
- Detail-oriented
- Customer service focused
- Comfortable following up with vendors
- Able to manage multiple priorities
- Strong written and verbal communicators
- Self-directed and dependable
#LI-Remote
