Power BI Developer

Freeths; Nottingham; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading law firm in Nottingham is seeking a skilled Power BI Developer to design and maintain business intelligence solutions. The ideal candidate will excel in data modeling and DAX, creating impactful reports that support various teams. This role offers an opportunity to work in a collaborative environment and contribute to building innovative applications with Microsoft technologies. A degree in a related field and relevant certifications are preferred, along with strong problem-solving abilities.

Qualifications

• Proven experience delivering enterprise-grade Power BI solutions in professional services.
• Strong proficiency in DAX, Power Query, and data modeling.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design and build data ingestion pipelines from various source systems.
• Create dashboards and reports based on stakeholder requirements.
• Ensure accuracy and security of data across reports.

Skills

Business Intelligence

Power BI

SQL

Data Modeling

Data Warehouse

Education

Degree in Data / Computer Science, Information Systems or equivalent

Microsoft Certified: Power BI Data Analyst Associate (PL300)

Tools

Power BI Desktop

Power BI Service

SQL databases

Azure SQL

Azure DevOps

Job description

About the Team

We’re a collaborative and forward‑thinking Applications Development Team that builds modern solutions using Microsoft technologies like Power Platform and Microsoft 365. Our team values clean code, continuous learning and delivering real impact through smart, scalable applications. If you’re passionate about Microsoft’s ecosystem and want to work in a supportive, innovative environment, we’d love to hear from you.

About the Role

We are seeking a skilled Power BI Developer to design, develop and maintain business intelligence solutions that transform data into actionable insights. The ideal candidate will have strong experience in data modelling, DAX and visualization best practices with the ability to collaborate across teams to deliver high‑quality reporting solutions. You will build solutions that support partners, fee earners, Finance, BD / Marketing and Risk & Compliance teams while upholding client confidentiality, ethical walls and regulatory obligations.

Key Responsibilities

• Design and build robust data ingestion pipelines from source systems (PMS, DMS, CRM, HR, conflicts / risk).
• Integrate data from multiple sources including SQL databases, APIs and cloud services.
• Build and optimize datasets and semantic models using various schemas for performance and scalability using legal & financial data.
• Write complex DAX measures and calculations to support advanced analytics.
• Create high‑utility dashboards and paginated / interactive reports that follow data storytelling and visualisation best practices.
• Maintain master data alignment (clients, matters, timekeepers, practice groups) and controlled reference data. Ensure data accuracy, consistency and security across all reports.
• Collaborate with stakeholders across Finance, Projects and the business to gather requirements and translate them into technical solutions.
• Ensure version‑controlled solutions utilising source control (Azure DevOps repos / GIT).
• Monitor and optimise Power BI service performance and scheduled refreshes.
• Stay up to date with Power BI updates, features and best practices.

Skills and Experience

• Proven experience delivering enterprise‑grade Power BI in law firm or professional services settings.
• Strong proficiency in:
  • Power BI Desktop & Power BI Service
  • DAX (Data Analysis Expressions)
  • Power Query (M language)
• Solid understanding of data modelling, star schema and ETL processes.
• Experience with Microsoft Fabric, Synapse, Azure SQL, Data Lake for scalable datasets.
• Knowledge of GDPR, ISO 27001, SRA / AML implications for data processing and reporting.
• Familiarity with source control solutions including Azure DevOps / GIT.
• Strong analytical and problem‑solving skills.
• Excellent communication and stakeholder management skills.
• Familiarity with legal PMS, CMS, CRM and HR systems including Dynamics 365, Aderant, Sierra and Workday.

Desirable Qualifications

• Degree in Data / Computer Science, Information Systems, Analytics or equivalent experience.
• Microsoft Certified: Power BI Data Analyst Associate (PL300) preferred; DP500 (Azure Enterprise Data Analyst) a plus.

Smart. Bold. Together. We Are Freeths.

Become part of the team at Freeths.

View some of our recent highlights on our website here.

Do we sound like a match? If you’re someone who cares deeply, communicates openly and collaborates effectively, then we’d love to have you join our diverse, inclusive team.

Key Skills

• Business Intelligence
• Cognos
• SQL
• Power BI
• QlikView
• Microsoft SQL Server
• ssrs
• Tableau
• SSIS
• T Sql
• Data Modeling
• Data Warehouse

Employment Type: Full Time

Experience: years

Vacancy: 1