Business Systems Developer (Legal Firm) - IC

Business Systems Developer (Legal Firm) - IC 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 DBAs, 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 utilization of systems, best practices, and develops bespoke solutions to support business needs. Job Description

1. Work on the new PMS project to provide technical solutions for the firm's BI and reporting solutions.
2. Work with Aderant to develop the firm's new reporting data warehouse.
3. Development of the front-end application Spotlight, using the Cognos framework.
4. Development of key transactional reports using SSRS.
5. Assist on support of existing reporting systems such as SSRS, Redwood BI, and Clarity.
6. Demonstrate the Group's values of individuality, commitment, teamwork, and straight talking.
7. Maintain a service-focused attitude and professional manner, appropriate for a commercial law firm.
8. Exhibit confident and clear communication (verbal and written) with people at all levels of the business hierarchy.
9. Respond quickly to requests, manage time effectively, and work under pressure.
10. Be proactive, hardworking, organized, able to structure own work, and work solo when required.
11. Work well as part of a team and follow direction.
12. Use initiative and make suggestions to change processes where required.
13. Maintain a high level of accuracy and attention to detail.

1. ITIL certified.
2. Expert in MS SQL programming including SSRS, SSIS, and SSAS.
3. Proficient in SQL Server and T-SQL (DDL and DML) in constructing tables and normalization techniques on database tables.
4. Expert in creating and using stored procedures, views, and user-defined functions.
5. Previous Professional Services firm experience is preferred.
6. Aderant Expert knowledge is favorable.