Legal Inventory Data Analyst (Excel Dashboards)

Scott & Associates, PC; Charleston (SC); On-site; USD 42,000 - 62,000; Full time

Job summary

Scott & Associates, PC is seeking an Inventory Specialist to join our Legal Inventory team in Charleston, SC. The role focuses on pulling and cleaning inventory data from our case-management system, building Excel dashboards, and tracking performance and trends across cases.

You will work with advanced Excel functions, maintain data integrity, and produce clear reports. Collaboration, confidentiality, and attention to detail are essential for success in this position.

Qualifications

• 2+ years in a data-focused role (data entry, reporting, analytics).
• Proficient in Microsoft Excel (VLOOKUP/XLOOKUP, INDEX/MATCH, PivotTables, basic formulas).
• Experience with online databases and legal case-management software.
• Strong analytical skills—can spot patterns and explain them simply.
• Good written and spoken English.
• Self-motivated, detail-oriented, and able to juggle multiple tasks.
• Works well with others and maintains confidentiality of sensitive information.

Responsibilities

• Pull and clean inventory data from the case-management system.
• Use Excel to match data and spot errors (VLOOKUP, XLOOKUP, INDEX/MATCH, PivotTables).
• Build simple dashboards showing case stages and closure rates.
• Track team performance, flag delays, and suggest fixes.
• Produce reports on case status and inventory trends.
• Maintain a log of how reports are created and update it as needed.
• Assist with file reviews and status updates when requested.
• Carry out other tasks assigned by the Legal Case Manager.

Skills

Excel (VLOOKUP/XLOOKUP)

Data analysis

Attention to detail

English proficiency

Tools

Case management software

Online databases

Job description

Scott & Associates, PC is seeking an Inventory Specialist to join our Legal Inventory team in Charleston, SC. The role focuses on pulling and cleaning inventory data from our case-management system, building Excel dashboards, and tracking performance and trends across cases.

You will work with advanced Excel functions, maintain data integrity, and produce clear reports. Collaboration, confidentiality, and attention to detail are essential for success in this position.