Lead Analyst - Pmo

Iberdrola SA

Chestfield

On-site

GBP 60,000 - 75,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Competitive benefits and growth机会
Generous performance-based bonuses
12% 401(k) match
Comprehensive health, dental, and vis­
Tuition reimbursement
Professional development and clear kar

Job summary

ROCHESTER GAS & ELEC CORP, part of Avangrid Networks, seeks a Lead Analyst - PMO Analytics to drive analytics, dashboards and reporting for the Project department. You will develop and maintain Power BI dashboards, integrate SAP data, and support executive presentations and portfolio reviews.

Working with PMO, Finance and leadership, you will standardize reporting, improve data quality, automate workflows, and mentor teams on data interpretation and visualization.

Qualifications

  • Proven ability to develop, maintain and support Power BI dashboards and reports.
  • Experience using SAP data for project and financial reporting.
  • Strong Excel and PowerPoint skills for executive presentations.

Responsibilities

  • Lead PMO analytics and reporting initiatives with accountability for timely, accurate deliverables.
  • Develop, maintain and enhance Power BI dashboards tracking project and portfolio performance.

Skills

Power BI dashboards
SAP data integration
Excel
PowerPoint
Data analytics

Education

Bachelor's degree in engineering, finance, business, economics, data analytics, information systems, or a related field

Tools

SAP
SQL
Power BI

Job description

Location: On site 5 days a week in Binghamton or Rochester, NY The base salary range for this position is dependent upon experience and location, ranging from $79,680 to $99,600 What We Offer:

  • Competitive benefits and growth opportunities
  • Generous performance‑based bonuses
  • 12% 401(k) match
  • Comprehensive health, dental, and vision insurance
  • Tuition reimbursement
  • Professional development and clear career advancement pathways

For more information please visit: Benefits - Avangrid

Job Summary

The Lead Analyst - PMO Analytics provides analytical expertise and decision support for the Project department within the Avangrid Networks Organization. This role leads the development, maintenance and enhancement of Power BI dashboards, analytical tools, and performance reporting to translate project, financial, and operational data into actionable insights. The position is responsible for Project department presentation development, including executive presentations, portfolio reviews, and management reporting materials that clearly communicate performance, risks, trends, and priorities. Working closely with project teams, PMO, Finance, and leadership, the Lead Analyst strengthens data quality, standardizes reporting, and advances reporting automation and continuous improvement. The qualified candidate must demonstrate critical thinking, problem solving, collaboration, and agility. May require travel.

Key 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.
Required Qualifications
  • Bachelor's degree in engineering, finance, business, economics, data analytics, information systems, or a related field with 7 years of relevant experience, or equivalent combination of education and experience.
  • Demonstrated proficiency in 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, with demonstrated 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 translation of complex data into actionable insights.
  • Ability to apply project management and financial concepts to KPI development, portfolio reporting, and continuous improvement of PMO analytics.
  • Must be self‑directed, demonstrate initiative, and 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.
Preferred Qualifications
  • Advanced degree
  • Certification as a Project Management Professional (PMP) or similar credential preferred.
  • Microsoft Power BI certification
  • SQL experience
  • Experience supporting utility capital project analytics and executive presentations are also preferred.
Competencies
  • Growth & Continuous Improvement
  • Initiative & Change
  • Focused on Results
  • Customer Centric (internal and/or external)
  • Communication
  • Collaboration
  • Leadership (people managers/leaders)

#LI-OFFICE #LI-ER1

Company:

ROCHESTER GAS & ELEC CORP

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. Avangrid employees may be assigned a system emergency role and in the event of a system emergency, may be required to work outside of their regular schedule/job duties. This is applicable to employees that will work in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate functions. This does not include those that will work for Avangrid Power. Avangrid employees may also be assigned a NERC Reliability Standards compliance role supporting Critical Infrastructure Protection (CIP) and/or Operations and Planning (O&P) responsibilities. This is applicable to employees that will work in electric transmission, operations, and cyber security business areas in Connecticut, Maine, Massachusetts, and New York within Avangrid Network and Corporate business areas. NERC Reliability Standards compliance roles and responsibilities may include additional access protections, training, audit engagement, and required evidence retention, and will be communicated by the employee’s management. Job Posting End Date: November-28-2026

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Program Manager - Nwa/Npa
Program Manager - Nwa/Npa

Iberdrola SA • Chestfield

On-site
GBP 85,000 - 110,000
401(k) match 12%
Health, dental, and vision insurance
Tuition reimbursement
+2
Project Manager - Hydro Engineering
Project Manager - Hydro Engineering

Iberdrola SA • Chestfield

On-site
GBP 73,000 - 91,000
Pm - Major Construction
Pm - Major Construction

Iberdrola SA • Chestfield

On-site
GBP 80,000 - 100,000
Competitive benefits and growth
Generous performance-based bonuses
401(k) match 12%
+3
Sr Pm - Major Construction
Sr Pm - Major Construction

Iberdrola SA • Chestfield

On-site
GBP 88,000 - 111,000
Coordinator - Field Construction
Coordinator - Field Construction

Iberdrola SA • Chestfield

On-site
GBP 61,000 - 75,000
Competitive benefits
Bonuses
12% 401(k) match
+2
Lead Engineer - Electric System Eng
Lead Engineer - Electric System Eng

Iberdrola SA • Chestfield

On-site
GBP 88,000 - 110,000
12% 401(k) match
Comprehensive health, dental, and &amp
Tuition reimbursement
+1
Manager - General Services
Manager - General Services

Iberdrola SA • Chestfield

On-site
GBP 80,000 - 100,000
Health, dental, vision
Tuition reimbursement
Career development
+2
Senior Cyber Operations Analyst
Senior Cyber Operations Analyst

Iberdrola SA • Chestfield

On-site
GBP 80,000 - 100,000
Competitive benefits and growth
Bonuses
401(k) match
+3
Lead Engineer - Interconnections
Lead Engineer - Interconnections

Iberdrola SA • Chestfield

On-site
GBP 79,000 - 98,000
Great benefits
Sign-on bonus
Relocation assistance
Project Manager - Energy Land Management
Project Manager - Energy Land Management

Iberdrola SA • Chestfield

On-site
GBP 70,000 - 91,000
Health insurance
Dental insurance
Vision insurance
+4