Healthcare Lien Specialist: Data-Driven, SQL & Excel Expert

ARCHER Systems, LLC; Austin (TX); On-site; USD 55,000 - 75,000; Full time

Benefits offered by this job

401(K) retirement plans with matching

Dental and vision insurance plans

Parental leave

Short-term and long-term disability

Job summary

ARCHER Systems, LLC in Austin, TX is seeking a PLRP Lien Specialist to analyze large datasets and resolve healthcare liens using SQL, Excel, and Python. You will independently assess regulatory risks, improve lien strategies, and influence internal processes.

You'll collaborate with legal and operations teams, maintain accurate client files, and deliver timely results that support compliance at scale. Strong communication and analytical skills are essential to succeed in this role.

Qualifications

• 1-2 years in business operations, legal administration, claims operations, or related roles.
• 2-3 years using Microsoft Excel.
• Strong proficiency with Excel for data analysis.
• 1-2 years using SQL; comfortable with Python for data manipulation.
• Excellent communication with legal, technical, and client stakeholders.
• Analytical mindset with a data-driven approach.
• Ability to apply critical thinking and negotiation skills.
• Experience in mass tort accountability or healthcare lien resolution preferred.

Responsibilities

• Upload and extract large datasets using proprietary tools; analyze discrepancies and regulatory risk.
• Maintain accurate digital client files and organize case progress.
• Ensure outputs meet accuracy, documentation, and compliance standards.
• Audit medical claims itemizations and advise on resolution pathways.
• Provide consultative analysis influencing operational decisions and lien strategies.
• Build relationships with stakeholders as ARCHER's primary contact.
• Manage stakeholder expectations and ensure timely responses.
• Support time-sensitive deliverables by prioritizing analytical work based on impact.

Skills

Excel

SQL

Python

Data analytics

Legal research

Communication

Critical thinking

Teamwork

Detail oriented

Self-starter

Education

Bachelors or better in Business

Related discipline

Tools

Jira

ARCHER custom database

Job description

ARCHER Systems, LLC in Austin, TX is seeking a PLRP Lien Specialist to analyze large datasets and resolve healthcare liens using SQL, Excel, and Python. You will independently assess regulatory risks, improve lien strategies, and influence internal processes.

You'll collaborate with legal and operations teams, maintain accurate client files, and deliver timely results that support compliance at scale. Strong communication and analytical skills are essential to succeed in this role.