Portfolio Analytics Associate (Hybrid)

Avantus; San Diego (CA); Hybrid; USD 65,000 - 90,000; Full time

Benefits offered by this job

401(k) matching

Medical & dental plan

Flexible PTO

Job summary

Avantus is seeking a data-driven Associate, Portfolio Analytics to support management of our utility-scale solar development portfolio, track performance, analyze portfolio-level trends, and support investment decisions across a growing pipeline of solar and storage assets.

The role reports to the Director, Project Controls and may fulfill related duties in their absence, requiring collaboration with development teams and strong Excel/Power BI skills.

Qualifications

• Four-year Bachelor's degree.
• 2–4 years of experience in project management and data analysis, preferably in utility-scale renewable energy.
• Experience contributing to the development and maintenance of project schedules.
• Expert proficiency in MS Office Suite (Excel and Power Point).
• Proficient in Power BI and similar data visualization tools.
• Knowledge of utility-scale solar and storage development life cycle.

Responsibilities

• Monitor and analyze the performance of solar development projects across various stages.
• Iterate on standard operating procedures for schedule creation and management.
• Create long and short-term analyses, including setting targets for milestones and deadlines.
• Consult with internal development team on schedule progress and accuracy of financial project data.
• Communicate the need for schedule adjustment as needed and make necessary updates at the direction of the project leads.
• Responsible for initial budget set-up and improvement of standard operating process for budget control across all phases of development within the organization’s established project management tool.
• Monitor schedule and budget variance.
• Create, maintain, distribute, and evaluate reports and dashboards.
• Collaborate with internal teams to ensure accurate and timely data updates.
• Perform regular project milestone time series analyses to identify trends and patterns integral in forecasting.
• Conduct analyses to evaluate portfolio health.
• Support scenario modeling and portfolio forecasting to inform strategic planning and capital allocation.
• Assist in preparing materials for internal presentations, board reviews, and external stakeholders.
• Contribute to the development of standardized portfolio management processes and tools.
• Identify trends, bottlenecks, and opportunities across the portfolio to improve efficiency and outcomes.

Skills

Data analysis

Project management

Communication

Cross-functional teamwork

Excel

Education

Bachelor's degree

Tools

Excel

Power BI

Primavera P6

Smartsheet

SQL

Asana

Job description

Avantus is seeking a data-driven Associate, Portfolio Analytics to support management of our utility-scale solar development portfolio, track performance, analyze portfolio-level trends, and support investment decisions across a growing pipeline of solar and storage assets.

The role reports to the Director, Project Controls and may fulfill related duties in their absence, requiring collaboration with development teams and strong Excel/Power BI skills.