Lewis Brisbois Bisgaard & Smith, LLP

We are seeking an experienced Financial Systems Analyst I with a strong background in law firm financial systems to join our team. The ideal candidate will have 3-5 years of experience working within an Aderant-based AM Law 100 firm and possess proven technical skills in ASP.NET, C#, SQL, JavaScript, and SSRS. This role will involve supporting, optimizing, and enhancing financial systems, ensuring seamless integration and high performance to meet the firm’s financial and operational needs.

Key Responsibilities:

• Web Application Development & Maintenance: Write, test, and maintain in-house built Web Applications in C#, ASP.NET, JavaScript

• 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:

• Education:

o A Bachelor’s degree in Computer Science, Information Systems, or a related field is required.

• Experience:

o 3-5 years of experience in a law firm environment, specifically with financial systems and software.

o Proven experience with Aderant or similar legal financial software.

o Strong proficiency in SQL (especially stored procedures) and experience in database management, data warehousing and optimization.

o Experience with Chrome River for expense and invoice management.

o Proficient in ASP.NET, C#, JavaScript, PowerShell and related development technologies.

o Strong experience with Power BI, SSRS and Report Builder for financial reporting.

• Technical Skills:

o Experience in SQL, with the ability to write complex queries, stored procedures, and views for large datasets.

o Experience using Subversion (SVN) or other source control software.

• Legal and Financial Systems Knowledge:

o Understanding of financial processes in a law firm setting, including time and billing, invoicing, expense management, and financial reporting.

• Problem-Solving & Analytical Skills:

o Strong analytical and troubleshooting skills, with the ability to investigate and resolve technical issues efficiently.

• Communication Skills:

o 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.

For further information please see Lewis Brisbois | Careers Center | Welcome