Lead Portfolio Analyst - Data Analytics

Summer-Browning Associates Ltd; London; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading consultancy is seeking a Lead Portfolio Analyst for a hybrid role in London. The successful candidate will have a strong background in data analytics and portfolio planning, with essential skills in data reporting and advanced Excel tools. This 14-month assignment requires active SC Clearance and offers a dynamic work environment focused on government projects.

Qualifications

• Extensive experience in analysing portfolio data and data reporting.
• Highly proficient in Excel-based tools and Power Platform.
• Strong understanding of the Treasury's Five Case Model.

Responsibilities

• Develop and maintain portfolio dashboards and plans.
• Model the impact of changes to the portfolio plan.
• Support strategic planning and portfolio development.

Skills

Data Analytics

Portfolio Planning

Data Reporting

Data Visualisation

Excel

Power BI

Strategic Planning

Education

Active SC Clearance

Tools

Power Pivot

Power Automate

Power BI Desktop

Power BI Service

Job description

LEAD PORTFOLIO ANALYST - DATA ANALYTICS

Summer-Browning Associates is currently assisting our central government client, seeking a Lead Portfolio Analyst for an initial 14-month assignment.

Location: Hybrid working - London

Essential Skills: The ideal candidate will hold active SC Clearance and have a proven background in Portfolio Planning and Data Analytics, with the following skills and experience:

• Extensive experience in analysing portfolio data, data reporting, and data visualisation.
• Highly proficient in Excel-based tools, with advanced capabilities in the Power Platform, including Power Pivot, Power Automate, Power BI Desktop, and Power BI Service.
• Experienced in developing portfolio dashboards and maintaining accurate portfolio plans, modelling the impact of changes to the portfolio plan.
• Experience in portfolio planning, development, and maintenance of portfolio plans, as well as strategic planning.
• Strong understanding of the Treasury's Five Case Model/Green Book.
• Knowledge of RIBA (Royal Institute of British Architects) is desired.
• Familiarity with construction and capital estate projects is desired.

To apply, please submit your latest CV for review.