Legal Financial Systems Analyst

Tucker Ellis LLP; Cleveland (OH); Hybrid; USD 90,000 - 125,000; Full time

Benefits offered by this job

Day 1 Benefits

401(k) with profit-sharing

Technology stipends

Annual HSA contribution

Hybrid work flexibility

Job summary

Tucker Ellis LLP is seeking a Financial Systems Administrator to support the Finance Department's suite of systems, including Aderant and related tools. You will resolve service desk requests, manage configurations, and work with IT to implement improvements.

The role requires strong SQL skills, experience with ERP systems, and a focus on data governance and reporting. Hybrid work with residencies in Cleveland or Chicago is expected.

Qualifications

• Bachelor’s degree in IT, business administration or accounting with IS focus.
• Previous law firm experience strongly preferred.
• Experience in relational databases and database administration.
• 2–3 years of experience with accounting or ERP systems and relational databases.
• Strong computer skills including advanced Excel, SQL, SSRS.
• Understanding of project management and change management disciplines.

Responsibilities

• Manage financial systems, user support, and training for Aderant and related tools.
• Handle user access administration and employee management tasks.
• Perform mass updates in Aderant via SQL.
• Execute monthly and annual rate changes for standard, exception and variable rates.
• Update bill images when documents are modified.
• Provide support to external vendors and coordinate with IT.
• Respond to service desk requests and analyze root causes.
• Write SQL queries for reporting and compliance needs.
• Develop and document financial system administration policies.
• Act as data steward for financial and operational data and enable reporting.

Skills

Excellent communication

Customer service mindset

Problem solving

Time management

Confidentiality

Continuous improvement

Education

Bachelor's degree in IT / Business Administration / Accounting with IS focus

Tools

SQL Server

SSRS

Excel

Database administration

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Chicago, IL, US

Location: Cleveland or Chicago- Must reside in one of these locations Schedule: Hybrid

Position Overview

This position is responsible for the day-to-day administration of the support, analysis and continuous improvement efforts for the suite of financial systems used by the Finance Department including but not limited to Aderant, iTimekeep , BigHand Iridium BI/ Intellistat , Oddr, etc.

Ensures the day-to-day administration of the system is handled efficiently and effectively by taking timely action to resolve service desk requests; manage routine systems configuration and maintenance; respond to business questions and perform root cause analysis of any issues.

KEY RESPONSIBILITIES:

• Manage financial systems, related user support functions, user training, and work balancing efforts for the systems including:
• Employee management tasks/user access administration
• Mass updates in Aderant via SQL
• Monthly & annual rate changes for all standard, exception & variable rates
• Update bill images when document modifications are made
• Provide support to external vendors
• Actioning service desk problems, issues, and service requests,
• Understanding and maintenance of system and data interdependencies
• Initial point of contact for Aderant and other finance system users’ support concerns
• Write SQL queries for Management Studio users (weekly time reports, compliance reports for FP&A, Client Value reports, billing, etc.)
• Develop and/or enhance financial system business administration and support policies, procedures, and support documentation.
• Act as a data steward for the firm’s financial and operational data, aiding in the development of efficient reporting solutions.
• First point of contact with Information Technology to identify and coordinate IT/Finance business solutions and objectives, including:
• Validating business functions after installations, patches, etc. are completed by the vendor or IT team
• Drive continuous improvement efforts over Aderant system capabilities, identifying best practices and system enhancements.
• Performs other Finance department analytical projects as assigned.

ESSENTIAL CAPABILITIES:

• Able to maintain strict confidentiality of the Firm's internal and personnel affairs and client information.
• Proven ability to build relationships and foster a collaborative approach to working with internal clients across practice groups and with management.
• Must be proactive and deliver high-quality work.
• Able to anticipate problems and issues and exercise independent judgment to make sound, justifiable decisions and take action in solving problems while knowing when and to whom to
• Excellent customer service attitude.
• Foster an environment of continuous improvement.
• Demonstrated ability to produce results within tight timeframes and simultaneously manage several projects.
• Excellent written and verbal communication skills.
• Willingness to work a flexible schedule and the hours needed to accomplish firm expectations.

QUALIFICATIONS

• Bachelor’s degree in Information Technology , Business Administration or Accounting with Information Systems focus.
• Previous law firm experience strongly preferred
• Experience in relational databases and database administration.
• Minimum two (2) to three (3) years’ experience with accounting or ERP systems and relational databases.
• Strong computer skills are essential including advanced Excel, SQL, SSRS, preferred.
• Understanding of project management and change management disciplines are essential.

Compensation

Target compensation for this role starts is $90,000 to $125,000/year. Actual compensation will be determined based on office location, years of experience, relevant skill set, and educational background.

What We Offer

• Day 1 Benefits: Medical, dental, and vision insurance
• Retirement Plan: 401(k) with profit-sharing contribution
• Monthly Contributions: Technology stipends, plus annual HSA contribution
• Hybrid work flexibility

Equal Opportunity Employer Statement

Tucker Ellis LLP is an equal opportunity employer. We are committed to creating a diverse and inclusive environment for all employees and do not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other protected characteristic.

Applicants and recruiting agencies: Tucker Ellis LLP does not accept unsolicited resumes from third-party recruiters. Any unsolicited resumes sent to our employees or offices without a signed agreement will become the property of Tucker Ellis LLP, and no placement fees will be paid.