Database and BI Developer

TN United Kingdom; London; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

An established industry player is seeking a skilled Data & BI professional to enhance their data infrastructure. In this role, you'll work within a dynamic team to develop and optimize databases, data warehouses, and business intelligence systems that drive value across the firm. Your expertise in SQL Server, Power BI, and ETL tools will be crucial as you ensure data integrity and security while delivering innovative data solutions. Join a forward-thinking organization that values technical excellence and a collaborative approach to problem-solving, where your contributions will make a significant impact on client service and operational efficiency.

Qualifications

• Strong SQL Server experience with a focus on performance tuning.
• Experience building BI solutions using Power BI or SSRS.

Responsibilities

• Maintain SQL Server databases for reliable access and performance.
• Develop and optimize BI solutions for data presentation.

Skills

SQL Server

T-SQL

Power BI

SSRS

ETL

Azure Data Factory

Power Platform

Python

Tools

Microsoft SSIS

Azure DevOps

Spark

Job description

Social network you want to login/join with:

Term: Permanent
Reports to: Head of IT
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 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 to maximise the value of the firm's data.

Responsibilities

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

Skills and Experience

Technical Skills:

• Strong SQL Server experience, including writing T-SQL and performance tuning.
• Experience building BI solutions and dashboards using Power BI or SSRS.
• ETL experience with tools such as Microsoft SSIS, Power Platform, Fabric, Azure Data Factory, Azure DevOps, Notebooks, Spark/Python, APIs.

Experience:

• Previous legal experience preferred, especially with 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; self-starter capable of working independently and in teams.
• Innovative, flexible, with a strong customer service ethic.
• Confident manner and personal impact to command respect.
• Energy and enthusiasm for managing new initiatives.

Special Aspects

• Standard office hours are 09:30 to 17:30, Monday to Friday, with flexibility for additional hours as needed.
• On-site or remote evening and weekend work may be required for system maintenance and support.
• Farrer & Co operates an agile working framework, with at least 40% of working hours in the office; more may be expected depending on circumstances.
• We are an equal opportunity employer and welcome candidates from all backgrounds. Adjustments during the interview process are available upon request.

Comments

Farrer & Co conducts pre-employment screening, including criminal history and credit checks for successful candidates.