Legal & Business Operations Data Analyst

The Legal & Business Operations Data Analyst supports the firm’s leadership and administrative departments by collecting, organizing, and analyzing data across multiple systems to drive strategic and operational initiatives.

Duties and Responsibilities

Data Analysis & Reporting

• Pull, organize, and analyze data from the firm’s finances, timekeeping, and billing systems to identify trends, support decision-making, and improve operational performance.
• Run regular weekly and monthly reports to support business goals across operations, client service, and client relations.
• Provide firm leadership with insights and visual analyses derived from structured and unstructured data sources.

Data Management & Quality

• Maintain and improve data hygiene across multiple databases, ensuring consistency, accuracy, and completeness.
• Perform data cleanup and maintenance projects to enhance reporting reliability and system efficiency.
• Gather, validate, and integrate data from multiple systems and locations into consolidated reports and dashboards.

System Integration & Automation

• Build and manage SharePoint lists with advanced functionality, connecting data from multiple systems for leadership access and workflow automation.
• Develop forms that automatically funnel data into spreadsheets or dashboards for real-time tracking and executive review.
• Use AIPs, PowerShell scripts, and automation tools to connect systems, push and pull data, and streamline processes.
• Assist in the transition and quality assurance of data between the firm’s management systems and new software platforms.

Business Intelligence & Visualization

• Design, maintain, and enhance dashboards and visual reports in Power BI to monitor KPIs and business trends.
• 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.

Qualifications & Skills

• Bachelor’s degree in Data Analytics, Business Administration, Finance, Information Systems, or a related field.
• 3-5 years of experience in data analytics, business intelligence, or operations analysis.
• Prior experience in a professional services or law firm setting preferred.
• 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.
• Working knowledge of SQL or other database query tools preferred.
• 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.

This job description reflects management's assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned.

Equal Opportunity Employer

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.

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.

Job Type

Full-Time, Non-Exempt

Supervisory Responsibilities

None

Work Location

Hybrid

Work Schedule

8:30am - 5:30pm Monday-Friday. Occasional weekends and holidays

Salary Range

$85,000 - $115,000

Physical Requirements

Primarily sedentary work. Exerting up to 40 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects. Repetitive motion. Substantial movements (motions) of the wrists, hands, and/or fingers. The worker is required to have close visual acuity to perform an activity such as: preparing and analyzing data and figures; transcribing; viewing a computer terminal; extensive reading. Work is performed in an office environment and requires the ability to operate standard office equipment and keyboards. Must have the ability to walk short distances, and/or drive a vehicle to deliver and pick up materials. Work can be performed with or without accommodations.

Travel

5 – 10% domestic travel by ground and or air, dependent on firm needs