Customer Contract Admin Analyst (collection oraccount reconciliation,VLookup ,Pivot tables Exp Req)

Location: San Diego, CA • Duration: 12 months • Hours: 40/week • Shift: 7:30 AM–4:00 PM or 8:00 AM–4:30 PM • Employment Type: W2 Contract (US Citizens or Green-Card holders only)

About the Role

We are seeking an entry-level Customer Contract Admin Analyst to support a Medical Device Company’s Accounts Receivable operations. The role is heavy on customer support, analytical thinking, and clear communication of complex issues. Candidates must be local to the San Diego area and demonstrate long-term staying power.

Responsibilities

• Monitor accounts receivable balances and perform collection functions on assigned accounts.
• Resolve customer issues related to non-payment; conduct payment negotiation and reconcile accounts as needed.
• Escalate accounts per established protocol and collaborate with Contracts, Credit, Billing, Database, Asset Management, Reconciliation, and Accounts Receivable teams.
• Collect customer payments in accordance with due dates; document issues in SharePoint/SAP notes.
• Negotiate payment plans on delinquent accounts and provide timely follow-up on payment arrangements.
• Review and monitor assigned accounts and collections reports; complete delinquent-account reports by deadlines.
• Monitor and follow up on Term Begin Date Adjustments, Return Material Authorizations, Cancelled Sales Orders, and Reverse Billing Not Live Items.
• Create and send manual invoices following Sarbanes-Oxley Act protocol.
• Research operational issues with field personnel and correct entry errors with Database/Asset Management/Reconciliation teams.
• Manage Accounts Receivable balances: pursue past-due invoices via phone, email, and letters; escalate non-payment issues.
• Provide customer service regarding invoices and account balances.
• Work with other departments to ensure process and policy consistency and improve accuracy and efficiency.
• Maintain professionalism: consistent work schedule, positive attitude, and constructive communication.

Requirements

• 3+ years of experience in business collections or account reconciliation, preferably in a manufacturing environment.
• Ability to handle large volumes: 50+ accounts and $3 million+ spend.
• Strong Excel skills: VLookup and Pivot Tables.
• Analytical, problem-solving, reconciliation, and collection skills.
• Strong interpersonal, verbal, and written communication skills.
• Familiarity with computerized accounting/accounts receivable systems.
• Manage changing priorities, work extended hours, and make decisions under pressure.

Qualifications

• Bachelor’s degree preferred but not required; business, accounting, or finance emphasis a plus.