Lead Analyst - FP&A Investment Planning

Lead Analyst - FP&A Investment Planning page is loaded## Lead Analyst - FP&A Investment Planning locations:
United States Of America, Connecticut, Orange posted on:
Posted Todaytime left to apply:
End Date:
March 7, 2026 (16 days left to apply) job requisition :
R-23700

The base salary range for this position is dependent upon experience and location, ranging from $106,000 to $132,500
** Job Summary
** Responsibilities of the Investment Planning Team encompass a full range of forecasting, budget management, and investment analysis activities. The Reporting and Analytics, Lead Analyst performs these functions to manage the portfolio of operating companies across Avangrid Networks to establish, report, monitor, and manage the company’s investment portfolio to financial targets.

This role takes a cross-section of all the functional business lines and reviews the larger portfolio in relation to planned spend and regulatory commitments. This role acts as a key contributor to the overall success of meeting the target portfolio by Operating Company and this success requires depth and breadth of experience to interpret complex data sets and translate them into actionable insights that drive strategic decision-making.

A successful candidate will embrace opportunities to take on new challenges and be comfortable leading and motivating their peers. Additionally, the successful candidate has excellent analytical skills, a strong work ethic, and an ability to self-task based on a desired outcome rather than step by step instruction.
** Key Responsibilities
*** Monitors and controls the portfolio of capital projects for Avangrid Networks companies. This includes creating an initial plan, assessing trends, validating forecasts, tracking regulatory approvals, identifying gaps, and recommending course corrections.
* Oversees and manages structured data and tabular information within a Project Portfolio Management System, supporting the tracking of actuals, approvals, forecasts, and budgets. Demonstrates expertise in data architecture and relational principles, ensuring efficient handling of large datasets while upholding data accuracy, consistency, and integrity.
* Develops, maintains, and automates recurring reporting tasks to enhance operational efficiency and minimize manual efforts. Proficient in writing and refining VBA code across Excel and other Microsoft Office applications. Skilled in debugging and troubleshooting issues, delivering creative solutions, and continuously optimizing functionality for improved performance.
* Recognizes and recommends innovative process improvements and best practices to resolve business area and planning issues. Incorporates the use of new or enhancement of current tools to accomplish process improvements to increase efficiency, accuracy, and timeliness.
* Creates and maintains detailed spreadsheets to manage and analyze current and past trends to targets, validating forecast accuracy, and highlighting variances. Develops interactive dashboards, graphics, charts, and data visualizations for presentations, reports, and digital platforms. This requires an in-depth experience and knowledge of projects within a particular area of expertise, phases of those projects, and projected in-service dates across multiple years of data.
* 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. Develops reports and summarizes findings using thoughtful, user-friendly techniques that support strategic decision-making.
* 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, understand the operational environment and adapt accordingly, and act proactively and with integrity.
* Understands, applies and ensures compliance with project management practices and standards. Possess the ability to assess current project status, implement tracking metrics, and assess the effects on portfolio.
* Communicates with business area leaders,…