Commercial Finance Analyst/Business Partner

Marks Sattin; United Kingdom; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading financial consultancy in the United Kingdom is seeking an experienced Finance Analyst. In this pivotal role, you will support budgeting, forecasting, and performance analysis, while ensuring robust data governance. The ideal candidate will have proven experience in financial modelling and reporting, with advanced Excel and Power BI skills. This position offers a competitive salary, hybrid working options, and a supportive company culture.

Benefits

Competitive salary

Bi-annual bonus scheme

Private health

Hybrid working (40% WFH)

Qualifications

• Proven experience in FP&A, financial modelling, and reporting.
• Advanced Excel skills (Power Query, VBA, formulas).
• Experience with a recognised cloud-based ERP system.

Responsibilities

• Support budgeting, forecasting, and scenario modelling.
• Deliver performance analysis through KPI dashboards.
• Ensure strong controls over financial data.

Skills

Financial Planning & Analysis

Data Governance

Advanced Excel

Power BI

Communication Skills

Education

Qualified Accountant (preferred)

Tools

Excel

Power BI

Cloud-based ERP Systems

Job description

Our client are seeking a experienced Finance Analyst to lead the development of advanced reporting solutions and ensure robust data control across their financial systems.

This is a brand new role, a fantastic opportunity to join a forward-thinking team and play a pivotal role in shaping the group's financial reporting and analytics capabilities.

Your key responsibilities will be as follows:

Financial Planning & Analysis

• Support budgeting, forecasting, and scenario modelling using advanced Excel and Power BI techniques.
• Deliver performance analysis through KPI dashboards, variance reports, and trend insights.
• Prepare and enhance board and management reporting packs with accurate, timely, and visually engaging data.
• Partner with operational teams to provide financial insight and challenge assumptions.

Data Governance & Integration

• Ensure strong controls over financial data from source systems to reporting outputs.
• Collaborate with data teams to align financial models with business needs and integrate with their cloud based ERP and other data sources.

Technical Reporting & Analytics

• Build complex Excel models using Power Query, VBA, and advanced formulas.
• Develop interactive Power BI dashboards with real-time analytics.
• Design scalable financial data models and contribute to data architecture for optimal reporting.

Management Information (MI)

• Enhance trading MI reporting with increased granularity in revenue and cost analysis.
• Standardise group-wide reporting frameworks for business partnering and board support.
• Expand reporting capabilities to include predictive analytics and scenario modelling.

Development & Operational Reporting

• Track sales funnel activity, project progress, and conversion metrics.
• Monitor staff data including headcount, productivity, and cost analysis.
• Integrate reporting for acquisitions and group-wide performance.
• Analyse net working capital including receivables, payables, inventory, and cash flow.

They are ideally looking for a candidate with proven experience in FP&A, financial modelling, and reporting, a qualified Accountant is preferred but not essential, especially if you have previous experience in a project related industry. You will ideally have advanced Excel skills (Power Query, VBA, formulas) and Power BI expertise, or experience with a recognised cloud based ERP system. Excellent communication and stakeholder engagement skills are non-negotiable however, along with a passion for data integrity and continuous improvement.

In return, you will be offered a competitive salary and benefits package including bi-annual bonus scheme, hybrid working (40% WFH and core hours policy), private health and a great company culture!