Avangrid
Lead Analyst - FP&A Investment Planning
Avangrid
The base salary range for this position is dependent upon experience and location, ranging from $103,939 to $129,924.
Job Summary Responsibilities of the Investment Planning Team encompass a full range of forecasting, budget management, and investment analysis activities. The Reporting and Analytics Lead Analyst performs these functions to manage the portfolio of operating companies across Avangrid Networks to establish, report, monitor, and manage the company’s investment portfolio to financial targets. This role takes a cross-section of all the functional business lines and reviews the larger portfolio in relation to planned spend and regulatory commitments. It acts as a key contributor to the overall success of meeting the target portfolio by Operating Company, requiring depth and breadth of experience to interpret complex data sets and translate them into actionable insights that drive strategic decision-making. A successful candidate will embrace opportunities to take on new challenges, lead and motivate peers, and possess excellent analytical skills, a strong work ethic, and an ability to self‑task based on desired outcomes.
Key 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, while ensuring data accuracy, consistency, and integrity.
Develops, maintains, and automates recurring reporting tasks to enhance operational efficiency, including writing and refining VBA code across Excel and other Microsoft Office applications.
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, validates forecast accuracy, and develops interactive dashboards, graphics, charts, and data visualizations for presentations and reports.
Monitors compliance to performance indicators, approvals, and functional business area targets, analyzing and transforming datasets to identify trends and actionable insights.
Plans and organizes own workday and tasks with minimal supervision, initiating improvements to work practices or policies, and acting proactively with integrity.
Ensures compliance with project management practices and standards, assessing current project status and implementing tracking metrics.
Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolutions; may present monthly results and projections.
Required Qualifications
Bachelor’s degree in finance, engineering, business, data science, or related discipline.
Seven years of experience in finance, project management, engineering, or related field.
Proven experience in data analysis, reporting, and process improvement.
Broad analytical expertise across diverse business situations, comfortable using this expertise to help team members.
Strong analytical thinking and problem‑solving skills.
Experience with 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 applications.
Preferred Qualifications
Admin experience with Clarity PPM or similar.
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 (people managers/leaders)
Benefits
Award‑winning student loan debt repayment program
12% 401(k) match
Competitive salary and performance‑based bonuses
Comprehensive benefits – including medical, dental, vision, and well‑being programs
Tuition assistance
Opportunities for professional development, career advancement, and internal mobility
Supportive and inclusive work environment
Generous PTO policy
Company AVANGRID SERVICE COMPANY
Mobility Information Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.
At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law. If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our People and Organization department at careers@avangrid.com.
Job Posting End Date: November 4 2025
#J-18808-Ljbffr
The base salary range for this position is dependent upon experience and location, ranging from $103,939 to $129,924.
Job Summary Responsibilities of the Investment Planning Team encompass a full range of forecasting, budget management, and investment analysis activities. The Reporting and Analytics Lead Analyst performs these functions to manage the portfolio of operating companies across Avangrid Networks to establish, report, monitor, and manage the company’s investment portfolio to financial targets. This role takes a cross-section of all the functional business lines and reviews the larger portfolio in relation to planned spend and regulatory commitments. It acts as a key contributor to the overall success of meeting the target portfolio by Operating Company, requiring depth and breadth of experience to interpret complex data sets and translate them into actionable insights that drive strategic decision-making. A successful candidate will embrace opportunities to take on new challenges, lead and motivate peers, and possess excellent analytical skills, a strong work ethic, and an ability to self‑task based on desired outcomes.
Key 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, while ensuring data accuracy, consistency, and integrity.
Develops, maintains, and automates recurring reporting tasks to enhance operational efficiency, including writing and refining VBA code across Excel and other Microsoft Office applications.
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, validates forecast accuracy, and develops interactive dashboards, graphics, charts, and data visualizations for presentations and reports.
Monitors compliance to performance indicators, approvals, and functional business area targets, analyzing and transforming datasets to identify trends and actionable insights.
Plans and organizes own workday and tasks with minimal supervision, initiating improvements to work practices or policies, and acting proactively with integrity.
Ensures compliance with project management practices and standards, assessing current project status and implementing tracking metrics.
Communicates with business area leaders, executives, project teams, and peers to understand issues and propose resolutions; may present monthly results and projections.
Required Qualifications
Bachelor’s degree in finance, engineering, business, data science, or related discipline.
Seven years of experience in finance, project management, engineering, or related field.
Proven experience in data analysis, reporting, and process improvement.
Broad analytical expertise across diverse business situations, comfortable using this expertise to help team members.
Strong analytical thinking and problem‑solving skills.
Experience with 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 applications.
Preferred Qualifications
Admin experience with Clarity PPM or similar.
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 (people managers/leaders)
Benefits
Award‑winning student loan debt repayment program
12% 401(k) match
Competitive salary and performance‑based bonuses
Comprehensive benefits – including medical, dental, vision, and well‑being programs
Tuition assistance
Opportunities for professional development, career advancement, and internal mobility
Supportive and inclusive work environment
Generous PTO policy
Company AVANGRID SERVICE COMPANY
Mobility Information Please note that any applicant who is not a citizen of the country of the vacancy will be subject to compliance with the applicable immigration requirements to legally work in that country.
At Avangrid we provide fair and equal employment and advancement opportunities for all employees and candidates regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status, disability, protected veteran status or any other status protected by federal, state, or local law. If you are an individual with a disability or a disabled veteran who is unable to use our online tool to search for or to apply for jobs, you may request a reasonable accommodation by contacting our People and Organization department at careers@avangrid.com.
Job Posting End Date: November 4 2025
#J-18808-Ljbffr