Lead Analyst - FP&A Investment Planning
Avangrid
Lead analyst managing FP&A investment planning, capital project portfolio, forecasting and reporting.
17 days ago ago
$103,939 - $129,924
Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
United States Of America, Connecticut, Orange
Office Full-Time
Company Size
7,999 Employees
Service Specialisms
Renewable Energy
Power Generation
Transmission
Distribution
Energy Storage
Engineering
Project Management
Operations & Maintenance
Sector Specialisms
Energy
Renewable Energy
Electricity Transmission
Electricity Distribution
Smart Grids
Grid Infrastructure
Power Generation
Natural Gas Utilities
Role
What you would be doing
spreadsheet modeling
dashboard development
portfolio monitoring
process improvement
data analysis
stakeholder communication
- 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 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.
- 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.
- 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.
- 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.
- 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. May be required to present monthly results and projections, discuss issues and agree to 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.
What you bring
advanced excel
vba
power platform
clarity ppm
bachelor's
process automation
- Seven years of experience in finance, project management, engineering, or related field.
- 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
- Proven experience in data analysis, reporting, and process improvement
- Process modeling, automation, and data optimization.
- Thorough knowledge of CapEx and Plant Addition forecasting, budgeting and analysis.
- Required Bachelor’s degree in a related discipline such as finance, engineering, business, data science, or related field
- Advanced Excel skills, with experience reading and writing VBA code
- Customer Centric (internal and/or external)
- 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.
- Admin experience with Clarity PPM or similar
- Experience with Microsoft Power Platform, Power Query, SharePoint and all Microsoft Office Application
- 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.
- Tuition Assistance
- Award winning student loan debt repayment program
- Opportunities for professional development, career advancement, and internal mobility
- Supportive and inclusive work environment
- Comprehensive benefits - including medical, dental, vision and variety of well-being programs
- Competitive salary and performance-based bonuses
- Generous PTO policy
- 12% 401(k) Match
Information not given or found
Interview process
Information not given or found
Visa Sponsorship- applicants who are not citizens must comply with immigration requirements to work.
Information not given or found
People also searched
Data Analyst Jobs in New Haven United StatesBusiness Analyst Jobs in New Haven United StatesAnalytics Manager Jobs in New Haven United StatesBusiness Analytics Jobs in New Haven United StatesFinancial Analyst Jobs in New Haven United StatesData Analyst Jobs in Bridgeport United StatesBusiness Analyst Jobs in Bridgeport United StatesAnalytics Manager Jobs in Bridgeport United States
Company
Overview
47 Billion
Assets Under Management
Total value of company assets across all operations.
3.3M+ Customers
Electric & Gas Users
Over 3.3 million customers served across New York and New England.
10.0 GW
Power Generation Capacity
Combined electricity output from owned and operated facilities.
- Born in 2015 from a merger with UIL Holdings, creating a national powerhouse from regional utilities.
- Headquartered in Orange, Connecticut, with operations in 24 U.S. states.
- Its utilities arm manages eight electric and natural gas systems.
- Projects include onshore wind, solar, biomass, thermal plants, and grid upgrades.
- Fully acquired by Iberdrola in late 2024, enhancing investment potential.
- Key ventures include the nation's largest offshore wind project and the Maine Power upgrade.
- Combines local legacy with large-scale clean energy ambition.
- Sustainable: We seek to be a model of inspiration for creating economic, social and environmental value in our communities and we act positively to affect local development, generate employment, and give back to the community.
- Agile: We act efficiently and with passion to drive innovation and continuous improvement at both the local and global level.
- Collaborative: We work together toward a common purpose and mutual benefit while valuing each other and our differences.
By 2030
Carbon Neutrality Target
The company aims to achieve carbon neutrality for Scopes 1 and 2.
9.3 GW
Emissions-Free Capacity
Installed capacity in wind and solar energy.
10 GW
Energy Goal
Target to generate 10 GW of emissions-free energy capacity by 2025.
70%
Emissions Reduction Goal
Aim to reduce emissions intensity by 70% by 2030 compared to 2015 levels.
- One of the country’s cleanest utilities.
- Compliance Leader Verification certification by Ethisphere Institute for third consecutive term.
2024
Forbes Recognition
Recognized as one of Forbes America’s Best Employers for Diversity in the 2024 ranking.
300M Spend
Supplier Diversity Goal
Aim to increase spend with certified diverse suppliers to $300 million by 2025, up from $195 million in 2022.
- DEI strategy focus areas: increasing diverse representation (especially in leadership), promoting equitable growth opportunities, establishing pathways for community and connection.
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio