Junior Operations Data & Staffing Analyst

Socket.dev; Irvine (CA); Hybrid; USD 73,000 - 83,000; Full time

Benefits offered by this job

Hybrid work

Job summary

Socket.dev is seeking an Operations Junior Data & Staffing Analyst in Irvine to support leadership, practice groups, and administrative departments through data collection, organization, and analysis across multiple systems. The role drives workload management, utilization tracking, staffing coordination, and operational efficiency with a strong focus on accuracy and actionable insights.

You will work closely with Practice Group Management, Legal and People Operations, Finance, and leadership to

Qualifications

• Bachelor’s degree in Business Administration, Computer/Data Science, Data Mining and Analytics, Engineering, Statistics, Economics, or a related field.
• 1+ years of experience in computer/data science, legal operations, staffing coordination, finance, or professional services operations.
• Prior experience in a law firm or professional services setting is preferred; SQL proficiency required.

Responsibilities

• Pull, organize, and analyze data from the firm’s finances, timekeeping, and billing systems to identify trends and support decision-making.
• Run regular weekly, monthly, and ad hoc reports to support goals across operations and client relations.
• Provide leadership with insights and visual analyses from structured and unstructured data sources.
• Maintain data hygiene across multiple databases; ensure accuracy and completeness.
• Gather, validate, and integrate data from multiple systems into consolidated reports and dashboards.
• Build and manage SharePoint lists with advanced functionality for leadership access and workflows.
• Develop forms that funnel data into spreadsheets or dashboards for real-time tracking.
• Use APIs, PowerShell scripts, and automation tools to connect systems and streamline processes.
• Design, maintain, and enhance dashboards and visual reports in Power BI to monitor KPIs.
• Coordinate staffing, utilization, matter allocation data; forecast demand with leadership.

Skills

Data analysis

Data management

System integration

BI visualization

Operational management

SQL

Excel

Python

PowerShell

Communication

Education

Bachelor’s degree in Business Administration or related field

Tools

Power BI

SharePoint

Power Automate

Microsoft Lists

Excel (advanced)

Job description

Socket.dev is seeking an Operations Junior Data & Staffing Analyst in Irvine to support leadership, practice groups, and administrative departments through data collection, organization, and analysis across multiple systems. The role drives workload management, utilization tracking, staffing coordination, and operational efficiency with a strong focus on accuracy and actionable insights.

You will work closely with Practice Group Management, Legal and People Operations, Finance, and leadership to