Lead Analyst - PMO

Iberdrola SA; City of Rochester (NY); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Bonuses

401(k) match

Health, dental, vision insurance

Tuition reimbursement

Professional development

Career advancement

Job summary

ROCHESTER GAS & ELEC CORP is seeking a Lead Analyst - PMO Analytics to drive PMO reporting, dashboards, and executive presentations. The role focuses on turning project, financial, and operational data into actionable insights for senior leadership, with an emphasis on data quality, automation, and continuous improvement.

You will own dashboard development, data integration with SAP, and the preparation of portfolio reviews and management reports, collaborating with PMO, Finance, and Project

Qualifications

• Bachelor's degree in engineering, finance, business, economics, data analytics, information systems, or a related field.
• 7+ years of relevant experience or equivalent combination of education and experience.
• Proficiency in developing, maintaining and supporting Power BI dashboards and reports, including data refresh, troubleshooting, data validation, and report access management; SAP data usage for project/financial reporting.
• Advanced Excel and PowerPoint with executive-ready presentations and effective data visualization.
• Strong quantitative/analytical skills: data preparation, queries, reconciliation, trend/variance analysis, and KPI development.

Responsibilities

• Lead PMO analytics and reporting initiatives with oversight for timely, accurate deliverables.
• Develop, maintain, and enhance Power BI dashboards tracking project/portfolio performance, budgets, expenditures, forecasts, schedules, and KPIs.
• Integrate SAP and other sources; automate data prep and improve reporting workflows and dashboard usability.
• Validate data, define KPI calculations, maintain controls, and support SOX/compliance.
• Provide training, user guidance, and mentoring on dashboards and data interpretation.

Skills

Power BI

SAP data

Excel

PowerPoint

Data analysis

Education

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

Tools

SQL

Job description

Lead Analyst - PMO# Iberdrola Group | Careers## Lead Analyst - PMOApply: United States Of America, New York, Rochester: United States Of America, New York, Binghamton: Full time: Posted Today: End Date: November 28, 2026 (17 days left to apply): R-34396**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,600What 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 [e-mail] 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**About Avangrid:** Avangrid, Inc. is a leading energy company in the United States working to meet the growing demand for energy for homes and businesses across the nation through service, innovation, and continued investments by expanding grid infrastructure and energy generation projects. Avangrid has offices in Connecticut, New York, Massachusetts, Maine and Oregon, including operations in 23 states with approximately $47 billion in assets, and has two primary lines of business: networks and power. Through its networks business, Avangrid owns and operates eight electric and natural gas utilities, serving more than 3.3 million customers in New York and New England. Through its power generation business, Avangrid owns and operates more than 75 energy generation facilities across the United States producing 10.5 GW of power for over 3.1 million customers. Avangrid employs approximately 8,000 people and has been recognized by JUST Capital as one of the JUST 100 companies – a ranking of America’s best corporate citizens – in 2025 for the fifth consecutive year. The company was named among the World’s Most Ethical Companies in 2025 for the seventh consecutive year by the Ethisphere Institute. Avangrid is a member of the group of companies controlled by Iberdrola, S.A. For more information, visit www.avangrid.com.