Operations Data & Staffing Analyst — Hybrid Role

Kahana & Feld LLP; Austin (TX); Hybrid; USD 48,000 - 55,000; Full time

Job summary

Kahana Feld LLP is seeking an Operations Junior Data & Staffing Analyst to collect, organize, and analyze data from multiple systems to support leadership and practice groups. You will drive staffing coordination, utilization tracking, and operational efficiency across the firm

The role emphasizes data quality, system integration, and automation using SharePoint, Power BI, APIs, Python, and PowerShell, with a hybrid work arrangement in Austin.

Qualifications

• Bachelor's degree in Business Administration, Computer/Data Science, Data Mining and Analytics, Engineering, Statistics, Economics, or 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 preferred.
• Experience and working knowledge of SQL is required.
• Advanced Excel (pivot tables, formulas, macros, 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 decision-making.
• Run regular weekly, monthly, and ad hoc reports to support business goals across operations, client service, and client relations.
• Provide firm leadership with insights and visual analyses from structured and unstructured data sources.
• Build and manage data hygiene across databases for accuracy and completeness.
• Gather, validate, and integrate data from multiple systems into consolidated reports and dashboards.
• Design, maintain, and enhance dashboards and visual reports in Power BI to monitor KPIs and trends.
• Compile, analyze, and maintain operational and staffing reports, including utilization, capacity, and matter assignment data.

Skills

Analytical skills

Communication

Data analysis

Problem solving

Attention to detail

Education

Bachelor's degree in related field

Tools

SQL

SharePoint

Power BI

APIs

Python

PowerShell

Excel

Power Automate

Microsoft Lists

Job description

Kahana Feld LLP is seeking an Operations Junior Data & Staffing Analyst to collect, organize, and analyze data from multiple systems to support leadership and practice groups. You will drive staffing coordination, utilization tracking, and operational efficiency across the firm

The role emphasizes data quality, system integration, and automation using SharePoint, Power BI, APIs, Python, and PowerShell, with a hybrid work arrangement in Austin.