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. Requirements 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) #J-18808-Ljbffr