Junior Operations Data & Staffing Analyst (Hybrid)

Socket.dev; San Francisco (CA); Hybrid; USD 48,000 - 55,000; Full time

Job summary

Socket.dev is seeking an Operations Junior Data & Staffing Analyst to collect, organize, and analyze data across multiple systems to drive strategic and operational initiatives. This role supports leadership, practice groups, and administrative departments, coordinating workload management and staffing efficiency.

You will collaborate with Practice Group Management, Legal, People Operations, and Finance to monitor utilization, staffing, and metrics.

Qualifications

• Bachelor's degree in Business Administration, Computer/Data Science, or related
• 1+ years of data/science, legal operations, staffing coordination, finance, or professional services operations
• Experience in a law firm or professional services setting is preferred
• Experience with SQL is required
• Advanced Excel skills (pivot tables, formulas, macros, data modeling)
• Power BI for dashboards and data visualization
• Experience with APIs and data integration across systems
• Python for data applications and PowerShell scripting for automation

Responsibilities

• Pull, organize, and analyze data from the firm’s finances, timekeeping, and billing systems to identify trends and support decision-making
• Run weekly, monthly, and ad hoc reports to support operational goals across operations and client relations
• Build and maintain dashboards and visual reports in Power BI to monitor KPIs and business trends
• Develop forms and automated workflows using SharePoint, Power Automate, and Excel for real-time tracking
• Collaborate with Practice Group Management, Legal, People Ops, Finance, and leadership to optimize staffing and workload planning

Skills

SQL

Power BI

Excel

Python

PowerShell

APIs

SharePoint

Data analysis

Data visualization

Staffing coordination

Education

Bachelor's degree in Business/CS/Data Science

Tools

Power Automate

Microsoft Lists

SQL Server

SharePoint

Job description

Socket.dev is seeking an Operations Junior Data & Staffing Analyst to collect, organize, and analyze data across multiple systems to drive strategic and operational initiatives. This role supports leadership, practice groups, and administrative departments, coordinating workload management and staffing efficiency.

You will collaborate with Practice Group Management, Legal, People Operations, and Finance to monitor utilization, staffing, and metrics.