PMO Analytics Lead - Power BI & Exec Reporting

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

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