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)