Finance Reporting Business Intelligence Lead

Fieldfisher; Belfast City District; Hybrid; GBP 80,000 - 110,000; Full time

Benefits offered by this job

Private medical insurance

Health cash plan

Dental insurance

Life assurance

Critical illness insurance

Matched pension contributions up to 7%

Holiday trading

Job summary

Fieldfisher is seeking an experienced Finance Reporting & Business Intelligence Lead to own and evolve the firm’s Finance reporting and BI platform. You will partner with Finance, Business Services and IT Data Engineering to shape the roadmap for Power BI and Fabric-based reporting, security and governance, delivering a trusted single source of truth for leadership and practice groups.

The role requires advanced Power BI development, semantic modelling, and strong SQL/DAX skills to manage

Qualifications

• Advanced Power BI development with DAX and SQL
• Experience building enterprise-scale semantic models and reporting datasets
• Strong understanding of financial reporting, budgeting and KPI reporting
• Experience delivering secure, scalable enterprise reporting solutions in Fabric/Power BI environment
• Ability to translate complex financial data into actionable insights
• Knowledge of Fabric security and data governance concepts

Responsibilities

• Own and lead Finance Power BI and Microsoft Fabric reporting estate
• Develop, maintain and enhance dashboards, reports and semantic models
• Deliver reporting across revenue, WIP, billing, debtors, profitability, budgeting and financial performance
• Partner with Finance stakeholders to define reporting requirements, KPIs and insights
• Ensure reporting accuracy through validation, reconciliation and controls
• Lead transformation and rationalisation of Finance reporting landscape
• Maintain reporting governance, security, standards and best practices
• Establish sustainable support, documentation and operational processes
• Provide reporting support, training and guidance to business users

Skills

Power BI development

DAX

SQL

Semantic modelling

Financial reporting

Stakeholder engagement

Data governance

Tools

Microsoft Fabric

Lakehouse

Direct Lake

Security governance

Job description

Overview

Fieldfisher is seeking an experienced Finance Reporting & Business Intelligence Lead to own and evolve the firm's Finance reporting and business intelligence platform.

Working closely with Finance, Business Services and IT Data Engineering, the successful candidate will lead the development, governance and optimisation of Power BI and Microsoft Fabric reporting solutions, semantic models and management information that support Partners, Finance leadership and Practice Groups. The role will assume ownership of reporting assets delivered through the Finance reporting transformation programme and drive the strategic roadmap for future reporting and analytics capabilities

Responsibilities

The role will primarily include, but is not limited to, the below tasks:

• Own and lead the Finance Power BI and Microsoft Fabric reporting estate.

• Develop, maintain and enhance dashboards, reports and semantic models.

• Deliver reporting across revenue, WIP, billing, debtors, profitability, budgeting and financial performance.

• Partner with Finance stakeholders to define reporting requirements, KPIs and insight needs.

• Ensure reporting accuracy through robust validation, reconciliation and quality controls.

• Lead the transformation and rationalisation of the Finance reporting landscape, eliminating duplication and establishing a trusted single source of truth.

• Maintain reporting governance, security, standards and best practices.

• Establish sustainable support, documentation and operational processes to ensure reporting solutions remain scalable, auditable and supportable.

• Provide reporting support, training and guidance to business users.

Experience & Knowledge

• Advanced Power BI development expertise, including DAX, Power Query, SQL and semantic modelling.

• Extensive experience developing, optimising and supporting complex enterprise-scale semantic models and reporting datasets, including large finance data models containing 20+ tables, complex relationships and multiple reporting subject areas.

• Advanced T-SQL development skills, including tables, views, stored procedures, query tuning and performance optimisation.

• Strong understanding of financial reporting, budgeting, management information, KPI reporting and financial performance analysis.

• Experience managing large-scale Finance reporting environments, including dashboard rationalisation, legacy report migration, reporting governance and support operating models.

• Strong expertise in Microsoft Fabric and Power BI, including Lakehouse architecture, Direct Lake, semantic models, data integration, security, governance and platform administration, with responsibility for delivering secure, scalable and supportable enterprise reporting solutions.

• Expert knowledge of Fabric security, including workspace roles, app audiences, item permissions and Row-Level Security (RLS).

• Strong understanding of authentication and connectivity methods, including OAuth, Service Principals, Managed Identities and Workspace Identities.

• Experience designing, implementing and supporting Lakehouse tables, Direct Lake storage mode, semantic model optimisation and refresh strategies.

• Understanding of D365 Finance & Operations data structures, entities and reporting requirements is desirable.

• Experience validating, reconciling and analysing financial data to ensure reporting accuracy, integrity and consistency across multiple systems and data sources.

• Ability to translate complex financial and operational data into clear, actionable business insights and recommendations.

• Experience eliciting and documenting business requirements, facilitating stakeholder workshops and engaging effectively with senior business stakeholders.

• Knowledge of legal, professional services or partnership-based reporting environments is desirable.

• Self-motivated, organised and capable of taking ownership of solutions from design through to delivery, adoption and ongoing support.

Who are we looking for?

• We don't have a type. We believe our differences are our strength; varied cultures, approaches and experience can only benefit us.

What do we offer?

• You can be yourself: It takes everyone to make us who we are.
• In the office or WFH?: We think the best balance is more time in the office than at home, so we operate a 60:40 rule.
• Beyond salary: We offer plenty of benefits; private medical insurance, health cash plan, dental insurance, life assurance, critical illness insurance, matched pension contributions up to 7%, holiday trading, plus many more. Visit: Reward & Benefits ¦ Fieldfisher.
• Modern Office Space: Located on Adelaide Street in Belfast City Centre, with excellent commuter links and parking nearby.
• Nurturing your talent: Take a 'build a career' approach to your training. You'll be on a pathway but free to wander if you see something you'd like to study more closely.
• Funnel your interests: You have a life outside work, and we can help it to flourish. Join clubs, affinity networks, inclusive events, and pro bono/charity initiatives.

Inclusion at Fieldfisher

At Fieldfisher, inclusion is central to how we work. We are committed to creating a workplace where everyone feels respected, supported and able to succeed.

If you need any adjustments during the recruitment process or once you join us, we will work with you to put the right support in place. Examples include extra time for assessments, accessible document formats, alternative interview formats, quiet rooms, or physical and technological accessibility support.

For information about the accessibility features of our Belfast office, please visit Fieldfisher Belfast Office Accessibility Information

We recruit on a rolling basis. Your application may be reviewed before the application deadline. We accept applications until we have filled the role.