APD (Automobile Physical Damage) Clerk
Essential Duties and Responsibilities
- Enter, update, and maintain property damage claim information with a high degree of accuracy.
- Review claim files to ensure required documentation is complete and properly indexed.
- Utilize Microsoft Excel to organize, track, analyze, and report claim data.
- Create and maintain spreadsheets, pivot tables, formulas, filters, and reports to support departmental operations.
- Verify data accuracy by comparing information across multiple systems and correcting discrepancies.
- Scan, upload, and electronically file claim documents.
- Monitor department inboxes and distribute correspondence as needed.
- Assist appraisers with administrative tasks related to property damage claims.
- Process incoming mail, invoices, estimates, and supporting documentation.
- Generate daily, weekly, and monthly reports for management.
- Maintain organized electronic records in accordance with company policies.
- Communicate professionally with internal departments regarding claim documentation and status updates.
- Perform other administrative duties as assigned.
Qualifications
- High school diploma or equivalent required.
- Previous clerical, administrative, insurance, or claims support experience preferred.
- Strong data entry skills with exceptional attention to detail.
- Intermediate to advanced proficiency in Microsoft Excel, including:
- Formulas (SUM, IF, VLOOKUP/XLOOKUP preferred)
- Sorting and filtering data
- Pivot Tables
- Conditional formatting
- Basic chart creation
- Proficiency in Microsoft Office Suite (Word, Outlook, Excel).
- Ability to learn multiple computer systems quickly.
- Strong organizational and time management skills.
- Excellent written and verbal communication skills.
- Ability to prioritize workload and meet deadlines in a fast-paced environment.
- Ability to handle confidential information professionally.
- Effective interpersonal skills and a collaborative work ethic.
- Self-motivated with the ability to work independently and as part of a team.
Physical Requirements
- Prolonged periods of sitting and working at a computer.
- Frequent use of keyboard and mouse.
Preferred Qualifications
- Experience working in an insurance or claims environment.
- Familiarity with claim management software.
- Experience handling large datasets and generating Excel reports.
- Knowledge of automotive repair estimates or property damage claims is a plus.
Work Location: In person
#CLAIMS
Job Type: Full-time
Pay: $12.00 per hour
Benefits:
- 401(k)
- 401(k) matching
- Dental insurance
- Health insurance
- Health savings account
- Life insurance
- Paid time off
- Vision insurance
Work Location: In person