Lead Analyst – FP&A Investment Planning

Responsibilities

• 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.

• 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