Job Description

Hybrid schedule offered after training!

A downtown Syracuse law firm is hiring a Reporting and Data Analyst to manage the creation, maintenance, and analysis of production data. The Analyst ensures timely and accurate generation of reports and key financial analyses that are essential for the firm`s operational and strategic decision making.

Duties:

• Process daily and monthly data warehousing from the firm`s time and billing system, ensuring data is accurate and ready for analysis
• Collect, cleanse, and analyze data from multiple sources such as client and matter management systems, timekeeping systems, and financial systems to develop actionable insights, reports, and dashboards
• Grow and maintain the firm`s reporting databases
• Design and generate regular business performance reports, including financial reports, sales and marketing metrics, and other key operational statistics
• Identify trends and patterns within production data, including timekeeper efficiency, client profitability, and matter performance, providing senior management with actionable insights and recommendations
• Ensure data quality by implementing validation rules and performing quality assurance checks to maintain consistency across reports and analyses
• Create and maintain detailed SSRS and Power BI reports, including the development of underlying database structures, stored procedures, and the integration of data from various sources
• Prepare and distribute regularly scheduled reports on financial performance, client matters, billable hours, collections, and other key metrics
• Develop ad-hoc reports and executive-level presentations to support strategic initiatives and management decision-making
• Assist in the preparation of detailed analyses of client profitability, matter cost performance, timekeeper utilization, realization, and other KPIs specific to a law firm environment

Job Requirements

• Bachelor`s degree in Information Systems, Accounting, Finance or related field
• 2+ years of data analysis, reporting or financial performance metrics experience; preferably in a law firm or professional services company
• Proficient with MS Excel and SQL
• Experience with Power BI and/or SSRS is preferred
• Experience with Elite, Aderant, or similar billing and timekeeping software strongly desired
• Strong understanding of law firm financial metrics such as billable hours, realization, collections, and profitability is preferred
• Excellent written and verbal communication skills
• Familiarity with Python R a plus
• Proven problem-solving, analytical and time management skills

Key Resource Group, LLC considers applicants for all positions without regard to gender, race, color, religion, national origin, ancestry, age, marital status, sexual orientation, pregnancy, physical or mental disability, citizenship, veteran status, gender expression and/or identity, or any other class protected by federal, state, or local laws. Key Resource Group, LLC is an equal opportunity employer.

Job Tags

Similar Jobs