Job Description

Accounting Specialist II (Systems & Analytics)

SUMMARY

We are seeking an Accounting Specialist II to handle core accounting functions such as Accounts Payable (A/P), Accounts Receivable (A/R), general ledger support, and month-end support. In this role you will support our accounting team as the primary "power user" for our ERP and ancillary systems. You will also serve as the department's go-to resource for system troubleshooting, reporting, and process improvements and liaison with the IT department for resolutions.

ESSENTIAL DUTIES AND RESPONSIBILITIES

• General Ledger & Financial Operations (~40%)
  • Assist with month-end, year-end, and audit closing processes, including journal entries and account reconciliations.
  • Analyze trends in A/P and A/R, manage received-not-invoiced reconciliations, intercompany billings, and credit/aging holds.
  • Process ledger entries, including cash applications, expense recaps, and credit card/payroll journal entries.
  • Maintain database integrity within Customer and Supplier maintenance screens (credit terms, tax status, limits).
• Systems & Process Support (~40%)
  • Serve as the Accounting department’s primary "power user" and liaison for Epicor ERP and related financial software; assist teammates with day-to-day system troubleshooting, questions, and optimization.
  • Identify opportunities to streamline manual accounting tasks using system tools, advanced Excel formulas, and automated workflows.
  • Create, update, and maintain system-generated reports and queries to support financial analysis and department reporting.
  • Partner with IT and software vendors on system implementations, system updates, testing new features, and maintaining user access and data integrity.
  • Train accounting staff on Epicor functionality and maintain clear, up to date procedures.
• Departmental Support (~20%)
  • Provide cross-functional backup for core A/P, A/R, and expense processing functions to maintain continuous coverage in a multi-site environment.
  • Assist with internal/external audit documentation and support continuous improvement projects as needed.

QUALIFICATIONS & SKILLS

Education & Experience

• Bachelor’s degree in Accounting, Finance, or Business Information Systems preferred (or equivalent combination of education and experience).
• 3 to 5 years of core accounting experience (A/P, A/R, GL, reconciliations) in a corporate or manufacturing setting.

Technical & Analytical Aptitude

• Solid hands-on experience using an ERP system.
• Excel: Demonstrated ability to build, audit, and maintain complex functional models. Must be proficient with lookup logic (XLOOKUP, INDEX/MATCH), nested conditionals (SUMIFS, IFS/AND/OR), array functions, data cleaning functions, pivot tables, and pivot table functions.
• Systems Aptitude: Strong problem-solving ability with a natural curiosity for how systems work, database structures, and workflow automation.
• Reporting Skills: Familiarity with report building, SQL, SSRS, or business intelligence tools (e.g., Power BI) is a strong plus, but willingness to learn is key.

BENEFITS

• Health Benefits: Medical, Dental, and Vision
• Wellness Program
• Paid Time Off (PTO) & Paid Holidays
• 401(k) with Company Match
• Bonus Plan
• Tuition Reimbursement
• Short-Term & Long-Term Disability (Company-paid)
• Life Insurance (Company-paid)