Portfolio Finance & Data Analyst

We are supporting a major global financial markets organisation with the appointment of a Portfolio Finance & Data Manager into its Group Portfolio Management Office. Sitting at the intersection of Finance, Data and Transformation, this role will take ownership of the financial management and analytical oversight of a c.$70m portfolio of business and technology change. This is a high-visibility position for someone who enjoys going beyond traditional reporting: improving how data is used, automating processes and providing senior stakeholders with the insight needed to make better investment and prioritisation decisions.

Responsibilities

Act as the financial and analytical lead across a significant portfolio of programmes and projects, partnering closely with Project Managers, Finance and senior stakeholders; Own the monthly portfolio forecasting and reporting cycle across a c.$70m change portfolio; Produce insightful variance, cost and performance analysis to support senior decision-making; Support annual budgeting, portfolio prioritisation and ongoing financial planning; Partner with Financial Accounting through month-end, including accruals, journals, cost allocations and capitalisation; Act as a key steward of portfolio data, creating a reliable single source of truth across finance and project reporting; Build and enhance dashboards and management information using Power BI, Power Query and advanced Excel; Partner with Project and Programme Managers on budgets, forecasts, funding and financial governance; Conduct financial and execution health checks across major programmes; Identify opportunities to automate manual reporting and finance processes using Power Automate, VBA, macros and other automation tools; Help optimise PPM tooling and improve the integration of project, portfolio and financial data; Continuously improve the controls, processes and reporting framework underpinning portfolio management

Requirements

Strong financial fundamentals and excellent data and analytical capability; 4–7+ years' experience across financial analysis, management/project accounting, portfolio finance or a similar environment; Strong understanding of P&L, accruals, prepayments, cost allocation, budgeting and forecasting; Experience working within a technology, transformation, change or project-led environment; Advanced Power BI, Power Query and Excel capability; Track record of building dashboards, improving reporting and turning complex data into actionable insight; Experience partnering with PMOs, Programme Managers and Project Managers; Interest in automation and process improvement

Nice to have

Exposure to Power Automate, VBA or similar; Exposure to SQL and PPM platforms such as Clarity, Planview or Project Online; ACA, ACCA, CIMA or equivalent qualification