A/R Data Analyst

The Accounts Receivable Analyst will monitor the aging of customer receivables and pro-actively takes corrective action to resolve open accounts receivable balances in a timely manner. Establishes credibility within the organization and will be decisive while recognizing and supporting the organization’s priorities. All accountabilities are to be fulfilled in a manner consistent with the Company Mission and Values.RESPONSIBILITIES:• Responsible for the creation and management of a resolution process.• Establish and maintain account reconciliations using an analytical approach.• Accomplish monthly team productivity goals and currency objectives.• Responsible for monitoring and maintaining a portfolio of accounts, including but not limited to customer calls, resolution process development, account adjustments, reconciliations and monthly reporting.• Analyze large amounts of data and present analysis effectively.• Requires broad conceptual judgment, initiative, and ability to deal with complex AR aging.• Works directly with customers regarding delinquent payments, investigates discrepancies and makes recommendations for resolution of discrepancies and customer deductions.• Provides professional service with regard to sensitive issues, effectively answering questions and resolving both internal and external customer concerns.• Makes recommendations for collections efforts and escalates issues with customer accounts to Accounting and Sales Management; follows up in a timely manner.• Holds monthly conference calls and communicates effectively with Sales Management regarding status of customer accounts.• Review collection techniques and provide feedback to management.• Knowledge of collection procedures, policies and standards are essential.REQUIREMENTS:• High School diploma or general education degree (GED), Bachelor degree preferred• Minimum of 3 years business to business accounts receivable experience• Basic understanding of 3rd party invoice portal systems.• Intermediate to Advanced knowledge of MS Office products to include Excel, Word, Power Point• Experience with Customer Service, transportation systems, proof of deliveries, shortages, damages and deduction resolution a plus.• Superior analytical, data mining & report creation skills. Excellent Excel skills are necessary to include V look-ups and pivot tables.Job Type: Full-timePay: $20.06 - $30.97 per hourExpected hours: 40 per weekBenefits:• 401(k)• 401(k) matching• Dental insurance• Health insurance• Life insurance• Paid time off• Vision insuranceSchedule:• Monday to FridayApplication Question(s):• What is your compensation requirement? (required)• Will you take a proctored excel test as a requirement of the recruiting process?• This role is hybrid (M and F from home) (T W Th in the office). Does this work for you?Experience:• V-Lookups (excel): 5 years (Required)• SQL: 2 years (Preferred)• Microsoft Excel: 5 years (Required)• Accounts receivable: 4 years (Preferred)Location:• Naperville, IL 60563 (Required)Work Location: Hybrid remote in Naperville, IL 60563