Procurement Data Analyst

Responsibilities

• Extract data from multiple sources, validate completeness and accuracy, identify inconsistencies, and flag pricing or data variances for resolution.
• Load and maintain supplier price books in our materials platform, including reformatting incoming supplier files and manually rebuilding matrix-format price books when necessary.
• Build and maintain a single standardized name for every item Chaparral purchase, working with operations and procurement to establish consistent item descriptions across suppliers, purchase orders, price books, and systems.
• Work directly with suppliers to collect pricing files, issue Chaparral's standard item templates, and load completed pricing against standardized item names.
• Develop and execute standard and custom reports, dashboards, and presentations to track procurement KPIs, supplier performance, spend, pricing, budgets, forecasts, and targets.
• Maintain accurate and current pricing for project buyouts so procurement negotiations are based on a verified pricing baseline.
• Build and run reporting that compares invoiced pricing to contracted price book pricing and provides procurement with actionable reports to identify and pursue supplier credits.
• Establish and maintain tracking for supplier lead times and on-time delivery by supplier and branch, publishing results on a defined schedule.
• Build and maintain supplier scorecards measuring pricing accuracy, delivery performance, responsiveness, and overall service.
• Maintain reporting on average lead time, on-time delivery, and open packing slips for branch and project managers.
• Analyze spending patterns by supplier, category, branch, and entity; identify regional pricing differences; assess supply and demand risks; and identify cost-saving opportunities.
• Refresh monthly spending analysis and provide procurement and leadership with actionable insights into purchasing trends and supplier performance.
• Work closely with buyers, branch teams, operations, suppliers, product/category managers, and other stakeholders to improve data workflows and ensure procurement systems support business needs.
• Reconcile the materials platform against the ERP, including open purchase orders, committed materials, closed projects, and unmatched invoices.
• Maintain data integrity across procurement systems and establish processes to ensure pricing and item information remains current.
• Develop and maintain dashboards and reports that provide procurement and leadership with visibility into pricing, spending, supplier performance, and purchasing trends.
• Support procurement initiatives by providing accurate data, historical purchasing information, pricing analysis, and supplier performance insights.

• 2-4 years of experience in an analyst role within procurement, supply chain, finance, construction operations, or a related field.
• Advanced Excel skills, including pivot tables, lookup formulas, data cleanup, and working with large and inconsistent data files.
• Experience using AI tools to improve analysis, reporting, data cleanup, or business processes.
• Experience with ERP/MRP systems and the ability to navigate purchasing, inventory, and financial data.
• Strong analytical and problem-solving skills.
• Strong attention to detail and accuracy when managing high-volume, data-heavy workloads.
• Ability to validate data from multiple sources and identify discrepancies or trends.
• Strong organizational skills with the ability to manage recurring reporting and data maintenance deadlines.
• Persistence and accountability to investigate and resolve data mismatches rather than work around them.
• Ability to communicate effectively with suppliers, buyers, branch personnel, and operations teams.
• Ability to turn complex data into clear, actionable information for both procurement teams and leadership.
• Experience with supplier scorecards, spend analysis, sourcing analytics, or procurement reporting.
• Bachelor's degree in supply chain, Business, Finance, Analytics, or a related field. (Preferred but not required)