Financial Systems Analyst

Tracking Code 2112-437 Job Description WilmerHale is a leading, full-service international law firm with 1,000 lawyers located throughout 12 offices in the United States, Europe and Asia. Our lawyers work at the intersection of government, technology and business, and we remain committed to our guiding principles of providing quality, excellent legal and client services; developing diversity among our lawyers and staff and cultivating an environment that promotes an ambitious spirit, collaboration and collegiality by drawing on the extraordinary talents and dynamic experience of our lawyers. Our goal is to reflect the diversity of our clients and the communities in which we practice. About This Role The Financial Systems Analyst assists with supporting and maintaining the Firm's financial system (3E), Proforma Tracker and other related systems. Acts as the primary contact for all internal users by providing high quality customer service. Manages the troubleshooting, analysis, recording, prioritization, tracking and resolution of all customer requests and resolves problems directly or by escalation to the Elite Systems Manager, IS or Elite. Assists with planning, testing, implementing and deployment of upgrades to the financial system. Identifies opportunities to automate business processes, enhance reporting capabilities and improve operational efficiency. Maintains process documentation, creates training materials and conducts training. Serves as back up to Elite Systems Manager. What You Will Be Doing Principal point of contact for day-to-day user support of the financial system (3E), Proforma Tracker and other accounting sub systems. Provides exceptional customer service and support through telephone, email and in-person. Responsible for troubleshooting, analyzing, prioritizing, tracking, resolving and following through with both internal customers and external parties regarding outstanding support issues. Collaborate as needed with Elite Systems Manager, IS and Thomson Reuters Elite (TRE). Responsible for Month End close. Assures system integrity by completing balancing spreadsheets and researching discrepancies, including Unbilled, A/R, GL, AP, Firm Statistics and WIP by Reference Reconciliation. Maintains user access setups/security levels and performs quarterly audit of users. Responsible for other system setups, such as electronic billing codes, titles, bank and trust accounts. Ensures that all set ups are functioning properly and designed according to WH policies and procedures. Responsible for daily reconciliation of Time loads into 3E from Intapp time and work with IS to resolve Time load failures/errors as needed; review Time Hold balances periodically. Activate/De-activate LPM assignments and update Matter Arrangement Codes. Review Post Queue and Posting Results for any processing delays/bottlenecks/errors and timely resolve the errors. Creates custom reports and presentations using Elite, Excel and SQL. Develops understanding of 3E data structures to write SQL queries to extract data and prepare ad hoc reports/analysis when necessary. Responsible for setting up, testing and validation of Broadcasts and 3E Stock and Custom notifications. Assist with project coordination and leadership for all new projects as they relate to Elite software and User interface upgrades, including scheduling and testing of system updates/upgrades, deployment of fixes, creating test plans, quality assurance and data integrity checks. Assists with coordination and implementation of software testing process in a lab environment with internal project teams (Billing/AP/GL/Reporting). Identifies and recommends functional system process improvements. Keeps abreast of trends in the marketplace for system improvements and keeps manager informed of latest trends. Assumes additional responsibilities as assigned. Contributes to the Firm's Servic