Senior Applications Analyst

Hempsons; City Of London; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A leading law firm in the UK seeks a Senior Applications Analyst to manage and optimize legal applications and data systems. This hybrid role requires hands-on expertise in Aderant Expert, Microsoft 365, and SQL Server management, along with project involvement in innovative technologies like Generative AI. The ideal candidate will support critical business applications and contribute to ongoing improvements in the firm's services.

Benefits

Holiday purchase scheme

Private health insurance

Life assurance & critical illness cover

Season ticket loans

Cycle-to-work scheme

Qualifications

• Proven experience with Aderant Expert and workflow optimization.
• Familiar with Microsoft 365, SharePoint, and Power Platform.
• Strong technical skills in SQL and data integration.

Responsibilities

• Maintain and develop legal application systems.
• Support business-critical applications and manage upgrades.
• Collaborate on AI projects and develop integration capabilities.

Skills

Aderant Expert administration

Microsoft 365 expertise

SQL Server management

Data integration design

C# programming

Power Platform skills

Tools

Power BI

SQL Server Reporting Services (SSRS)

Visual Studio

Job description

This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.

REPORTING TO: Applications and Data Manager

HOURS: 09.00 - 17.00, Monday - Friday

LOCATION: London, Manchester or Harrogate (Hybrid Working, 2 days per week in office)

Overview

With 250 staff and lawyers working across five offices nationwide, Hempsons is a leading law firm for the health and social care, charity, and social enterprise sectors.

We help our clients tackle a constantly changing array of opportunities and challenges - never more so than now.

Our aim is to provide outstanding legal services that deliver the best possible client outcomes whilst nurturing a culture that makes us a "great place to work".

The role

We are seeking an experienced and proactive Senior Applications Analyst to support the management, development, and optimisation of our core legal applications and data systems. The successful candidate will join the Applications and Data team who are responsible for ensuring business-critical applications are maintained, upgraded, and integrated effectively.

Working alongside the other Applications Analysts in the team, reporting to the Applications and Data Manager, you will contribute to the day-to-day support of Legal applications, you will also be involved in key projects to deliver new applications to the business. You will be given the opportunity to work with innovative technologies, including Generative AI and Data Analytics, that support the firm's wider business strategy.

This is a wide-ranging role including project work that will drive innovation and change within the firm. These projects will have lasting impact on how the firm provides legal services.

This is a Hybrid working role that requires the Senior Applications Analyst to attend the office at least 2 days a week. Additional days may be required in the office to support specific tasks and projects.

Please note that the job description is not exhaustive and may vary in line with changes in the team's objectives and firm's policy.

Core duties and responsibilities, although not limited to

The Senior Applications Analyst, alongside the wider Applications and Data Team is responsible for maintaining and developing the firm's core legal application systems. You will possess hands‑on expertise in Aderant Expert, Legal Case Management applications and Microsoft 365, including workflow optimisation, system integrations, and low‑code development using the Power Platform. You will also have experience with SQL Server administration and reporting and be comfortable designing secure data integrations across business platforms.

You will also be a point of technical escalation for the IT Service Desk Team and other Applications Analysts; a high level of technical proficiency is required to succeed in this role.

Key responsibilities

Key responsibilities include but are not limited to:

Technical Responsibilities

The Senior Applications Analyst and the Applications and Data Team are responsible for the following Legal application systems:

Aderant Expert

• Technical ownership of the firm's practice management system (PMS), including Expert Time.
• Create, maintain, and optimise workflows to support business processes.
• Manage and execute upgrades, patches, and system maintenance.
• Provide advanced troubleshooting and resolution of technical issues.
• Deliver and oversee integrations with other legal systems.

Visual Files

• Oversee the configuration, maintenance, and development of Visual Files case management system.
• Database Administration (SQL).
• Maintain and support SQL Server databases underpinning core business applications.
• Ensure data integrity, security, and performance optimisation.

Reporting

• Write, maintain, and optimise SQL queries and reports.
• Build, manage and maintain Power BI dashboards and data flows.
• Provide accurate data and reporting solutions to stakeholders across the firm.

Artificial intelligence

• Developing capabilities utilising the firm's chosen Generative AI platform.
• Collaborating with the AI working group to identify AI use cases.
• Creating playbooks to support AI use cases.
• Developing Prompt Engineering capabilities within the Applications Team.
• AI knowledge transfer to the IT training team and AI champions within the business.

Microsoft 365

• Maintain and support the firm's SharePoint intranet.
• Continued development of the firm's Client Portals solution built on SharePoint and Aderant Drive.
• Low‑code development utilising the Power Platform - Power Apps / Power Automate / Power BI.

Application Development

• Maintain and support bespoke applications, services and background processes, using C#, PowerShell, Python, ASP, VBScript + other similar programming languages.
• Develop bespoke solutions to meet business requirements where out of the box solutions are not available.
• Comfortable working within Visual Studio or similar IDE's.

Cyber Security

• Ensuring that cyber security best practices are adhered to in application configuration and development.
• Adhering to and maintaining the firm's Cyber Security standards in the context of legal application systems.
• Understanding of ISO27001 and Cyber Essentials Plus. The entire IT Team are expected to contribute to maintaining adherence to these standards.

Essential Skillset

• Proven administration of Aderant Expert including workflow optimisation and system integrations.
• Hands‑on experience with Microsoft 365, SharePoint Online, and Power Platform (Power Apps, Power Automate, Power BI).
• Comfortable working in Public Cloud environments (Microsoft Azure, AWS etc.).
• Strong SQL Server management and SQL reporting (SSRS) skills for accurate data and MI delivery.
• Practical knowledge of designing and supporting data integrations across legal and business systems.
• Familiarity with IT change, release, and service management frameworks for reliable operations.
• Consistent application of access, security, and data protection policies in line with firm standards.
• Creation of high‑quality documentation and facilitating knowledge sharing across teams.
• Familiarity with ISO27001 and Cyber Essentials Plus.

Core Technical Skills

• Aderant Expert PMS.
• Aderant Expert Time.
• Microsoft 365 - SharePoint Online and Power Platform.
• Microsoft Azure - Server management, and fundamentals.
• Microsoft SQL Server and SSRS.
• Microsoft Desktop and Server Operating Systems.
• Basic Application Development.
• Scripting / Programming (C# & PowerShell at a minimum).

Desirable

• Visual Files CMS.
• Experience enabling generative AI use cases, creating playbooks, and prompt engineering.

Key communication and Relationships

• Reports to the Applications and Data Manager.
• Works alongside the Applications and Data team and the IT Training Team.
• Provides technical escalation for the IT Service Desk.

What can we offer you?

Our benefits package is designed to enable all colleagues to thrive in an inclusive and supportive environment. These benefits include holiday purchase scheme, private health insurance, life assurance & critical illness cover protection, season ticket loans, cycle-to-work scheme and much more.

Hempsons is an equal opportunities employer

Hempsons is committed to providing equal opportunities for all and to encouraging diversity through recruitment. Applications are welcome from all sections of the community and decisions to progress will be made with reference to entirely objective criteria only.