Sales Specialist

Pacific Manufacturing Ohio; Fairfield (OH); On-site; USD 55,000 - 85,000; Full time

Job summary

Pacific Manufacturing Ohio, a tier-one automotive supplier, seeks a Sales Specialist to manage AR functions, invoicing, and regulatory surveys. The role emphasizes retroactive pricing adjustments, data reconciliation, and Excel-driven operations support to ensure seamless sales-to-finance processes.

Ideal candidates bring strong AR background, Excel expertise, and experience with USMCA/FTA or similar regulatory surveys to support Toyota, Mazda, Subaru, and Honda accounts.

Qualifications

• Minimum 3 years in accounting background (Accounting/Finance).
• Advanced proficiency in Microsoft Excel (VLOOKUP/XLOOKUP, Pivot Tables).
• Experience with USMCA/FTA or automotive regulatory surveys preferred.
• Strong data reconciliation and attention to detail.

Responsibilities

• Monthly Sales & Payment Reconciliation: balance accounts monthly and reconcile discrepancies.
• Invoicing & Quotations: generate quotes and invoices for delivered goods.
• Trade & Regulatory Compliance: prepare and submit surveys and regulatory filings (USMCA, AALA, US Content, CAFE, FTA, SPCA).
• Purchase Order & Retroactive Pricing Management: track POs and reconcile retroactive adjustments.
• Data & Operations Support: use advanced Excel to build models and streamline reporting.

Skills

Accounts receivable

Excel

Data analysis

Tools

Excel

Job description

This position is within the Sales Department at Pacific Manufacturing Ohio, Inc., a tier-one Japanese automotive supplier serving companies such as Toyota, Mazda, Subaru, and Honda since 1988. As a Sales Specialist, you will manage critical financial reconciliations, customer invoicing, order tracking, and regulatory trade compliance surveys. The ideal candidate brings a strong accounts receivable foundation, proficiency in handling complex retroactive pricing adjustments, and advanced Microsoft Excel skills to ensure seamless sales-to-finance operations.

Key Responsibilities

• Monthly Sales & Payment Reconciliation: Analyze source data to identify discrepancies between sales amounts and incoming customer payments. Balance accounts monthly to ensure accurate ledger maintenance.
• Invoicing & Quotations: Generate and issue accurate customer quotations and timely invoices for delivered goods and services.
• Trade & Regulatory Compliance: Compile, complete, and submit required customer surveys and regulatory filings, including USMCA, AALA, US Content, CAFE, FTA, and SPCA documentation.
• Purchase Order & Retroactive Pricing Management: Track and manage updated Purchase Orders from customers; calculate, issue, and reconcile retroactive debit and credit adjustments.
• Data & Operations Support: Leverage advanced Microsoft Excel capabilities to build models, reconcile accounts, and streamline sales operations reporting.

Qualifications & Requirements

• Minimum 3 years in accounting background: Educational or professional background in Accounting, Finance, Inside Sales or a related field is required.
• Advanced Excel Skills: Advanced proficiency in Microsoft Excel (e.g., VLOOKUP/XLOOKUP, INDEX/MATCH, Pivot Tables, logical formulas) and functional expertise across the broader Microsoft Office Suite.
• Trade & Regulatory Knowledge: Prior experience handling USMCA, FTA, or automotive/manufacturing compliance surveys is strongly preferred.
• Analytical Precision: Strong analytical and problem-solving skills with high attention to detail in data reconciliation.
• Communication: Clear communication skills for effective coordination with sales teams, accounting departments, and customer representatives.