Sales Specialist

Sales SpecialistRole OverviewThis 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 ResponsibilitiesMonthly 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 & RequirementsMinimum 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.