OTC Collections Analyst

Avispa-Technology-4; Louisville (KY); On-site; USD 39,000 - 52,000; Full time

Job summary

A leading digital streaming network seeks an OTC Collections Analyst to manage a local TV station advertising collections portfolio, resolving discrepancies, optimizing cash flow, and minimizing bad debt risk. The role is onsite in Louisville, KY (40223) with a 9-month assignment and 40 hours/week.

Responsibilities include overseeing large portfolios, communicating with agencies, and performing detailed reporting in Excel.

Qualifications

• 0-3+ years of relevant experience in accounts receivable, credit, collections, or billing.
• Bachelor's degree in Business, Accounting, Finance, or related field is preferred.
• Strong knowledge of Microsoft Excel and Word.
• Experience with enterprise-size organizations is preferred.
• ERP or financial system experience, such as SAP or Oracle, is preferred.
• Collections experience is preferred.
• Media industry experience is preferred.
• Bilingual in Spanish is preferred.
• General knowledge of accounting principles is preferred.

Responsibilities

• Oversee an ad sales collections portfolio for local TV stations ranging from $10M to $125M across ad agencies.
• Contact customers to collect aged receivables and maintain records of contacts.
• Coordinate with other departments and sites to resolve payment delays and determine actions.
• Prepare discrepancy reports, refund requests, and documentation for audits.
• Support month-end close with AR ledgers and reconciliations.

Skills

Bilingual in Spanish

Education

Bachelor's degree in Business, Accounting, Finance, or related field

Tools

Microsoft Excel

Microsoft Word

SAP

Oracle

Job description

OTC Collections Analyst VIAJP00001582

• Hourly pay: $25/hr
• Worksite: Leading digital streaming network (Louisville, KY 40223 - Onsite)
• W2 Employment, Group Medical, Dental, Vision, Life, Retirement Savings Program, PSL
• 40 hours/week, 9 Month Assignment

A leading digital streaming network seeks an OTC Collections Analyst to manage a local TV station advertising collections portfolio, resolving discrepancies, optimizing cash flow, and minimizing bad debt risk.

OTC Collections Analyst Responsibilities:

• Oversee an ad sales collections portfolio for local TV stations ranging from $10M to $125M across large and mid-size ad agencies, contacting customers to promptly collect aged receivables, keeping records of all customer contacts, following up so customers pay within terms, and meeting KPIs such as cash targets, aging, DSO, and percentage overdue.
• Manage and resolve a high volume of customer discrepancies across roughly 30,000 line items shared within a team of four, communicating with ad sales and stakeholders, preparing discrepancy reports for sales management, preparing customer refund requests, and supporting ad hoc requests for statements, invoice copies, backup documentation, and account reconciliations.
• Work with other departments, including teams at other sites such as South America, to understand the causes of payment delays and determine the right course of action, such as credit holds or payment plans, escalating changes in customer payment trends and advising the Credit department of accounts experiencing financial difficulty.
• Run, prepare, and analyze reports in Excel using formulas, VLOOKUPs, pivot tables, and charts, including discrepancy reports, cash packages, monthly aging reports, month-end cash forecasts, and routine management reports, and 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, support the cash application team with reconciliations, provide backup explanations of outstanding AR balances to internal and external auditors.

OTC Collections Analyst Qualifications:

• 0-3+ years of relevant experience in accounts receivable, credit, collections, or billing.
• Bachelor's degree in Business, Accounting, Finance, or a related field is preferred.
• Strong knowledge of Microsoft Excel and Word.
• Experience working with enterprise-size organizations is preferred.
• ERP or financial system experience, such as SAP or Oracle, is preferred.
• Collections experience is preferred.
• Media industry experience is preferred.
• Bilingual in Spanish is preferred.
• General knowledge of accounting principles is preferred.

Shift:

• 9:00 AM to 6:00 PM.

(H)