Lead Analyst - FP&A Investment Planning

Responsibilities

• Maintains and controls the portfolio of capital projects for Avangrid Networks companies.
• Audits trends, validates forecasts, tracks regulatory approvals, identifies gaps, and recommends course corrections.
• Manages structured data and tabular information within a Project Portfolio Management System, supporting the tracking of actuals, approvals, forecasts, and budgets.
• Develops, maintains, and automates recurring reporting tasks to enhance operational efficiency and minimize manual efforts.
• Writes and refines VBA code across Excel and other Microsoft Office applications, proficient in debugging and troubleshooting issues.
• Recognizes and recommends innovative 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 compiled from multiple sources to identify trends, changes, and actionable insights.
• Plans and organizes own workday and tasks working without direct supervision to initiate change to work practices or policies or their own personal working style.
• Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolution.

Qualifications

• Required: Bachelor’s degree in a related discipline 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.
• Required: Broad experience leveraging analytical expertise in a wide variety of business situations.
• Preferred: Admin experience with Clarity PPM or similar.
• Preferred: Thorough knowledge of CapEx and Plant Addition forecasting, budgeting, and analysis.

Benefits

• Competitive benefits and growth opportunities
• Generous performance-based bonuses
• 12% 401(k) match
• Comprehensive health, dental, and vision insurance
• Tuition reimbursement
• Professional development and clear career advancement pathways