Data Analyst

Data Analyst - SQL, Data Analysis, Dimensional Modelling, Database Administration, SQL Scripting, Performance Tuning, Azure, ETL, Data Warehousing. Permanent. London Hybrid (3/2). c.£80k-£85k + Bonus + Benefits, Global Law Firm seeks an experienced Data Analyst to join its Business Systems team, supporting and developing a business-critical data and reporting platform. You’ll work across an Enterprise Data Warehouse, Microsoft Azure and SQL-based data environments, helping the firm analyse, structure, optimise and manage data while ensuring platforms remain reliable, scalable and aligned with evolving business requirements.

The role combines Data Analysis and Dimensional Modelling, SQL Engineering / Database Administration, and Stakeholder Liaison - gathering, defining and maturing data requirements across the business. You’ll work extensively with SQL, data structures, ETL processes and Azure-based services, with additional exposure to Power BI/Fabric as part of the wider reporting environment., * Analyse complex datasets and translate business requirements into structured data solutions.

• Design and maintain dimensional data models, data warehouse structures and associated data flows.
• Develop and optimise SQL scripts, stored procedures, functions and database objects.
• Undertake SQL performance tuning, query optimisation and troubleshooting across business-critical databases.
• Support database administration activities including configuration, access, monitoring, maintenance and performance.
• Develop and maintain ETL processes and integrations using Azure Data Factory.
• Support administration and operation of Azure-based data services and associated environments.
• Work with stakeholders to gather, define and mature data and reporting requirements.
• Troubleshoot data quality, integration and performance issues across multiple systems.
• Support Power BI, semantic models and reporting solutions where required.

We’re looking for candidates with strong SQL, Data Analysis and Data Engineering experience combined with the ability to work confidently with business stakeholders. You will possess:

• Expert SQL skills including complex scripting, stored procedures, functions, XML and JSON data types.
• Strong experience of SQL query optimisation, troubleshooting and performance tuning.
• Good database administration experience within SQL Server or comparable enterprise database environments.
• Strong understanding of Dimensional Modelling and Data Warehouse methodologies including Kimball and Inmon.
• Experience analysing, transforming and validating complex business data.
• Experience building ETL processes and integrations using Azure Data Factory.
• Good knowledge of Microsoft Azure and administration of cloud-based data services.
• Strong stakeholder engagement skills with the ability to gather and translate complex data requirements.
• Excellent communication and documentation skills with the ability to explain technical concepts to non-technical audiences.
• Experience with Power BI, DAX, semantic models or Microsoft Fabric would be useful but is not the primary focus of the role.
• Experience of DevOps, CI/CD and deployment pipelines would be advantageous.
• Experience within Legal Services, Financial Services, Banking or another highly regulated professional services environment would be desirable.

This is an excellent opportunity to join a Business Systems team working across multiple systems and departments where you’ll combine hands-on SQL development, Data Analysis, Dimensional Modelling, Database Administration, Azure and ETL engineering to help shape and improve a strategically important enterprise data platform.

Experience gained within Law Firms, Legal Services, Legal Application Vendors, Systems Integrators or Consultancies is welcomed but non-essential. We can also consider candidates from Financial Services, Banking, Investment Banking, Exchanges and wider Professional Services environments. Skills

• Azure Active Directory
• DAX (Data Analysis Expressions)
• ETL (Extract Transform Load)
• Power BI
• SQL
• SQL Server (SSIS/SSAS/SSRS)
• Stakeholder Engagement