Purchasing Analyst

Position Overview:

The Corporate Purchasing Analyst supports national procurement initiatives by developing analytical tools, managing rebate submission processes, and aiding system optimization. Familiarity with Rebate submission software and Construction ERP is a plus. Proficiency in advanced Excel, SQL, Power BI, and Microsoft 365 tools is highly desirable.

Key Responsibilities:

Rebate & Data Management

· Manage and implement quarterly Rebate submittals through direct collaboration with Division Purchasing teams.

· Collaborate with sourcing managers to design rebate programs aligned with RFPs and vendor negotiations.

· Perform rebate tracking, analysis, and submission, ensuring timely and accurate data.

Analytical Reporting & Tools

· Develop and maintain advanced Excel models using Power Query, Power Pivot, Pivot Tables, and complex formulas.

· Utilize SQL select statements to query data and support custom reporting.

· Design and publish dashboards to monitor rebate performance, vendor compliance, and purchasing KPIs.

· Create and analyze spending and rebate performance reports.

· Drive ad hoc analysis of product penetration across the enterprise.

· Assist in the creation and implementation of process or system enhancements to improve efficiency and accuracy.

· Partner with IT and operations teams to define business solutions through data.

*Other duties as assigned.

Qualifications:

· Bachelor’s degree in Business, Supply Chain, Finance, Data Analytics, or a related field.

· 2 years of experience in construction, purchasing, rebate analysis, or supply chain data management.

· Expertise in Microsoft Products, including Office 365 and Excel, including Power Query, Power Pivot, Pivot Tables, and advanced formulas is preferred.

· Familiarity with Microsoft Power Platform, including Power Bi, Power Automate, and Power Apps are desirable.

· Working knowledge of SQL (Select statements) and relational data querying is a plus.

· Familiarity with RebatePros is highly preferred.

· Strong attention to detail and ability to manage multiple deadlines.

· Excellent written and verbal communication skills.

· Self-starter with the ability to work independently and collaboratively across teams.