Lead Analyst - FP&A Investment Planning

Base salary ranges by location:

• Orange, CT: $106,000 – $132,500
• Augusta/Portland, ME: $96,400 – $120,500
• Binghamton/Rochester, NY: $96,400 – $120,500

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

About the role

The Reporting and Analytics, Lead Analyst performs forecasting, budget management, and investment analysis activities to manage the portfolio of operating companies across Avangrid Networks. This role reviews the larger portfolio in relation to planned spend and regulatory commitments, acting as a key contributor to meeting the target portfolio by Operating Company. The position requires interpreting complex data sets and translating them into actionable insights that drive strategic decision-making.

Responsibilities

• Monitors and controls the portfolio of capital projects for Avangrid Networks companies, including 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.
• Debugs and troubleshoots issues, delivering creative solutions, and continuously optimizing functionality for improved performance.
• Recommends innovative process improvements and best practices to resolve business area and planning issues, incorporating new or enhanced tools to increase efficiency, accuracy, and timeliness.
• 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.
• 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, initiating changes to work practices or policies, adapting to the operational environment, and acting proactively and with integrity.
• Understands, applies, and ensures compliance with project management practices and standards, assessing current project status, implementing tracking metrics, and evaluating effects on the portfolio.
• Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolutions, building rapport and facilitating information sharing.
• May present monthly results and projections, discuss issues, and agree on course corrections.

Requirements

• Bachelor’s degree in finance, engineering, business, data science, or a related field.
• Seven years of experience in finance, project management, engineering, or a related field.
• Proven experience in data analysis, reporting, and process improvement.
• Broad experience leveraging analytical expertise in various business situations, comfortable using this expertise to assist team members.
• Strong analytical thinking and problem-solving skills.
• Experience with process modeling, automation, and data optimization.
• Advanced Excel skills, including reading and writing VBA code.
• Experience with Microsoft Power Platform, Power Query, SharePoint, and all Microsoft Office applications.

Preferred Qualifications

• Admin experience with Clarity PPM or similar tools.
• Thorough knowledge of CapEx and Plant Addition forecasting, budgeting, and analysis.

Competencies

• Growth & Continuous Improvement
• Initiative & Change
• Focused on Results
• Customer Centric (internal and/or external)
• Communication
• Collaboration
• Leadership (for people managers/leaders)

Applicants who are not citizens of the country of the vacancy will be subject to compliance with applicable immigration requirements to legally work in that country.