Lead Analyst - FP&A Investment Planning

Responsibilities

• Maintains and tracks the portfolio of capital projects for Avangrid Networks companies.
• Audits and validates forecasts, monitors regulatory approvals, identifies gaps, and recommends course corrections.
• Manages structured data and tabular information within a Project Portfolio Management System, ensuring accurate and consistent data handling.
• Develops and automates recurring reporting tasks to enhance operational efficiency and reduce manual effort.
• Writes and refines VBA code in Excel and other Microsoft Office applications, debugging and troubleshooting issues to improve functionality.
• Recognizes and recommends process improvements and best practices to resolve business area and planning issues.
• Creates and maintains detailed spreadsheets to manage and analyze current and past trends, validating forecast accuracy and highlighting variances.
• Develops interactive dashboards, graphics, charts, and data visualizations for presentations, reports, and digital platforms.
• Monitors compliance to performance indicators, approvals, and functional business area targets.
• Analyzes, transforms, and processes datasets from multiple sources to identify trends, changes, and actionable insights.
• Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolutions.

Qualifications

• Required: Bachelor’s degree in a related field such as finance, engineering, business, data science, or related field.
• Required: Seven years of experience in finance, project management, engineering, or related field.
• Required: Proven experience in data analysis, reporting, and process improvement.
• Preferred: Admin experience with Clarity PPM or similar.
• Preferred: Thorough knowledge of CapEx and Plant Addition forecasting, budgeting, and analysis.