Senior Finance Systems Analyst

Keen to become part of a truly global, collaborative team of professionals? Your journey begins here.

KEY RESPONSIBILITIES

• Monitor the firm’s support ticketing system, Service Now, for 3E and related issues.

• Manage vendor incidents and issues for the various financial systems applications.

• Produce client and custom reports (using SQL and Excel), as well as create custom tables/data-marts.

• Resolve or reassign support tickets in a timely manner.

• Assist accountants with bank reconciliation.

• Balance 3E financial accounting data.

• Ensure data integrity through troubleshooting, system balancing, month-end and year-end procedures, as well as bespoke and off-the-shelf reporting systems.

• Propose solutions (or improvements) for future and current report requirements using existing software tools and involve technology for complex programming requirements when necessary.

• Attend training sessions for technical and personal development, including product-related training (e.g., 3E, Emburse Enterprise) and cultural/soft skills training.

• Take on projects involving finance systems, attend project meetings, and work with other departments in Finance and IT keeping project managers regularly informed of progress and developments.

• Provide month-end support and perform month-end closing on a rotating schedule.

• Understand the 3E security model and assign approved access for users and handle 3E system set-ups.

• Test new processes and prepare documentation.

• Monitor the global Finance Systems team inbox for issues to resolve on a rotating basis.

• Create ad-hoc reports in SSRS, Power BI, SQL, and 3E while providing accurate financial data when requested.

• Create scripts for mass updates of data, working within the firm’s Change Control policy and process.

• Collaborate with Finance Systems team members globally to solve issues and provide solutions.

• Attend trainings, both in terms of technical and prodcut training and personal and soft skills development. 

• Handle data integrity, including troubleshooting, system balancing, and month-end and year-end procedures

• Ensure compliance with the firm's information security policies and procedures at all times.

• Participate in the firm’s global Responsible Business program.

• Perform other duties as assigned.

REQUIRED SKILLS

• Demonstrated understanding of accounting systems, and how the multi-company, multi-currency paradigm works.

• Excellent verbal and written communication skills and the ability to effectively collaborate with individuals across all levels of the firm.

• Team player, well organized, and flexible.

• Project and incident management skills.

• Advanced knowledge of core Elite 3E data structure, SQL, Microsoft reporting technologies/concepts, including Power Bi.

• One Stream or other financial consolidation systems knowledge.

• Solution-oriented and innovative.

• Strong analytical and technical skills around report writing and troubleshooting of application issues.

EDUCATION, CERTIFICATIONS AND/OR EXPERIENCE

• Five (5)+ years of relevant experience preferred

• Experience with Elite 3E relational database structure and with writing SQL statements preferred. 

• Bachelor’s degree required or equivalent combination of education and work experience.

• Microsoft Reporting Services (SSRS) or equivalent software package with experience in complex report writing.

• Experience supporting users in a law firm environment is preferred.

• Experience with Microsoft Analysis Services, including MDX, a plus. 

Core hours are Monday through Friday, 9:00 a.m. to 6:00 p.m., including one hour for lunch. This role will need to provide support to end users, not only locally, but also globally, so candidates must be flexible to work overtime, as necessary. Limited time off in December, January, or during month-end process.

#LI-WS