Lead Analyst - FP&A Investment Planning
Avangrid
Lead analyst managing FP&A investment planning, portfolio monitoring, reporting, and data analysis.
16 days ago ago
$103,939 - $129,924
Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Orange, CT
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
data analysis
process improvement
data architecture
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
What you bring
clarity ppm
power platform
excel vba
sharepoint
bachelor’s degree
7+ years
- 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.
- Admin experience with Clarity PPM or similar
- Process modeling, automation, and data optimization.
- Experience with Microsoft Power Platform, Power Query, SharePoint and all Microsoft Office Application
- Advanced Excel skills, with experience reading and writing VBA code
- 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.
- 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.
- Thorough knowledge of CapEx and Plant Addition forecasting, budgeting and analysis.
- Strong analytical thinking and problem-solving skills
- Required Bachelor’s degree in a related discipline such as finance, engineering, business, data science, or related field
- Proven experience in data analysis, reporting, and process improvement
- Customer Centric (internal and/or external)
- Seven years of experience in finance, project management, engineering, or related field.
- Award winning student loan debt repayment program
- Competitive salary and performance-based bonuses
- 12% 401(k) Match
- Supportive and inclusive work environment
- Opportunities for professional development, career advancement, and internal mobility
- Tuition Assistance
- Generous PTO policy
- Comprehensive benefits - including medical, dental, vision and variety of well-being programs
Information not given or found
Interview process
Information not given or found
Visa Sponsorship- applicants who are not citizens must comply with applicable immigration requirements to work in the country.
Information not given or found
People also searched
Data Analyst Jobs in New Haven United StatesBusiness Analyst 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 StatesBusiness Analytics Jobs in Bridgeport United StatesFinancial Analyst 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