Operations Data & Staffing Analyst - Drive Efficiency & Insights

Kahana Feld; Irvine (CA); Hybrid; USD 48,000 - 55,000; Full time

Job summary

Kahana Feld is seeking an Operations Junior Data & Staffing Analyst in Irvine to collect, organize, and analyze data across multiple systems and drive strategic initiatives. You will work with Practice Group Management, Legal and People Operations, Finance, and leadership to support workload management, utilization tracking, and staffing coordination.

This fast-paced role demands exceptional organization and attention to detail, with the ability to liaison between attorneys, leadership, and

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.
• Experience and working knowledge of SQL is required.
• Advanced Excel (including pivot tables, formulas, macros, and data modeling).
• Advanced SharePoint functionality, including list setup, permissions, or automation.
• Power BI for dashboard creation and data visualization.
• Experience with APIs and data integration across systems.
• Experience with Python for data applications.
• PowerShell scripting for workflow automation and data transfer.

Responsibilities

• Pull, organize, and analyze data from the firm's finances, timekeeping, and billing systems to identify trends and support decisions.
• Run weekly, monthly, and ad hoc reports to support operations, client service, and relations.
• Provide leadership with insights and visual analyses from data sources.
• Maintain and improve data hygiene across databases for accuracy and completeness.
• Perform data cleanup and integration projects to enhance reporting reliability.
• Develop forms and flows to funnel data into dashboards for real-time review.
• Use APIs and automation tools to connect systems and streamline processes.
• Assist in data transition and QA for new software platforms.
• Design and maintain dashboards in Power BI to monitor KPIs and trends.
• Translate complex data into clear insights for non-technical audiences.
• Support financial analysis, client relationship management, and business development through data.

Skills

Data analysis

SQL

Advanced Excel

Power BI

SharePoint

APIs

Python

PowerShell

Communication

Organizational skills

Education

Bachelor's degree in Business Administration/related field

Tools

SharePoint

Power BI

Excel

Power Automate

MS Lists

APIs

Python

PowerShell

Job description

Kahana Feld is seeking an Operations Junior Data & Staffing Analyst in Irvine to collect, organize, and analyze data across multiple systems and drive strategic initiatives. You will work with Practice Group Management, Legal and People Operations, Finance, and leadership to support workload management, utilization tracking, and staffing coordination.

This fast-paced role demands exceptional organization and attention to detail, with the ability to liaison between attorneys, leadership, and