Business System Analyst - SQL (ssis) & Reporting

Job Description

• We are looking for an enthusiastic hardworking and self-motivated Business Systems Analyst to help us evolve our Legal Enterprise Solutions Business Intelligence team to the next level. A good candidate should have a passion for and experience with front end applications and system processes and improvement. Experience with SQL is required. One key responsibility is to maintain front end system updates data integrations system processes/troubleshooting and reporting. The ideal candidate will possess good technical and problem-solving skills positive attitude and enjoy working as part of a team to create solutions to a multi-faceted reporting system infrastructure. We are also looking for this candidate to assist in recommending process/system improvements and synergies within LES and assist in serving the LES lead in simplification and collaboration initiatives across Thomson Reuters. The ability to work effectively with both technical counterparts and end-users is highly desired. The Business Systems Analyst will assist with finance and accounting ad-hoc reporting requests and issue resolution financial systems administration and involvement in many departmental process improvements. Division Legal Enterprise Solutions consists of the Thomson Reuters Elite and Serengeti businesses. LES is a leading developer of integrated information solutions for professional services firms worldwide. Thomson Reuters Elite is a premier provider of financial and practice management systems to the legal industry and to other professional services markets including accounting marketing services and management and IT consulting. Elite develops proven software solutions and delivers expert professional services that help customers enhance their core business competencies and sharpen their strategic focus. Headquartered in Los Angeles Elite maintains offices in Albuquerque Auckland Boston Calgary Hong Kong London Minneapolis New York Philadelphia Singapore and Sydney. More than 60% of the AmLaw 100 and Global 100 law firms and nearly 30% of the top CPA firms rely on Elite solutions to manage their business. Key Responsibilities Review and update financial systems and applications (Softrax /3E) - front end systems. Making system changes support manages system configuration / system settings processes to ensure fulfillment of business requirements and application requirements. Maintain multiple data integration systems and processes including engagement with third party support teams to resolve system related issues. Recommend and assist improvements to financial analysis accounting reconciliation and system troubleshooting. Perform and support the business in month end close system processes and procedures. Ability to use SQL for reporting issue resolution and research perform audits and maintain data integrity. Ensure that process and system documentation is updated when change requests are approved. Work independently and as part of a team on multiple projects (requirements gathering enhancements upgrades UAT etc.). Work with team members effectively to raise issues and address roadblocks in a timely manner. Provide timely and accurate written and oral communication of status to team project and technical leads. Proactively recognize and communicate opportunities to add value through the application of new technologies to working practices. Partner closely and collaborate with other teams (Technology Business Systems Billing Collections Cash Apps Accounting Service Operations etc.) to drive the business forward. Work with Microsoft to support our internal cloud services including invoice monitoring documentation verification support ticket administration and develop best practices for cloud related activities. Qualifications Experience Knowledge Bachelors degree in Technology Business Administration Finance or related field or equivalent experience. 1+ years experience writing Microsoft SQL queries 4+ years experience in billing or reporting with working knowledge of G/L and Billing systems preferred 4+ years experience in Microsoft Office software required with advanced level Excel skills required Skills Strong analytical detail orientation and problem-solving skills Excellent organizational verbal and written communication skills Experience working effectively across the team cross-functionally and with external partners clients and vendors Experience administering medium to large scale databases Ability to work effectively in a dynamic team environment to deliver results with aggressive deadlines and multiple priorities Passion to build great reports and tools Innovative independent problem solving; design and testing skills with a track record of superior performance Ability to work within a matrix organization Please refer to the Job description above

Job Summary