OTC Collections Analyst

Avispa Technology•Louisville, KY

5d•Onsite

About The Position

An OTC Collections Analyst will manage a local TV station advertising collections portfolio, resolve discrepancies, optimize cash flow, and minimize bad debt risk. The portfolio covers local TV stations and ranges from $10 million to $125 million across large and mid-size advertising agencies. The role involves collecting aged receivables, maintaining customer contact records, following up on payments, and meeting cash, aging, DSO, and overdue-percentage KPIs. The analyst will handle a high volume of customer discrepancies across approximately 30,000 line items shared by a team of four. The position works with advertising sales and other stakeholders to resolve issues, prepares discrepancy reports and refund requests, and responds to requests for statements, invoice copies, supporting documentation, and account reconciliations. It also coordinates with other departments and teams at other sites, including South America, to investigate payment delays and determine appropriate actions. The role prepares and analyzes Excel reports, including discrepancy reports, cash packages, monthly aging reports, month-end cash forecasts, and routine management reports. The analyst participates in aging reviews, supports month-end close with order-to-cash hubs and controllership teams, applies cash during critical periods, manages accounts receivable ledgers, assists the cash application team with reconciliations, and provides explanations of outstanding AR balances to auditors. This is a W2, 9-month assignment at an onsite worksite in Louisville, Kentucky. The schedule is 40 hours per week, 9:00 AM to 6:00 PM. Hourly pay is $25. Group medical, dental, vision, life, retirement savings, and PSL are listed.

Requirements

0–3+ years of relevant experience in accounts receivable, credit, collections, or billing.
Strong knowledge of Microsoft Excel and Word.

Nice To Haves

Bachelor’s degree in Business, Accounting, Finance, or a related field.
Experience working with enterprise-size organizations.
ERP or financial system experience, such as SAP or Oracle.
Collections experience.
Media industry experience.
Bilingual in Spanish.
General knowledge of accounting principles.

Responsibilities

Manage an advertising collections portfolio for local TV stations, contacting customers to collect aged receivables and following up to ensure payment within terms.
Maintain records of customer contacts and meet KPIs for cash targets, aging, DSO, and percentage overdue.
Manage and resolve a high volume of customer discrepancies across approximately 30,000 line items shared within a team of four.
Communicate with advertising sales and stakeholders, prepare discrepancy reports for sales management, and prepare customer refund requests.
Respond to requests for statements, invoice copies, backup documentation, and account reconciliations.
Coordinate with other departments and teams at other sites, including South America, to investigate payment delays and determine appropriate actions such as credit holds or payment plans.
Escalate changes in customer payment trends and advise the Credit department about accounts experiencing financial difficulty.
Prepare and analyze reports in Excel, including discrepancy reports, cash packages, monthly aging reports, month-end cash forecasts, and routine management reports.
Organize and participate in periodic aging reviews.
Support month-end close with order-to-cash hubs and controllership teams, including applying cash during critical periods.
Manage accounts receivable ledgers and support the cash application team with reconciliations.
Provide backup explanations of outstanding AR balances to internal and external auditors.