Senior Business Intelligence Analyst

Hill Dickinson LLP; Liverpool; On-site; GBP 65,000 - 95,000; Full time

Job summary

Hill Dickinson LLP in Liverpool is seeking a Senior Finance BI Analyst to drive end‑to‑end Power BI reporting within the Finance – Management Information team. The role focuses on replacing manual processes with automated, scalable solutions and real‑time insights across the business.

You will work closely with stakeholders to translate requirements into robust BI outputs, contribute to modernising legacy reporting, and help shape the future of the Finance BI function as it grows.

Qualifications

• Strong experience building end-to-end Power BI reports and dashboards.
• Advanced knowledge of Power BI, DAX, Power Query, Excel and SSRS.
• Microsoft Fabric awareness – understands key components and how Power BI integrates with them.
• Solid SQL skills for data extraction, transformation and analysis.
• Proven ability to turn business requirements into reporting solutions.
• Experience improving or replacing manual / Excel‑based processes.

Responsibilities

• Design, build and deliver end‑to‑end Power BI solutions, from data ingestion and transformation through to high‑quality dashboards.
• Apply strong data visualisation and UX principles to create intuitive, visually consistent outputs that drive actionable insight and decision‑making.
• Replace manual, Excel‑based processes with scalable, automated reporting solutions, enabling self‑service analytics.
• Develop robust, performant models using Power Query and best‑practice DAX, ensuring accuracy and maintainability.
• Extract, transform and manipulate data using SQL to support analytical and reporting requirements.
• Maintain, optimise and enhance existing SSRS reporting, ensuring continuity and modernisation where appropriate.
• Produce clear documentation to support auditability and knowledge transfer.
• Analyse operational and financial data to identify trends, risks and opportunities.

Skills

Power BI

DAX

Power Query

Excel

SSRS

Microsoft Fabric awareness

SQL

Tools

Aderant

Job description

Job role: Senior Finance Business Intelligence Analyst

Hours: Monday to Friday, 09:00 - 17:00 (35 hours per week)

Happy to talk flexible working

Hill Dickinson are proud to be named as a Top Ten Employer for Working Families 2025 for the second year running and so, we are happy to consider flexible working opportunities to help you balance your work and home life.

Team: Finance – Management Information

Location: Liverpool

Role Overview

We are looking for a Senior Business Intelligence Analyst to join our Finance Business Intelligence team.

This newly created role sits right at the centre of transformation as we move away from manual, fragmented, legacy reporting towards a modern, automated, and insight driven approach that supports real time decision making across the business.

This role is responsible for delivering end to end Power BI reporting, turning financial and operational data into clear, actionable insight.

You’ll focus on replacing manual processes with scalable, automated solutions and Power BI dashboards, while working closely with stakeholders to meet business needs. You’ll also play a key role in improving reporting, supporting self‑service analytics, and helping shape the future of the Finance BI function.

Key Responsibilities

• Design, build and deliver end‑to‑end Power BI solutions, from data ingestion and transformation through to high‑quality, production‑ready dashboards.
• Apply strong data visualisation and UX principles to create intuitive, visually consistent outputs that drive actionable insight and decision‑making.
• Replace manual, Excel‑based processes with scalable, automated and reusable reporting solutions, enabling enterprise‑wide self‑service analytics.
• Develop robust, performant models using Power Query and best‑practice DAX, ensuring accuracy, usability and maintainability.
• Extract, transform and manipulate data using SQL to support analytical and reporting requirements.
• Maintain, optimise and enhance existing SSRS reporting, ensuring continuity and modernisation where appropriate.
• Produce clear and comprehensive documentation (datasets, measures, models and reports) to support auditability, knowledge transfer and ongoing maintenance.
• Analyse operational and financial data to identify key trends, risks and opportunities, providing clear recommendations to stakeholders.
• Champion and embed self‑service BI capabilities across the organisation, driving adoption and improving data literacy.
• Partner with business stakeholders to define requirements and translate them into effective analytical solutions.
• Support the team in their legacy reporting
• Contribute to the development and long‑term strategy of the Finance Business Intelligence function, with scope to shape team structure and capability as it grows.

What Are We Looking For

Important criteria

• Strong experience building end‑to‑end Power BI reports and dashboards.
• Advanced knowledge of Power BI, DAX, Power Query, Excel and SSRS.
• Microsoft Fabric awareness – understands key components and how Power BI integrates with them.
• Solid SQL skills for data extraction, transformation and analysis.
• Proven ability to turn business requirements into reporting solutions.
• Experience improving or replacing manual / Excel‑based processes.
• Ability to collaborate effectively with cross‑functional teams.
• Good attention to detail and focus on data accuracy and quality.
• Ability to document work clearly.
• Ability to manage time, priorities and work independently
• Discretion, sensitivity, and confidentiality in handling data
• Strong communication skills – able to explain complex concepts clearly to non‑experts.

It would be beneficial to have some of the following

• Experience working within Finance
• Background in legal or professional services
• Knowledge of Aderant

Equality, Diversity and Inclusion

Hill Dickinson is committed to providing fairness and equal opportunity for all regardless of age, gender, gender identity, ethnic origin, disability, sexual orientation, marital or transgender status, nationality, religion or belief.

We understand that our power as a firm comes from empowering our people and that it is only by encouraging and enabling individuals to be themselves at work that we can truly benefit from their rich and varied strengths.

Hill Dickinson is an equal opportunities employer. All applications received by the firm will be considered based on their merit alone and we welcome applications from all suitably qualified individuals regardless of background and from all routes to qualification, with both the SRA and CILEx.

At Hill Dickinson, we welcome applications from individuals that are looking to return to the law as well as all routes to qualification, with both the SRA and CILEx.

Disability Support

We are a Disability Confident employer, which means if there is anything that we can do to make your visit easier, so you are able to perform at your best, please let us know. You can contact the HR team at [e-mail] should you require any adjustments to the application or interview process.

All successful candidates will be subject to our standard pre‑employment screening, including a basic criminal record check via Disclosure and Barring Service. Any offer of employment made is conditional upon completion of all checks.