About the Role
The Operations Junior Data & Staffing Analyst supports firm leadership, practice groups, and administrative departments by collecting, organizing, and analyzing data to drive strategic and operational initiatives. This role collaborates with various departments to support workload management, utilization tracking, staffing coordination, and operational efficiency.
Responsibilities
- Pull, organize, and analyze data from finances, timekeeping, and billing systems to identify trends and improve operational performance.
- Run regular weekly, monthly, and ad hoc reports to support business goals.
- Provide firm leadership with insights and visual analyses from data.
- Maintain and improve data hygiene across multiple databases, ensuring consistency and accuracy.
- Perform data cleanup and maintenance projects.
- 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 workflow automation.
- Develop forms that automatically funnel data into spreadsheets or dashboards.
- Use APIs, PowerShell scripts, and automation tools to connect systems and streamline processes.
- Assist in the transition and quality assurance of data between management systems and new software platforms.
- Design, maintain, and enhance dashboards and visual reports in Power BI.
- Translate complex data into clear, actionable insights for non-technical audiences.
- Support firm initiatives in financial analysis, client relationship management, and business development through data-driven insights.
- Compile, analyze, and maintain operational and staffing reports, including utilization, capacity, and productivity data.
- Utilize Power Automate, Microsoft Lists, Microsoft Excel, and SharePoint skills to create automated processes for staffing and headcount ratios.
- Monitor and analyze timekeeper workloads and assist in identifying staffing gaps and capacity concerns.
- Coordinate with Legal and People Operations, Finance, Recruiting, and Practice Group Leaders regarding attorney assignments and staffing needs.
- Prepare recurring and ad hoc reports related to attorney productivity, billable hours, and staffing allocation.
- Work with practice group leaders and firm leadership to understand business goals, plan for future needs, and allocate resources effectively.
- Track partner-associate ratios and provide staffing forecasts.
- Set up and manage efficient workflows, task tracking, calendars, and systems for organizing legal information.
- Serve as a key contact between partners, lawyers, and support departments to assist the practice group in achieving its objectives.
- Identify and participate in development and implementation of improvements to processes and workflows.
Requirements
- 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.
- Excellent organizational, analytical, and communication skills with the ability to explain complex data concepts to diverse stakeholders.
- Strong attention to detail, data accuracy, and system integrity.
Skills
- SQL
- Advanced Excel
- Pivot tables
- Formulas
- Macros
- Data modeling
- Advanced SharePoint functionality
- List setup
- Permissions
- Automation
- Power BI
- Dashboard creation
- Data visualization
- APIs
- Data integration
- Python
- PowerShell scripting
- Workflow automation
- Data transfer
- Organizational skills
- Analytical skills
- Communication skills
- Attention to detail
- Data accuracy
- System integrity
Location
- Hybrid
Work Type
- Full-Time
- Non-Exempt
Experience Level
- 1+ years of experience
Education Level
- Bachelor’s degree
Salary/Compensations
- $35.00 - $40.00 per hour
About the Company
- Kahana Feld provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Equal Opportunity
- This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
