Lead Analyst - FP&A Investment Planning
Scottish Power
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
5,750 across the UK Employees
Service Specialisms
Construction
Operation & Maintenance
Retail
Sector Specialisms
Power Grid
Renewables
Energy Retail
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
£9.5 billion
Annual Revenue 2023
Generated through operations in energy networks, renewables, and retail and wholesale energy services.
£8.4 billion
Annual Revenue 2022
Reflects the company's performance across various energy-related business units.
13.1%
Year-On-Year Growth
Increase in annual revenue from 2022 to 2023.
- Operates in electricity generation, transmission, and distribution and specialises in renewable energy, particularly onshore and offshore wind farms, and manages the transmission and distribution networks in South and Central Scotland, as well as parts of North Wales and North West England.
- Provides electricity and gas to residential, commercial, and industrial customers across the UK, offering services such as smart metering, energy efficiency advice, and home services like boiler care and maintenance.
- Has three main divisions: Energy Networks, Renewables, and Energy Retail and Wholesale.
- *SUSTAINABLE ENERGY:* Emphasises pioneering renewable energy, creating economic, social, and environmental value, with a commitment to safety, environmental respect, and ethical, rational, responsible actions.
- *INTEGRATING FORCE:* Acts as a dynamic and responsible force for change, fostering collaboration, sharing knowledge, encouraging diversity, and growing talent to achieve common goals.
- *DRIVING FORCE:* Focuses on bringing about efficient change by challenging processes, innovating for continuous improvement, and anticipating customer needs.
2040 Target
Net Zero Commitment
Committed to achieving net zero emissions by 2040.
100% Renewable
Clean Energy Production
All electricity generated from UK windfarms, ensuring a sustainable energy supply.
1,157 Turbines
Wind Energy Network
Operates a network of 1,157 turbines across onshore windfarms, contributing to significant renewable energy generation.
38 Windfarms
Energy Infrastructure
Maintains 38 onshore windfarm sites, supporting the transition to clean energy.
- ScottishPower is a leader in renewable energy.
- Enough electricity to power over 1.2 million homes, nearly half the homes in Scotland.
- Capacity to generate 1,948 MW of electricity.
35% Women Target
% of senior management roles
Target for women in senior management roles by 2030.
32% Female Representation
% in senior management
Increase in female representation in senior management from 26% in 2021 to 32% in 2022.
- Collaborates with several recognised organisations to enhance its commitment to diversity and inclusion, such as the Business Disability Forum, The Armed Forces Covenant, Carers UK, ENABLE Scotland, and POWERful Women. It holds the highest level of accreditation of the Armed Forces Covenant (Gold Status) and received the Inclusive Workplace Award from the Scottish Union of Supported Employment for two consecutive years.
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