Business Intelligence Developer

Comtecs Group; Greater London; Hybrid; GBP 80,000 - 90,000; Full time

Benefits offered by this job

Bonus

Benefits

Job summary

Comtecs IT Recruitment Division seeks a skilled Business Intelligence Developer for a London-based Law Firm. The role focuses on SQL, ETL, and Power BI development across an Enterprise Data Warehouse, leveraging Azure Data Factory and Microsoft BI tools to deliver reliable, scalable insights.

The role emphasizes translating business requirements into BI solutions, strong stakeholder engagement, and experience with data modelling and governance.

Qualifications

• Expert SQL skills including complex queries and data types.
• Strong ETL design and data integration experience.
• Proficient in Power BI report and dashboard development with DAX.
• Experience with Azure Data Factory for data integration.
• Understanding of data warehousing concepts (Kimball/Inmon).
• Ability to translate business needs into BI solutions and communicate with stakeholders.

Responsibilities

• Develop and maintain SQL, data warehouse structures and ETL processes using Azure Data Factory.
• Design and develop Power BI reports, dashboards and semantic models using DAX.
• Engage with stakeholders to gather, define and mature BI requirements.
• Translate business needs into practical BI solutions and reporting capabilities.
• Support integrations using Azure Data Factory, including REST API and OData connections.
• Troubleshoot complex issues and drive continuous improvements.
• Manage changes, documentation, security, governance and third-party relationships.

Skills

SQL

ETL

Power BI

DAX

Data Warehousing

Reporting & Dashboards

Stakeholder Liaison

Tools

Azure Data Factory

Tabular Editor

DAX Studio

ALM Toolkit

DevOps

CI/CD

Job description

Business Intelligence Developer - SQL, ETL, Power BI, DAX, Azure Data Factory, Data Warehousing, Reporting & Dashboard Development. Permanent. London Hybrid (3/2). c.£80k -£90k + Bonus + Benefits

Global Law Firm seeks an experienced Business Intelligence Developer to join its Business Systems team, supporting and developing a business-critical BI Reporting and data platform. You'll work across an Enterprise Data Warehouse, Microsoft Power BI/Fabric and Azure Data Factory, helping the firm turn data into meaningful business insight while ensuring applications remain reliable, scalable and aligned with evolving business needs.

NOTE: This vacancy is offered by the IT Recruitment Division of Comtecs and is based at a Law Firm in London.

The role has three key pillars: SQL Engineering / ETL, Power BI Report & Dashboard Development, and Stakeholder Liaison – gathering, defining and maturing requirements for Business Intelligence. You'll combine strong technical capability with excellent stakeholder skills, translating business requirements into effective data solutions and communicating technical concepts clearly to non-technical users.

Key Responsibilities:

• Develop and maintain SQL, data warehouse structures and ETL processes using Azure Data Factory.
• Design and develop Power BI reports, dashboards and semantic models using DAX.
• Work with stakeholders to gather, define and mature Business Intelligence requirements.
• Translate business needs into practical BI solutions, enhancements and reporting capabilities.
• Support integrations using Azure Data Factory, including REST API and OData connections.
• Troubleshoot complex technical issues and proactively identify opportunities for improvement.
• Manage application changes, documentation, security, governance and third-party relationships.

We're looking for candidates with strong Business Intelligence, Data Engineering and Power BI experience, combined with the ability to engage confidently with business stakeholders. You will possess:

• Expert SQL skills including stored procedures, functions, XML and JSON data types.
• Strong understanding of Data Warehouse methodologies such as Kimball and Inmon.
• Strong Power BI report and dashboard development and DAX skills, including semantic modelling and paginated reports.
• Experience building ETL and integrations using Azure Data Factory.
• Strong stakeholder engagement skills with the ability to gather and translate BI requirements.
• Excellent communication and documentation skills, with the ability to explain technical concepts to non-technical audiences.
• Experience with Tabular Editor, DAX Studio and ALM Toolkit would be desirable.
• Experience of DevOps, CI/CD and deployment pipelines would be advantageous.
• Experience within the legal sector or another highly regulated environment is desirable.
• Experience with aspects of MS Fabric will be useful as the platform is being rolled out across the environment.

This is an excellent opportunity to join a Business Systems team working across multiple systems and depts within the firm where you'll combine hands-on SQL and ETL engineering, Power BI development and business-facing requirements gathering to help shape and improve a highly important Business Intelligence and data platform.

Experience gained in Law Firm, Legal Services, Legal Application Vendors / Systems Integrators or Consultancies welcomed but non-essential. We can consider experience from Financial Services, Banking / Investment Banking (London Stock Exchange, London Metal Exchange etc) as well as from within wider professional services environments.