Data & BI Developer

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.

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.

The purpose of this role is to work alongside our existing database analyst and together be responsible for the administration and optimisation of the firm’s database infrastructure.  The firm is looking to continue 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 and business intelligence systems which allow us to maximise the value of the firm's data.

• Install and maintain SQL servers and databases to ensure reliable access and excellent performance.
• Responsibility for the integrity, security, backup, disaster recovery and availability of database systems.
• Develop and support financial management reports built on a mixture of SSRS and Power BI reporting.
• Work with all other key business areas to devise, develop, and deploy required reports and business intelligence 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 Azure cloud services for the delivery of data solutions.

• Strong SQL server experience including writing TSQL and performance tuning is essential.
• Experience with Microsoft SSRS is also essential.
• ETL processes: experience with SSIS is essential and experience with Azure Data Factory would be helpful.
• Data analysis and data modelling.
• Experience of building front end BI solutions/dashboards using reporting and visualisation tools such as Power BI, SQL Server Reporting Services (SSRS), and Excel.
• Experience of working with APIs.
• Previous legal experience would be ideal, specifically knowledge of Aderant PMS and Intapp products, specifically Integration Builder.
• 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.
• Proven hands-on experience of developing BI solutions within a professional services environment, ideally a law firm but not essential.
• 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.

• 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.

• The hours of work for this opportunity are 9:30am - 5:30pm but we would expect the successful candidate to be committed, flexible and prepared to work beyond the normal office hours if necessary and in response to client demand. You will be expected to follow the firm’s agile working policy, which embraces home working but will require employees to spend a minimum number of days each week in the London office.

  Farrer & Co is open to flexible working by arrangement although this role is intended as a full-time position.

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