Job Title: Procurement Data Analyst
Location: Phoenixville, PA (On-site Monday–Thursday; Hybrid/Remote flexibility on Fridays)
Type: Contract-to-Hire
Team: Procurement Shared Services
Overview:
We are seeking a detail-oriented Procurement Data Analyst to join our Procurement Shared Services team in a contract-to-hire role. This individual will play a key role in rebuilding and optimizing reporting processes, driving automation, and delivering insightful data analysis to support procurement operations. Ideal candidates will have strong Excel and database skills, a passion for solving problems through automation, and a keen eye for process improvement.
Key Responsibilities:
- Rebuild and enhance key procurement reports and dashboards that were impacted by a recent system migration, ensuring improved structure, accuracy, and usability
- Develop, maintain, and optimize user-friendly reports and dashboards with a focus on KPIs for buying teams
- Automate workflows using Power Automate and Excel VBA Macros
- Perform deep-dive data analysis to identify anomalies, root causes, and improvement opportunities
- Collaborate with vendors and internal teams to resolve data issues and streamline payment-to-purchase workflows
- Manage and fine-tune reporting tools and databases, including Analyze360
- Run and distribute reports multiple times daily and follow up on performance metrics
- Support supplier interactions with timely reporting and performance analysis
- Organize procurement data in systems such as Oracle, SAP, or similar ERP tools
- Assist in developing new tools and automations, such as pulling email data to network drives
What We're Looking For:
- Strong proficiency in Excel (including VBA Macros), Power Automate, and database management
- Experience with procurement operations and data-heavy environments
- Excellent problem-solving and presentation skills
- Ability to communicate findings clearly and create reports that are easy to interpret
- Comfortable interacting with suppliers and internal stakeholders
- Familiarity with Oracle/SAP or similar ERP systems
#LI-AL1