Job Opportunity - Financial Systems Analyst I - (Remote USA/All Offices)

Job Opportunity - Financial Systems Analyst I - (Remote USA/All Offices)

Key Responsibilities

• Financial Reporting: Develop and maintain complex SQL-based reports using SSRS (SQL Server Reporting Services) to support financial analysis and decision‑making processes.
• SQL Stored Procedures: Utilize advanced SQL skills to design and optimize stored procedures, scripts, and queries for data retrieval, transformation, and reporting.
• System Integration: Manage integration efforts between Aderant and other internal or external systems, ensuring seamless data flow and accurate reporting.
• Data Integrity & Validation: Ensure data accuracy and consistency across systems, implementing validation routines, data cleansing processes, and periodic audits as necessary.
• Source Control Management: Use Subversion for version control, ensuring code integrity and efficient collaboration across development teams.
• Process Improvement: Work closely with finance and accounting teams to identify process inefficiencies and implement technological solutions to improve operations and reporting.

Required Qualifications

• A Bachelor’s degree in Computer Science, Information Systems, or a related field is required.
• 3‑5 years of experience in a law firm environment, specifically with financial systems and software.
• Proven experience with Aderant or similar legal financial software.
• Strong proficiency in SQL (especially stored procedures) and experience in database management, data warehousing and optimization.
• Experience with Chrome River for expense and invoice management.
• Strong experience with Power BI, SSRS and Report Builder for financial reporting.
• Experience in SQL, with the ability to write complex queries, stored procedures, and views for large datasets.
• Experience using Subversion (SVN) or other source control software.
• Legal and Financial Systems Knowledge: Understanding of financial processes in a law firm setting, including time and billing, invoicing, expense management, and financial reporting.
• Problem‑Solving & Analytical Skills: Strong analytical and troubleshooting skills, with the ability to investigate and resolve technical issues efficiently.
• Excellent written and verbal communication skills, with the ability to explain technical concepts to non‑technical stakeholders and collaborate effectively with cross‑functional teams.

Preferred Qualifications

• Experience with other legal or financial software tools commonly used in law firms (e.g., Aderant, Chrome River, etc.).
• Knowledge of financial systems integrations, data migrations, and system upgrades.
• Experience with cloud‑based financial systems or SaaS applications is a plus.