Job Description
The Contract Channel Sales Analyst plays a critical role in supporting the Contract Channel business by managing customer quote administration, pricing maintenance, operational issue resolution, forecasting support, and new product implementation. This position serves as a key liaison among National Account Managers, Builder Account Managers, Pricing, Product Line Management, Supply Chain Customer Service, and Contract Customers to ensure accurate pricing, operational efficiency, and forecast visibility across the channel.
The ideal candidate combines strong analytical skills, operational discipline, and customer focus to support major accounts including Ferguson, HD Supply, Grainger, Lowe's Pro Supply, Costco, The Home Depot, PC Richard & Son, Clayton Homes, and other strategic contract customers.
Key Responsibilities:
Quote & Pricing Administration
Create, maintain, and manage customer quotes within company quoting systems.
Support quote development and implementation for key national accounts, including: Ferguson
Costco
Lowe's Pro Supply
The Home Depot
PC Richard & Son
Additional Contract Channel customers as needed
Ensure all customer quotes are accurately loaded, maintained, and updated based on approved pricing strategies.
Monitor quote expiration dates and coordinate timely renewals.
Validate pricing accuracy and resolve quote discrepancies.
Pricing Management & Maintenance
Partner closely with the Pricing Team to: Maintain current ABD and Ferguson pricing files.
Execute customer-specific price loads.
Verify pricing integrity across systems.
Support annual and mid-year pricing updates.
Investigate and resolve customer pricing discrepancies and rebate-related issues.
Maintain pricing documentation and audit trails to ensure compliance and consistency.
Data and reporting
Advanced Excel: PivotTables, XLOOKUP/INDEX-MATCH, Power Query, and building and auditing complex multi-sheet models
Working SQL for pulling and joining data from sales, pricing, and freight sources
Power BI for dashboards and recurring reports (DAX a plus)
Experience building repeatable monthly reporting packages, such as business reviews, with clear charts and executive-ready summaries
AI and automation
Hands-on experience with Microsoft Copilot across Excel, PowerPoint, Word, Outlook, and Teams (drafting formulas, summarizing data, generating narrative and slides)
Strong prompt-writing skills: able to turn a business question into a clear, structured prompt and to validate and correct the output
Experience using AI to automate manual reporting steps, such as data cleanup, variance commentary, and report refreshes
Familiarity with Power Automate or similar tools for workflow automation
Ability to evaluate AI output critically, checking accuracy against source data before it reaches leadership
Analytical and business
Comfort analyzing pricing, margin, freight, and volume trends and turning them into recommendations
Ability to translate data into a clear story for sales leaders, with concise written and verbal communication
Strong attention to detail and data integrity, including documenting formulas and processes so reports are repeatable
Preferred
Experience in building products, appliances, distribution, or B2B sales environments
Exposure to CRM data (Salesforce or similar)
Experience training or coaching colleagues on AI tools
Contract Operations Support
Manage daily operational activities supporting Contract Channel customers.
Monitor and clear IDOCs and other system exceptions impacting order flow.
Maintain and work an incompletion log to resolve outstanding order and customer issues.
Address customer expected pricing concerns through coordination with pricing, customer service, and sales teams.
Identify process improvements to reduce operational disruptions and improve customer satisfaction.
New Product Introduction (NPI) Management
Collaborate with Product Line Management and Sales teams to ensure new products are incorporated into…