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.
• 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 enhancements 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.
• Maintains 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, understand the operational environment and adapt accordingly, and act proactively and with integrity.
• Assesses current project status, implements tracking metrics, and assesses the effects on portfolio.
• Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolution.
• Builds rapport, actively listens, and creates an atmosphere of approachability to facilitate information sharing.

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.
• Required: Strong analytical thinking and problem-solving skills.
• Required: Process modeling, automation, and data optimization.
• Required: Advanced Excel skills, with experience reading and writing VBA code.
• Preferred: Admin experience with Clarity PPM or similar.
• Preferred: Thorough knowledge of CapEx and Plant Addition forecasting, budgeting, and analysis.