Client Accounting Developer

Our client¸ a multinational law firm, is in search for a Client Accounting Developer. This is a full time, permanent position, located in NYC. This is a hybrid model role where employees are required to come into the office three times per week. Please see below for the full job description:

Location: NYC

Job type: Temp to Perm

Job Summary:

· Assists management to improve the overall Client Accounting process within the Firm.

· Enhances core business applications and implements solutions as required by partners and upper management of the Firm.

· Uses computer programming skills to streamline reporting analysis and billing processes.

Essential Functions:

· Designs and upgrades systems to align business processes with the strategic vision of partners and upper management

· Analyzes and summarizes data, interprets results and presents findings to partners and senior management for effective decision-making.

· Serves as a resource and mentors staff members with respect to SQL scripting and the application of analytical methodologies.

· Retrieves billing, accounting, financial, and related data from a Microsoft SQL Server database to produce strategic reporting for partners, clients, management, and staff members.

· Designs and develops applications to streamline and standardize billing and related reporting.

· Stays current with developments in the information technology and legal industries to determine needs, requirements, opportunities, and impact to department and Firm.

· Provides support and training to staff members on various applications, including ADERANT Expert, Expert Image, Excel, the department's custom Excel/VBA macros and SQL Server Reporting Services (SSRS).

· Mines and analyzes data regarding unbilled, accounts receivable, credits, and related metrics to assist the Firm in maximizing billing and collections and performance on specific engagements.

· Prepares ad hoc reports as requested.

· Prepares supporting documentation relating to applications used by the department.

Qualifications:

· Bachelor's degree

· Minimum of five years' related experience

· Knowledge of relevant firm computer software programs (e.g., Outlook, Excel, PowerPoint, Word), with the ability to learn new software and operating systems

· Knowledge of and experience with queries in Transact-SQL using SQL Management Studio and Microsoft SQL Server or similar database environments

· Knowledge of and experience with Visual Basic for Applications (VBA), Visual Basic (VB), or VB.Net, SSRS, C# and Team Foundation Server

· Knowledge of and experience with ADERANT Expert and its underlying table structure

· Advanced knowledge of and experience with Microsoft Excel

· Intimate knowledge of finance and accounting concepts

· Demonstrates effective interpersonal and communication skills, both verbally and in writing

· Demonstrates close attention to detail

· Excellent analytical, troubleshooting, organizational, and planning skills

· Ability to analyze Firm and coworker information needs and translate them into technology solutions

Must Haves:

· SQL, C#, VBA, high-level Excel, appreciation for data analytics, excellent communication skills

Nice to Haves:

· Machine learning/AI experience, ADERANT, law firm experience