Term: Permanent Reports to: Head of IT Systems Team: IT The Firm

Farrer & Co is synonymous with the highest quality legal advice and service.

We advise individuals, families, businesses, financial services, educational and not-for-profit organisations on every aspect of the law, wherever the need arises. From our offices in London we work with trusted professionals around the world to deliver a seamless international service.

Our clients present us with complex and varied challenges. Whether that's a complicated family trust issue, a multinational corporate transaction, or an emerging threat to their reputation, they need clear thinkers who can advise on the best solutions, fast thinkers when speed is of the essence and agile thinkers who can produce a fresh approach to get the job done. That's why they choose us.

Our clients value our in-depth knowledge, technical excellence and diversity of disciplines. But what really binds our long-standing relationships with them is our approach: pragmatic, plain speaking and always steadfast in our values, which we hold dear. Values which mean we gain our clients' trust, always strive to do the right thing, and aim for the best results for them.

Superb client service sits at the heart of everything we do. We are modern lawyers with timeless values.

The Team

As a progressive technology team, Farrers IT have delivered a number of industry firsts. We lead on cloud based systems and mobility, delivering projects and managing systems which allow our staff to work regardless of their location. Technology is key to our business, so proactive and forward thinking IT staff are essential elements in our success.

Scope

The purpose of this role is to work within our existing Data & BI team and together be responsible for the administration, development and optimisation of the firm’s data infrastructure. The firm is continuing to develop its use of business data and the methods used to present this to key clients and stakeholders across all areas of the business. The successful candidate will assist in strategically designing, developing, and implementing databases, data warehouses, data pipelines and business intelligence systems which allow us to maximise the value of the firm's data.

Responsibilities Maintain SQL Server databases to ensure reliable access and excellent performance. Responsibility for the integrity, security, backup, disaster recovery and availability of data systems. Maintain and develop existing BI solutions, a mixture of SSRS, Power BI, Power Apps and Power Automate. Work with all business areas to devise, develop, and deploy data products as needed. Oversee data integration across firm wide systems ensuring data quality and consistency. Document the data architecture and environment, in order to maintain a current and accurate view of the larger data picture. Act as technical lead or a technical resource on project work as required. Respond to and resolve database access and performance issues. Plan and coordinate data migrations between systems. Establish appropriate end-user database access control levels and perform database security audits. Where appropriate, leverage Microsoft cloud services (Azure, Power platform, Fabric) for the delivery of data solutions. Skills and Experience

Technical Skills:

Strong SQL server experience including writing TSQL and performance tuning is essential. Experience building BI solutions and dashboards using reporting and visualisation tools such as Power BI or SSRS. ETL experience; experience with some of the following would be expected: Microsoft SSIS Microsoft Power Platform Microsoft Fabric Azure Data Factory Azure DevOps Notebooks and Spark / Python APIs.

Experience:

Previous legal experience would be ideal, especially knowledge of Aderant PMS and Intapp products, specifically Integration Builder or Intapp Integration Services. Ability to build relationships and focus on delivering excellent customer service. Proactive, hands-on approach. A self-starter who can take the initiative and work both independently and collaboratively as part of a fully integrated team. Innovative and flexible with a strong customer service ethic. Confident manner and personal impact to command the respect of peers and colleagues. Energy and enthusiasm to manage new initiatives.

Special aspects Standard office hours are 09.30 to 17.30 Monday to Friday, but it is essential that the applicant is committed, flexible and prepared to work beyond the normal office hours when necessary and in response to demand. On-site or remote evening and weekend working should be expected as part of the role to accommodate system maintenance and support where necessary. Farrer & Co operates an agile working framework under which members of the firm are expected to spend at least 40% of their working hours in the office. This is a minimum expectation: individuals may elect or be asked or expected to work more frequently in the office, depending on circumstance. Farrer & Co is an equal opportunity employer which welcomes applications from candidates from all backgrounds. We look to employ the best candidates regardless of age, gender, race, ethnicity, social or economic background, religion, disability, sexual orientation, national origin, or any other protected characteristic. We are keen to ensure candidates have the best interview experience possible. If you require any adjustments during the interview or application process please let the recruitment team know. Comments

Farrer & Co conducts a pre-employment screening which consists of a Criminal History Background and Credit Check for successful candidates.