Portfolio Analyst

PTS Advance; Brentwood (TN); On-site; USD 70,000 - 95,000; Full time

Job summary

PTS Advance is seeking a Portfolio Analyst to optimize our portfolio management program. You will manage KPIs, budgets, and performance analysis while delivering executive-level reporting.

Proficiency in Power BI and Excel is essential for developing dashboards and insights. You will collaborate with finance, engineering, and operations to establish data standards, drive continuous improvement, and provide clear, actionable recommendations to leadership.

Qualifications

• Bachelor’s degree in Business, Finance, Engineering, Analytics, Project Management or related field.
• 3+ years of experience in portfolio analysis, project controls, business analysis, financial analysis, or program/project management.
• Strong experience managing and analyzing KPIs and performance metrics.
• Proficiency in Microsoft Power BI, including dashboard development, data visualization, and reporting.
• Experience developing and managing budgets, forecasts, and financial reporting.
• Strong analytical and problem-solving skills with the ability to interpret complex data.
• Advanced proficiency in Microsoft Excel.
• Strong communication and presentation skills.

Responsibilities

• Manage and maintain a comprehensive portfolio KPI framework, ensuring metrics are accurate, relevant, and aligned with business objectives.
• Advance and strengthen the current portfolio management program and foundational processes, identifying opportunities for standardization, automation, and continuous improvement.
• Develop, manage, and monitor portfolio budgets, forecasts, and financial performance.
• Analyze portfolio performance, identifying trends, risks, variances, and opportunities for improvement.
• Develop and maintain Power BI dashboards, scorecards, and reports to provide real-time visibility into portfolio health and performance.
• Translate complex data into clear, actionable insights for leadership and key stakeholders.
• Establish reporting standards and ensure consistent KPI definitions, data quality, and reporting methodologies across the portfolio.
• Partner with project managers, finance, engineering, operations, and other stakeholders to collect and validate portfolio data.
• Monitor actuals versus budget and forecast, investigate variances, and communicate financial impacts.
• Support portfolio planning, prioritization, resource allocation, and strategic decision-making.
• Develop recurring management reports and executive-level presentations.
• Identify gaps in current processes and recommend improvements to increase efficiency, data visibility, and decision-making capabilities.
• Support the development of standardized tools, templates, processes, and governance practices for the portfolio.
• Maintain documentation related to KPIs, budgets, reporting processes, and portfolio performance.
• Perform ad hoc financial, operational, and portfolio analysis as needed.

Skills

Power BI

KPI framework

Budgets/Forecasting

Data analysis

Excel

Cross-functional collaboration

Presentation skills

Education

Bachelor’s degree in Business, Finance, Engineering, Analytics, Project Management

Tools

Power BI

Excel

Job description

We are seeking a Portfolio Analyst to support the continued advancement and optimization of a portfolio management program. This role will be responsible for managing a comprehensive suite of KPIs, developing and maintaining budgets, analyzing portfolio performance, and helping establish the processes, reporting, and foundational framework needed to mature the current program.

The ideal candidate is highly analytical, proficient in Power BI, and comfortable working with large data sets to develop meaningful insights and executive-level reporting. This individual will partner with cross-functional stakeholders to improve visibility into portfolio performance, identify trends and opportunities, and drive continuous improvement.

Key Responsibilities

• Manage and maintain a comprehensive portfolio KPI framework, ensuring metrics are accurate, relevant, and aligned with business objectives.
• Advance and strengthen the current portfolio management program and foundational processes, identifying opportunities for standardization, automation, and continuous improvement.
• Develop, manage, and monitor portfolio budgets, forecasts, and financial performance.
• Analyze portfolio performance, identifying trends, risks, variances, and opportunities for improvement.
• Develop and maintain Power BI dashboards, scorecards, and reports to provide real-time visibility into portfolio health and performance.
• Translate complex data into clear, actionable insights for leadership and key stakeholders.
• Establish reporting standards and ensure consistent KPI definitions, data quality, and reporting methodologies across the portfolio.
• Partner with project managers, finance, engineering, operations, and other stakeholders to collect and validate portfolio data.
• Monitor actuals versus budget and forecast, investigate variances, and communicate financial impacts.
• Support portfolio planning, prioritization, resource allocation, and strategic decision-making.
• Develop recurring management reports and executive-level presentations.
• Identify gaps in current processes and recommend improvements to increase efficiency, data visibility, and decision-making capabilities.
• Support the development of standardized tools, templates, processes, and governance practices for the portfolio.
• Maintain documentation related to KPIs, budgets, reporting processes, and portfolio performance.
• Perform ad hoc financial, operational, and portfolio analysis as needed.

Required Qualifications

• Bachelor’s degree in Business, Finance, Engineering, Analytics, Project Management, or a related field.
• 3+ years of experience in portfolio analysis, project controls, business analysis, financial analysis, or program/project management.
• Strong experience managing and analyzing KPIs and performance metrics.
• Proficiency in Microsoft Power BI, including dashboard development, data visualization, and reporting.
• Experience developing and managing budgets, forecasts, and financial reporting.
• Strong analytical and problem-solving skills with the ability to interpret complex data.
• Advanced proficiency in Microsoft Excel.
• Strong communication and presentation skills.
• Ability to work effectively with cross-functional teams and senior stakeholders.
• Strong attention to detail and ability to manage multiple priorities.