Your resume and cover letter, tailored to exactly what they’re hiring for.
Get past ATS filters
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