Data Reporting Analyst Job at Key Resource Group, LLC, Syracuse, NY

ZDJDVGZjVFplR3hIYTBFd2Q4QUtmUG5kRVE9PQ==
  • Key Resource Group, LLC
  • Syracuse, NY

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

Local area,

Similar Jobs

Oviatt Cabinet and Mill

Drafting and Engineering Job at Oviatt Cabinet and Mill

 ...Daily Functions Creating detailed drawings for owners and architects to review for fabrication Qualifications 1-2 yrs experience with AutoCAD Experience working with cabinetry Previous experience working with Microvellum Microsoft Office... 

Yoh, A Day & Zimmermann Company

Customer Service Representative (Entry level - Remote) Job at Yoh, A Day & Zimmermann Company

 ...York/New Jersey preferred) Pay Rate: $20 per hour Hours/Schedule: 40 hrs per week (8:30AM-5PM) Job Description Order Entry Order maintenance Processing claims and returns Additional admin tasks as needed Who you are: Must be proficient... 

FriedLam Partners LLC

Maintenance Technician Job at FriedLam Partners LLC

 ...Job Title: Maintenance Technician - Multi-Family Property Job Description: The Maintenance Technician is responsible for ensuring the...  ...or safety issues. Repairs: Complete work orders for apartment repairs, including plumbing, electrical, carpentry, and HVAC issues... 

Ultimate Staffing

Bilingual Customer Service Retention Agent Job at Ultimate Staffing

 ...satisfaction. Responsibilities Answer phones and emails promptly to assist customers with their inquiries. Respond to customer...  ...identity, gender expression, marital status, disability, medical condition, genetic information, pregnancy, or military or veteran... 

Think Tell Junction

Entry Level Marketing Assistant Job at Think Tell Junction

Join Our Team as a Entry Level Marketing Assistant Think Tell JunctionThink Tell Junction We are seeking a motivated and dynamic Entry Level...  ....* Familiarity with social media platforms and basic digital marketing concepts.* Proficiency in Microsoft Office Suite...