Lead Analyst - PMO

Avangrid; City of Binghamton (NY); On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Benefits & growth opportunities

Performance bonuses

401(k) match

Health, dental, vision insurance

Tuition reimbursement

Professional development

Job summary

Avangrid seeks a Lead Analyst in PMO Analytics to drive analytics, reporting, and insights across the Project department. You will develop and maintain Power BI dashboards, KPIs, and executive-quality presentations, translating project, financial, and operational data into clear narratives for leadership.

You will collaborate with PMO, Finance, and project teams to improve data quality, standardize reports, and advance automation. Some travel may be required.

Qualifications

• Bachelor's degree with 7 years of relevant experience.
• Proficient in Power BI dashboards, data refresh & validation.
• Experience in project management or finance analytics.
• Advanced Excel and strong PowerPoint for executive presentations.
• Strong quantitative and analytical skills; data translation to insights.
• Self-directed with ability to meet deadlines and attention to detail.

Responsibilities

• Lead PMO analytics and reporting with accountability.
• Develop and enhance Power BI dashboards for projects.
• Integrate SAP data sources and automate reporting workflows.
• Validate data, define KPIs, maintain controls and SOX compliance.
• Provide training and mentoring on dashboards and data interpretation.
• Prepare executive presentations and portfolio reviews with clear narratives.

Skills

Power BI

Data analytics

Data validation

Excel

Presentation skills

Education

Bachelor's degree

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

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)

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

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