Lead Analyst PMO

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 a