Sales Analyst

Steel Craft Corp; Town of Hartford (WI); On-site; USD 65,000 - 90,000; Full time

Job summary

Steel Craft Corp. is seeking a Sales Analyst to ensure pricing accuracy and profitability across quotes, contracts and surcharges. You will maintain price files, track margins by customer and part, and enable quotes and renewals with reliable data.

You will collaborate daily with Sales, Estimating, Customer Service, Purchasing and Finance to monitor price realization, load surcharges, and generate dashboards for leadership.

Qualifications

• Bachelor's degree in Finance, Business, Economics, Supply Chain or related field, or equivalent experience.
• 3-5 years in sales analysis, pricing, contract administration or FP&A, preferably in manufacturing.
• Advanced Excel: pivot tables, XLOOKUP/INDEX-MATCH, large data sets, building models from scratch.
• Working knowledge of an ERP system for pricing, order and invoice data.
• Strong attention to detail; you notice when a number is off and chase it down.
• Clear written and verbal communication with Sales, customers' buyers and leadership.

Responsibilities

• Maintain customer price lists, part-level pricing and quote history in the ERP; ensure every order and invoice reflects the current agreed price.
• Support Estimating and Sales on quotes with cost, margin and historical pricing data; flag quotes below target margin.
• Prepare and track annual and ad-hoc price increase proposals, including customer notification letters and effective dates.
• Monitor price realization: compare quoted vs. invoiced pricing and identify leakage from discounts, errors or outdated price files.
• Administer material surcharges and index-based pricing per customer contract terms.
• Calculate and publish surcharge updates on the contractual cadence (monthly, quarterly) and confirm they are loaded and billed correctly.
• Track other pass-throughs such as freight, fuel, energy, tariffs and finishing or coating adders.
• Quantify cost recovery: material cost change vs. surcharge revenue captured, by customer and in total.
• Maintain a central contract repository and tracker: pricing terms, escalators, surcharge mechanisms, payment terms, volume commitments, LTAs and expiration dates.
• Alert Sales to upcoming renewals, re-pricing windows and notice deadlines at least 90 days out.
• Review customer terms and POs for pricing, surcharge and payment-term deviations from our standard terms; escalate exceptions.
• Support RFQ and contract renewal packages with volume, price and margin history.
• Produce recurring reports on sales, margin, price/volume/mix, surcharge recovery and customer profitability.
• Build and maintain dashboards for Sales and leadership.
• Analyze customer and part profitability to identify accounts or parts that need re-pricing, cost reduction or exit.
• Support the annual budget and monthly forecast with pricing and surcharge assumptions.
• Partner with Finance on revenue, credit memos, rebates and pricing-related billing disputes.
• Work with Purchasing to align material cost assumptions with supplier pricing and surcharge timing.
• Document pricing and surcharge procedures and support internal controls over price changes.

Skills

Sales analysis

Pricing analysis

Contract administration

FP&A

Advanced Excel

Attention to detail

Communication

Education

Bachelor's degree in Finance, Business, Economics, Supply Chain or related field

Tools

Power BI

SQL

Epicor Kinetic

Job description

The Sales Analyst owns the accuracy and profitability of how we price, surcharge and contract with customers. In a contract metal fabrication business, raw material swings, freight and energy costs can erase margin within a quarter; this role makes sure those costs are captured in our pricing and recovered on every invoice.

You will maintain customer price files and contracts, administer material and other surcharges, analyze margin by customer and part, and give Sales and leadership the data they need to quote, negotiate and renew with confidence. You will work daily with Sales, Estimating, Customer Service, Purchasing and Finance.

Responsibilities

• Maintain customer price lists, part-level pricing and quote history in the ERP; ensure every order and invoice reflects the current agreed price.
• Support Estimating and Sales on quotes with cost, margin and historical pricing data; flag quotes below target margin.
• Prepare and track annual and ad-hoc price increase proposals, including customer notification letters and effective dates.
• Monitor price realization: compare quoted vs. invoiced pricing and identify leakage from discounts, errors or outdated price files.

Surcharges and cost pass-through

• Administer material surcharges and index-based pricing (e.g., CRU, AMM, LME, mill price sheets for steel, stainless and aluminum) per customer contract terms.
• Calculate and publish surcharge updates on the contractual cadence (monthly, quarterly) and confirm they are loaded and billed correctly.
• Track other pass-throughs such as freight, fuel, energy, tariffs (e.g., Section 232) and finishing or coating adders.
• Quantify cost recovery: material cost change vs. surcharge revenue captured, by customer and in total.

Contracts and customer agreements

• Maintain a central contract repository and tracker: pricing terms, escalators, surcharge mechanisms, payment terms, volume commitments, LTAs and expiration dates.
• Alert Sales to upcoming renewals, re-pricing windows and notice deadlines at least 90 days out.
• Review customer terms and POs for pricing, surcharge and payment-term deviations from our standard terms; escalate exceptions.
• Support RFQ and contract renewal packages with volume, price and margin history.

Analysis and reporting

• Produce recurring reports on sales, margin, price/volume/mix, surcharge recovery and customer profitability.
• Build and maintain dashboards (Power BI or similar) for Sales and leadership.
• Analyze customer and part profitability to identify accounts or parts that need re-pricing, cost reduction or exit.
• Support the annual budget and monthly forecast with pricing and surcharge assumptions.

Cross-functional support

• Partner with Finance on revenue, credit memos, rebates and pricing-related billing disputes.
• Work with Purchasing to align material cost assumptions with supplier pricing and surcharge timing.
• Document pricing and surcharge procedures and support internal controls over price changes.

Qualifications

• Bachelor's degree in Finance, Business, Economics, Supply Chain or a related field, or equivalent experience.

Required Skills

• 3-5 years in sales analysis, pricing, contract administration or FP&A, preferably in manufacturing.
• Advanced Excel: pivot tables, XLOOKUP/INDEX-MATCH, large data sets, building models from scratch.
• Working knowledge of an ERP system for pricing, order and invoice data.
• Strong attention to detail; you notice when a number is off and chase it down.
• Clear written and verbal communication with Sales, customers' buyers and leadership.

Preferred Skills

• Experience in metal fabrication, stamping, machining or another B2B contract manufacturing environment.
• Familiarity with metals pricing indices (CRU, AMM, LME) and surcharge mechanisms.
• Experience with Epicor Kinetic or a comparable ERP.
• Power BI, SQL or similar reporting tools.
• Exposure to contract terms: LTAs, escalation clauses, payment terms, rebates.