Financial Systems Analyst

Herbert Smith Freehills Kramer; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

Herbert Smith Freehills Kramer seeks a Financial Systems Analyst to provide technical and functional support for the Aderant financial system and related applications. You will troubleshoot issues, maintain system stability, and develop ad hoc SQL queries for data analysis.

The role emphasizes user support, data integrity, and reporting via SSRS and Power BI, with exposure to API integrations and financial reporting requirements for a large law firm.

Qualifications

• 3+ years of experience supporting Aderant Expert or similar practice management software.
• Experience with SSRS and/or Power BI for reporting and analytics.
• Experience supporting financial system integrations and APIs.
• Strong analytical and troubleshooting skills.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Provide daily technical and functional support for the Aderant financial system and related systems.
• Escalate complex issues to senior analysts or vendor as needed.
• Document issues, resolutions, and support procedures.
• Assist users with system navigation and troubleshooting.
• Develop and execute ad hoc SQL queries for data analysis and reporting.
• Run SSRS reports and assist with ad hoc reporting requests; create SQL queries, dashboards, and Power BI reports.

Skills

SQL

SSRS

Power BI

Analytical thinking

Troubleshooting

Tools

Aderant Expert

Aderant Framework

Chrome River

Intapp Time

Legal360

Job description

The Financial Systems Analyst role will be responsible for providing technical and functional support for the firm's Aderant financial systems and related applications, including but not limited to time entry, cost recovery, and financial reporting. The role involves troubleshooting issues, ensuring system stability, performing routine maintenance, and developing and executing ad hoc SQL queries.

Key Responsibilities:

System Support and Maintenance:

• Provide daily technical and functional support for Aderant financial system and associated systems.
• Escalate complex issues to senior analysts or vendor as needed.
• Document issues, resolutions, and support procedures.

User Support:

• Assist users with system navigation, functionality, and troubleshooting.
• Respond to user inquiries and issues in a timely and professional manner

Data Management:

• Ensure data integrity and accuracy within the Aderant system and associated systems.
• Develop and execute ad hoc SQL queries for data analysis and reporting.
• Detect and correct cost recovery upload errors.

Reporting:

• Run standard SSRS reports and assist with ad hoc reporting requests.
• Develop and maintain SQL queries, SSRS reports, dashboards, and Power BI reports.
• Analyze financial data to support business decisions.
• Create ad hoc reports for Business Finance group.

Required Qualifications

• 3+ years of experience supporting Aderant Expert or other professional services practice management software; experience in the legal industry is a plus.
• Experience with SSRS and/or Power BI.
• Experience supporting financial system integrations and API.
• Strong analytical and troubleshooting skills.
• Ability to manage multiple priorities in a fast-paced environment.

Preferred Qualifications

• Experience with Aderant Framework or other legal financial systems.
• Knowledge of Chrome River, Intapp Time, Legal360 or similar legal applications.
• Experience supporting large, multi-office law firms.

Compensation: Exact compensation may vary based on skills and experience and salary range is $120,000 - $150,000