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.
Key Responsibilities:
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 qu...
Data Analyst employer: Comtecs Ltd Careers
As a leading global law firm, we pride ourselves on fostering a dynamic and inclusive work culture that prioritises employee growth and development. Our London-based team offers competitive salaries, comprehensive benefits, and the opportunity to work on cutting-edge cybersecurity projects in a collaborative environment, ensuring that you are at the forefront of the industry while making a meaningful impact on our clients' security posture.
