Collections Analyst II: Excel and Reconciliation Pro

KBW Financial; Bedford (NH); On-site; USD 54,000 - 66,000; Full time

Job summary

KBW Financial Staffing & Recruiting is partnering with a Bedford, NH client to hire a Back Collections Analyst II for a permanent role. This position focuses on timely payments and accurate account management in a collaborative team environment.

The ideal candidate has 1+ year in commercial collections or accounts receivable, strong Excel skills (Pivot Tables, VLOOKUPs, and advanced formulas), and a Bachelor's degree in Accounting or Finance. Salary up to $60,000 with room for experience.

Qualifications

• 1+ year of experience in commercial collections or accounts receivable.
• Strong Excel skills, including Pivot Tables, VLOOKUPs, and advanced formulas.
• Bachelor’s degree in Accounting, Finance, or a related field preferred.

Responsibilities

• Perform daily collections activities and manage customer accounts to ensure timely payments.
• Investigate and resolve billing discrepancies and payment issues.
• Reconcile customer accounts and maintain accurate records.
• Partner cross-functionally with sales, customer service, and finance teams to address account matters.
• Prepare and present account status updates and reporting to internal stakeholders.

Skills

Analytical mindset

Excel proficiency

Education

Bachelor’s degree in Accounting, Finance, or related field

Tools

Pivot Tables

VLOOKUPs

Advanced Excel formulas

Job description

KBW Financial Staffing & Recruiting is partnering with a Bedford, NH client to hire a Back Collections Analyst II for a permanent role. This position focuses on timely payments and accurate account management in a collaborative team environment.

The ideal candidate has 1+ year in commercial collections or accounts receivable, strong Excel skills (Pivot Tables, VLOOKUPs, and advanced formulas), and a Bachelor's degree in Accounting or Finance. Salary up to $60,000 with room for experience.