Business Systems Developer (Legal Firm) - IC

Classy Wheeler Limited; Hong Kong; On-site; HKD 446,400 - 669,600; Full time

Job summary

A leading legal firm is seeking a Business Systems Developer in Hong Kong. The role will focus on providing technical solutions for business intelligence and reporting systems, demanding expertise in MS SQL programming, SSRS, and Aderant systems. Ideal candidates will have ITIL certification and the ability to work under pressure while maintaining accuracy and attention to detail. Join a team dedicated to delivering tailored solutions in a fast-paced environment.

Qualifications

• ITIL certified.
• Expert in MS SQL programming including SSRS, SSIS, and SSAS.
• Proficient in SQL Server and T-SQL.
• Experience in creating and using Stored Procedures and Views.

Responsibilities

• Work on the new PMS project for BI and reporting solutions.
• Develop the firm's new reporting data warehouse with Aderant.
• Develop the front-end application Spotlight using the Cognos framework.
• Assist support of existing reporting systems such as SSRS, Redwood BI, and Clarity.

Skills

MS SQL programming

SSRS

SSIS

SSAS

SQL Server

T-SQL

Attention to detail

Teamwork

Education

ITIL certification

Tools

Aderant Expert

Job description

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 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 firm's 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