Lead Analyst - PMO

Iberdrola•Rochester, NY

1d•Onsite

About The Position

The Lead Analyst - PMO Analytics provides analytical expertise and decision support for the Project department within Avangrid Networks. The role leads the development, maintenance, and enhancement of Power BI dashboards, analytical tools, and performance reporting, turning project, financial, and operational data into actionable insights. It also owns Project department presentation development, including executive presentations, portfolio reviews, and management reporting that communicate performance, risks, trends, and priorities clearly. Working with project teams, PMO, Finance, technology teams, and leadership, the Lead Analyst strengthens data quality, standardizes reporting, and advances reporting automation and continuous improvement. The role requires critical thinking, problem solving, collaboration, and agility, and may require travel. The position is on site five days a week in Binghamton or Rochester, New York.

Requirements

Bachelor's degree in engineering, finance, business, economics, data analytics, information systems, or a related field with 7 years of relevant experience, or an equivalent combination of education and experience.
Demonstrated proficiency developing, maintaining, and supporting Power BI dashboards and reports, including data refresh, troubleshooting, data validation, and report access management.
Proficiency using SAP data for project and financial reporting.
Experience in project management, finance, analytics, or related subject matter, including hands-on maintenance of dashboards, analytical reporting, and management presentations.
Advanced Excel skills and strong PowerPoint proficiency, including the ability to develop executive-ready presentations and effective data visualizations.
Strong quantitative and analytical skills, including data preparation, database queries, reconciliation, trend and variance analysis, and translating complex data into actionable insights.
Ability to apply project management and financial concepts to KPI development, portfolio reporting, and continuous improvement of PMO analytics.
Self-directed, demonstrates initiative, and able to manage competing analytical and presentation deadlines with strong attention to detail.
Strong written, verbal, and presentation skills, with the ability to tailor technical findings and business narratives to project teams and executive leadership.

Nice To Haves

Advanced degree.
Project Management Professional (PMP) certification or similar credential.
Microsoft Power BI certification.
SQL experience.
Experience supporting utility capital project analytics and executive presentations.

Responsibilities

Lead PMO analytics and reporting initiatives with indirect supervision, initiative, and accountability for timely, accurate deliverables.
Develop, maintain, administer, and enhance Power BI dashboards tracking project and portfolio performance, budgets, expenditures, forecasts, schedules, and KPIs.
Integrate SAP and other approved data sources; automate data preparation and improve reporting workflows, analytical tools, and dashboard usability.
Validate and reconcile data, document KPI definitions and calculations, and maintain reporting controls and access supporting internal controls and SOX compliance requirements.
Provide training, user guidance, technical documentation, and mentoring on dashboards, data interpretation, visualization, and reporting best practices.
Own Project department executive presentations, portfolio reviews, and business reviews, translating complex data into clear visuals and decision-focused narratives.
Coordinate reporting and presentation calendars, templates, stakeholder inputs, and leadership reviews to ensure consistent messaging and timely, accurate materials.
Analyze trends, variances, risks, and root causes; present recommendations, assumptions, data limitations, and business implications to project teams and senior management.
Partner with Project, PMO, Finance, and technology teams to resolve data issues, align reporting priorities, translate stakeholder needs into dashboard requirements, and validate enhancements.
Perform other duties as assigned.