Lead Analyst – FP&A Investment Planning

Iberdrola

Lead Analyst handling investment planning and budget management for Avangrid's projects. Analyzing data trends and financial forecasts within the investment portfolio to meet targets.

Posted 5/21/2026full-timeOrange • Connecticut, Maine, New York • 🇺🇸 United StatesSenior💰 $96,400 - $132,500 per yearWebsite

Tech Stack

Tools & technologies

VBA

About the role

Key responsibilities & impact

Monitors and controls the portfolio of capital projects for Avangrid Networks companies.
Oversees and manages structured data and tabular information within a Project Portfolio Management System.
Demonstrates expertise in data architecture and relational principles.
Develops, maintains, and automates recurring reporting tasks to enhance operational efficiency.
Proficient in writing and refining VBA code across Excel and other Microsoft Office applications.
Recognizes and recommends innovative process improvements and best practices.
Creates and maintains detailed spreadsheets to manage and analyze trends to targets.
Develops interactive dashboards, graphics, charts, and data visualizations for presentations, reports, and digital platforms.
Monitors compliance to performance indicators, approvals, and targets.
Analyzes, transforms, and processes datasets to identify trends and actionable insights.
Plans and organizes own workday and tasks working without direct supervision.

Requirements

What you’ll need

Bachelor’s degree in a related discipline such as finance, engineering, business, data science, or related field
Seven years of experience in finance, project management, engineering, or related field.
Proven experience in data analysis, reporting, and process improvement
Candidates should have broad experience leveraging their analytical expertise in a wide variety business situation and feel comfortable using this expertise to help other team members.
Strong analytical thinking and problem-solving skills
Process modeling, automation, and data optimization.
Advanced Excel skills, with experience reading and writing VBA code
Experience with Microsoft Power Platform, Power Query, SharePoint and all Microsoft Office Application

Benefits

Comp & perks

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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architectureVBAdata analysisreportingprocess improvementprocess modelingautomationdata optimizationExceldata visualization

Soft Skills

analytical thinkingproblem-solvingorganizational skillsindependent workcommunication