Neal, Gerber & Eisenberg LLP is a mid-sized Chicago Loop law firm seeking a Financial Systems Analyst. The successful candidate will provide day-to-day support of accounting related software, perform necessary maintenance on accounting systems, provide support for the implementation of new projects, pull data from the back-end of accounting systems using SQL queries for sorting and analysis and additionally, assist with monthly metrics reporting and provide analysis where applicable.
Specific Duties include:
Provide support on the Firm’s accounting systems (Elite, Chrome River, TimeKM, WebView, WhiteHill, Metastorm/Intapp Intake, Redwood BI5/Iridium, Starcollect). This includes applying patches and scripts received from vendors as well as working with the accounting department on resolving all issues related to accounting system functionality and performance.
Provide technical support to end-users of accounting software, specifically with writing SQL queries and SSRS reports.
Coordinate production of monthly data cubes for Redwood BI5 system, including monthly balancing to Elite accounting system.
Manage/monitor data integrity by performing problem identification & resolution of issues related to financial applications.
Assist the client intake process with matter creation in Metastorm and the Patent, Trademark, and Copyright work not requiring Conflicts reviews.
Maintain TimeKM time entry system, including timekeeper setups, assignment modifications, and creation of load files.
Create and update monthly metrics reports/dashboards and provide analysis where applicable.
Work with Network Manager and Database Administrator on improving performance of accounting applications and connectivity between accounting systems and other Firm systems (iManage, Interaction, CPI, FileSurf, Evaluation Software, etc.).
Perform daily/weekly/monthly maintenance on Elite accounting system to Liaison with Accounting software vendors.
Support data import processes for Elite Enterprise, including FedEx, USPTO, Mastercard, Lexis, Western Union, etc.
Create and maintain user accounts, profiles and access rights for accounting systems and software.
Provide detailed information and documentation to the MIS Help Desk resolving re-assigned tickets relating to accounting software.
Assist MIS staff in resolving difficult support questions related to accounting systems operation.
Implement software upgrades and test new functionality of software.
Work on special projects as assigned by the Financial Reporting and Analysis Manager, Director of Finance and Chief Financial Officer.
Bachelor’s degree in Computer Science or equivalent experience
Bachelor’s degree in Information Technology related field, Business or equivalent experience
Minimum of 3-5 years of second-level technical support experience, preferably in the legal environment
Extensive experience with writing reports and queries in Microsoft SQL a must
Exceptional Microsoft Excel skills and knowledge of PowerPoint
Strong analytical skills to problem solve and implement solutions
Basic understanding of accounting/finance principles
Familiarity with Elite accounting system a plus
Familiarity with Chrome River, Metastorm, Intapp Intake, Redwood BI5 and/or Iridium a plus
Ability to organize and prioritize multiple projects effectively
Ability to follow precise procedures and demonstrate strong attention to detail is crucial to job performance
Excellent people skills including interacting with software users and third party vendors
Excellent oral and written communication skills
Must be able to lift at least 25 lbs
Ability to sit for long periods of time
Ability to stand for a length of time at a photocopier
Ability to bend, reach, twist and push while sitting or standing