Financial Systems Analyst
| Company | Troutman Pepper |
|---|---|
| Location | Boston, MA, USA, Rochester, NY, USA, Houston, TX, USA, New Orleans, LA, USA, Harrisburg, PA, USA, Washington, DC, USA, San Francisco, CA, USA, Austin, TX, USA, Detroit, MI, USA, Los Angeles, CA, USA, Stamford, CT, USA, Miami, FL, USA, Providence, RI, USA, Irvine, CA, USA, Dallas, TX, USA, Virginia Beach, VA, USA, Raleigh, NC, USA, Philadelphia, PA, USA, West Palm Beach, FL, USA, Richmond, VA, USA, Chicago, IL, USA, Charlotte, NC, USA, Pittsburgh, PA, USA, Princeton, NJ, USA, Hartford, CT, USA, New York, NY, USA, Wilmington, NC, USA, Oak Park, IL, USA, Portland, OR, USA, Atlanta, GA, USA, San Diego, CA, USA, Cincinnati, OH, USA |
| Salary | $85000 – $105000 |
| Type | Full-Time |
| Degrees | Bachelor’s |
| Experience Level | Senior |
Requirements
- Extensive working knowledge and understanding of SQL, stored procedures and SQL Server Reporting Services (SSRS)
- In-depth understanding of the Expert data structure; Power BI, Tableau and BigHand experience a plus
- Experience developing customizations to Aderant Expert forms, inquiries, and rules with Expert’s Design Studio
- Demonstrated success with timely delivery of high-quality product while managing multiple deadlines
- Demonstrated success with effective work practices, working as a team member and building relationships with clients, attorneys, internal departments, and vendors while also maintaining confidential information
- Excellent written and verbal communication skills
- Proven experience adding value, building efficiency, and improving accuracy and reliability of information for the firm
- Strong Microsoft Office skills required, with a focus in Excel
- Ability to work effectively both independently and with teams to promote consistent and efficient workflow processes
- Ability to self-manage and work independently in a hybrid, and in-office setting
- Bachelor’s degree in Accounting or Information Systems
- Minimum of five (5) years’ experience with SQL-based database management systems
- Hands-on experience retrieving data by writing complex SQL
- Experience administering Financial Accounting systems, with a thorough working knowledge of both the database and application components
Responsibilities
- Assist with technical support, implementation projects for Aderant and other integrated financial systems, including SSRS reports, Budgeting, Expert Billing, AP, Rate and Collections, and Time Entry
- Assure successful support of the full end-to-end cycle for processes within the system, including requirement gathering, planning, testing, and implementing
- Work directly with Aderant support on identification and resolution of day-to-day needs, opening support tickets and helping to resolve issues
- Support the overall installation, customization, enhancement, maintenance, and support of the financial systems, primarily Aderant Expert and its peripheral applications (ChromeRiver, BillBlast, iTimekeep, and BigHand)
- Support identification and resolution of issues relating to the financial applications, including Expert Classic, Expert Billing, AP, Rate and Collections, BillBlast, and iTimekeep
- Participate in technical and functional aspects of all financial systems-related projects, including analysis of the current business needs, detection of critical deficiencies, and recommendation of solutions for improvement
- Maintain detailed documentation of all established procedures, assumptions, methodologies, and sources of information employed as part of all analytical tasks
- Provide requested data and reports to support design and feature decisions for the systems using tools such as T-SQL, SQL Server Reporting Services (SSRS), Aderant Expert, BigHand, Power BI, Tableau, and Excel
- Customize forms, templates, and design custom inquiries and tiles using Aderant Experts Design Studio and End-User painter
- Develop, modify, and maintain billing templates using SQL and DocuDraft
- Help maintain user security, Data Integrity, Rules and Guidelines within Aderant Expert
- Develop skills, knowledge, and ability to improve processes and procedures as well as to keep updated on trends and developments in the industry
- Maintain current knowledge of accounting reporting changes, and plan for changes in response to dynamic business needs
- Provide additional support for month-end time and billing closing of Aderant Expert as requested
Preferred Qualifications
- Previous experience with project implementation and Aderant within in a law firm environment a plus