Accounting Specialist II (Systems & Analytics)

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

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)