Solutions Developer; SQL​/PCMS

Knights is a listed, UK based legal and professional services business, operating from over 30 locations nationwide.

For more than a decade, we have done things differently. In 2012, we established our platform as one of the first law firms to transition from a traditional partnership model to a corporate structure.

We work with a diverse range of clients, including global brands, FTSE 100 companies, private businesses, and individuals, to deliver professional services with speed, accessibility, and clear communication.

This is a fantastic opportunity to be a part of a rapidly expanding company – one of the fastest growing law firms in the UK - where you will find excellent development opportunities and support to be the best you can be. We offer a competitive salary, modern surroundings, and great potential for career development.

Responsibilities include, but are not limited to:

• Develop, evolve and support a high‑volume, automated case management system used daily across operational services
• Work across live system support and delivery of planned system changes and improvements
• Investigate and resolve complex issues within live production environments
• Support workflow based case processing and rule‑driven system behaviour
• Identify recurring issues and implement preventative system improvements
• Use SQL to understand system behaviour and implement controlled fixes
• Produce clear, maintainable documentation that supports the wider development lifecycle and operational processes
• Prepare accurate high‑level and detailed estimates to support planning and delivery activities.
• Manage and progress multiple development tasks concurrently while maintaining quality and momentum.
• Build strong knowledge of the systems and applications you support, enabling effective troubleshooting and enhancement across internal and external platforms.
• Collaborate within a cross‑functional team to contribute to technical decisions and help shape solution design.
• Adapt effectively to evolving business needs and changing processes, maintaining a proactive and solution‑focused approach.

• Experience working with practice, case management, or workflow driven business systems
• Understanding of workflow driven case progression and rules based behaviour
• Experience supporting systems that manage cases, documents, and related operational data
• Strong understanding of Microsoft SQL Server
• Advanced T‑SQL skills
• Ability to write clean, efficient, readable and well documented code
• Proven experience creating and implementing effective testing approaches
• Experience of using code repositories
• Skilled in optimising complex SQL statements for performance
• Familiar with profiling tools
• Sense of ownership and pride in your performance and its impact on company’s success
• Previous experience of helping to deliver work items accurately and on time
• Critical thinker and strong problem-solving skills
• A proven team player, who is able to support others and who can adapt to changing and conflicting priorities
• The ability to prioritise high volumes of responsibilities without delays in deliverables
• A confident and effective communicator who is proactive, self‑motivated with a can‑do attitude
• Strong attention to detail and willing to expand your skill set in order to overcome existing challenges
• Exposure to professional services, financial services, legal, or regulated environments