Pricing & Margin Analyst – Metal Fabrication

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

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.