Lead Analyst - Pmo

Lead Analyst - Pmo

Full-Time 79680 - 99600 £ / year (est.) Hybrid
Iberdrola SA

At a Glance

  • Tasks: Lead analytics for project management, creating impactful Power BI dashboards and reports.
  • Company: Join Avangrid, a leader in energy solutions with a focus on innovation.
  • Benefits: Enjoy competitive salary, generous bonuses, health insurance, and tuition reimbursement.
  • Other info: Dynamic work environment with clear pathways for career advancement.
  • Why this job: Make a real difference by transforming complex data into actionable insights.
  • Qualifications: Bachelor's degree and 7 years of relevant experience in analytics or project management.

The predicted salary is between 79680 - 99600 £ per year.

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
  • 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 Power Point 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

Lead Analyst - Pmo employer: Iberdrola SA

ScottishPower is an exceptional employer, offering a supportive work culture that prioritises employee well-being and professional growth. With a strong benefits package, including a generous pension scheme and opportunities for career progression across various disciplines, employees can thrive in a dynamic environment dedicated to creating a cleaner, greener energy future. Located in the heart of Scotland, our projects not only contribute to significant infrastructure developments but also align with our commitment to sustainability and community engagement.

Iberdrola SA

Contact Details:

Iberdrola SA Recruitment Team

StudySmarter Expert Advice🤫

We think this is how you could land Lead Analyst - Pmo

✨Get to Grips with Data Visualisation Tools

If you're aiming for a full-time role in business intelligence, brush up on your skills with popular data visualisation tools like Tableau or Power BI. Showcasing projects where you've transformed raw data into clear visual insights can give you a real edge.

✨Join Local Business Intelligence Meetups

Look for local business intelligence meetups or analytics conferences in your area. These events are not just great for learning but also for networking with industry professionals who could lead you to opportunities at companies like Iberdrola SA!

✨Engage with Online BI Communities

Join online forums or communities focused on business intelligence—think LinkedIn groups, Reddit threads, or even dedicated Slack channels. Engage actively by sharing your insights and asking questions; this can help you build visibility and connect with potential employers.

✨Leverage Your University’s Career Support

If you're a recent graduate, definitely tap into your university's career services. Many have connections with companies in need of full-time BI specialists, and they can guide you on how to pitch yourself effectively—don't miss out on that!

We think you need these skills to ace Lead Analyst - Pmo

Power BI
Data Analysis
Project Management
Financial Reporting
SAP
Excel
PowerPoint

Some tips for your application 🫡

Highlight Your Analytical Skills:In the business intelligence field, showcasing your analytical skills is a must. Make sure your CV includes relevant experience with data analysis tools, programming languages like SQL or Python, and any projects where you've interpreted complex data sets to drive business decisions.

Showcase Your Business Acumen:Don't just focus on data; show us how you can apply your insights to real-world business problems. Highlight projects where you made a tangible impact on company performance, and be prepared to explain your thought process in your cover letter.

Tailor Your Documents for Us:When applying for a full-time role at Iberdrola SA, tailor your CV and cover letter to reflect our organisational goals and strategies. Mention specific tools and methodologies that align with what we do—this shows you’ve done your homework and are genuinely interested in our mission!

Include Relevant Certifications:Certifications like Google Data Analytics or similar qualifications can really make you stand out in business intelligence. Include these in your application, as they demonstrate your commitment to the field and your willingness to stay current with industry standards.

How to prepare for a job interview at Iberdrola SA

✨Show off your analytical skills

In a business intelligence role, you're going to need to demonstrate your analytical prowess. Be prepared to discuss specific tools you've used, like SQL, Tableau, or Power BI. Have real-world examples ready where you’ve turned data into actionable insights – this is what makes us shine in interviews!

✨Practice your technical know-how

Expect some technical questions during the interview that dive deep into your understanding of data modelling and analytics frameworks. Brush up on your knowledge of data warehousing concepts and be ready to tackle any real case scenarios they might present. They’ll want to see how you approach problems using your BI toolkit.

✨Portfolio of Projects

Since it's a full-time role, having a strong portfolio is key! Compile case studies demonstrating your previous projects, preferably showing how your insights led to business improvements. This can help us display how you think through complex datasets and your problem-solving process, which is what employers are keen on seeing.

✨Know their business model

Get familiar with Iberdrola SA’s business model and recent data-driven decisions. Be prepared to discuss how your skills can specifically support their objectives or challenges. Understanding their landscape shows that you’re not just a data buff, but you’re also genuinely interested in how BI can impact their bottom line.