Client Description UK-based international legal firm Team structure The Business Systems Team (BST) consists of a Head of Business Systems; five systems analysts; two DBA, three developers and a Project Accountant. The team sits independently between IT and Accounts working closely with both departments with ownership of the firm's key business systems including PMS – Aderant Expert, Reporting & Budgeting and the Intapp suite of products as well as integrations between all firm systems. The team leads innovations around the utilisation of systems, best practice and develops bespoke solutions to support business needs. Job Description Work on the new PMS project to provide technical solutions for the firm's BI and reporting solutions Work with Aderant to develop the firms new reporting data warehouse Development of the front-end application Spotlight, using the Cognos framework Development of key transactional reports using SSRS Assist on support of existing reporting systems such as SSRS, Redwood BI and Clarity Demonstrates the Group's values of individuality, commitment, teamwork and straight talking Service focused attitude and professional manner, appropriate for a commercial law firm Confident and clear communication (verbal and written) with people at all levels of the business hierarchy Able to respond quickly to requests, manage time effectively, and work under pressure Proactive nature, hardworking, organized, able to structure own work and work solo when required Able to work well as part of a team and follow direction Able to use initiative and make suggestions to change processes where required High level of accuracy and attention to detail Job Requirements ITIL certified Expert in MS SQL programming including SSRS, SSIS and SSAS Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables Expert in creating and using Stored Procedures, Views, User Defined Functions. Previous Professional Services firm experience is preferred Aderant Expert knowledge is favorable