Portfolio Analyst

OVO Energy; West of England; Hybrid; GBP 35,000 - 50,000; Full time

Benefits offered by this job

Flex Pay 9%

34 days holiday

On-target bonus 15%

Green benefits

Job summary

OVO Energy in Bristol (hub-based London/Glasgow) is seeking a Portfolio Analyst to join the Portfolio Analytics team in Finance. You will manipulate large datasets on energy usage and revenue, build reports, and help identify cost leakages and opportunities to optimise margins.

Using SQL (BigQuery), Python, Git and Tableau, you will translate complex problems into clear insights, collaborate with senior stakeholders, and own parts of analysis from start to finish.

Qualifications

• Strong mathematical or analytical background.
• Confident handling and transformation of large data sets.
• Experience with core analysis technologies including SQL and Python.

Responsibilities

• Work in a team of analysts to deliver high-value projects.
• Manipulate large datasets on energy usage and financial data to produce reports.
• Identify leakage and opportunities to optimise costs and margins.
• Present insights to senior stakeholders and influence business decisions.

Skills

Analytical thinking

Data manipulation

SQL skills

Python programming

Attention to detail

Tools

SQL (BigQuery)

Python

Git

Tableau

Job description

Role OVO-View

Team: Portfolio Analytics

Salary banding: £35,000 - £50,000

Experience: Mid-level

Working pattern: Full-Time

Reporting to: Senior Portfolio Analyst

Sponsorship: Unfortunately we are unable to offer sponsorship for this role.

This role in 3 words: Impact. Collaboration. Ownership

Top 3 qualities for this role: Determined. Detail Oriented. Inquisitive

Location: Bristol

Where you'll work:

At OVO, we understand that a one size fits all approach doesn't work for everyone. That's why we created the OVO Way of Flexibility.

All our roles are hub based (Bristol, Glasgow or London), providing a dedicated space for collaboration, connection and teamwork. You'll also have the flexibility to work from home.

Everyone belongs at OVO

At OVO, we are on a mission to solve one of humanity’s biggest challenges, the climate crisis. And we know it takes all of us to change the world. That’s why we need diverse people from all abilities, gender identities, ethnicities, ages, sexual orientations, life experiences and backgrounds to join us.

Teamworking for the planet

Everything we do here spins around Plan Zero. So, naturally, the team you’ll be joining plays a gigantic role in making that happen. Here’s how:

The Portfolio Analytics team is responsible for providing clear, accurate and detailed reporting on our energy portfolio, including energy usage, revenues and costs. We seek to harness this data to identify opportunities to optimise costs or reduce leakages throughout the business.

By ensuring OVO can efficiently deliver value to its customers, the work the team does ensures OVO is able to invest in Plan Zero technologies. We perform analysis on energy usage trends to support the development of innovative tariffs and products.

This role in a nutshell

Working within the Portfolio Analytics team in Finance, you will work on diverse and high value projects impacting many areas of the business.

In Portfolio Analytics you will use modern analytic and data engineering tools, combined with a deep understanding of the industry, to solve critical problems throughout the business. We use a wide range of tools including SQL (Bigquery), Python, Git and Tableau. Technical development is a key focus within the team and we are always seeking to learn and implement the latest tools and best practices, as well as upskilling team members.

Working with senior stakeholders to understand, summarise and visualise complex problems, and using data to inform and influence business decisions, you can be guaranteed to have an impact in this role.

Your key outcomes will be:

You will work in a team of ~10 analysts with a wide range of skills and knowledge and will have the opportunity to work collaboratively on large projects as well as having ownership of processes and delivering analysis independently.

By manipulating large datasets of customer usage and financial data, you will provide detailed reporting and assurance on our revenue and costs, and identify leakages.

Within your first 6 months month you’ll:

• Have produced detailed analysis on high value business topics such as Revenue Leakage and Energy Gross Margin.
• Collaborated with other team members to develop expertise and deliver value in a wider range of areas.
• Raised your profile among key stakeholders.
• Gained insightful knowledge of the energy retail industry.

You’ll be a successful Portfolio Analyst

at OVO if you…

• Have a strong mathematical or analytical background
• Confident managing and manipulating large amounts of data
• Experience in core analysis technologies, ideally excellent SQL skills and programming with Python or similar.
• Drive to learn and develop new skills to suit the work
• Demonstrable high attention to detail
• Ability to take ownership of projects to build complex new models
• Transparent work that makes things simple for the wider team
• A creative thinker who thrives off direct responsibility and delivering value

Let’s talk about what’s in it for you

We'll pay you between £35000 and £50000, depending on your specific skills and experience. If your expectations are a little different, have a chat with us!

We keep our pay ranges broad on purpose to give us, and you, flexibility to match your experience to our zero carbon mission.

You’ll be eligible for an on-target bonus of 15%. We have one OVO bonus plan that focuses on the collective performance of our people to deliver our Plan Zero goal.

We also offer plenty of green benefits and progressive policies to help you feel like you belong at OVO... and there's flex pay. We'll give you 9% Flex Pay on top of your salary - 4% of this is auto enrolled into your pension, and the remaining 5% is yours to do what you like with. You can use this to buy from our extensive range of flexible benefits, including our green benefits which we have put at the heart of our offering, add to your pension or even take it as cash.

Here’s a taster of what’s on offer:

For starters, you'll get 34 days of holiday (including bank holidays).

For your health

With benefits like a healthcare cash plan or private medical insurance depending on your career level, critical illness cover, life assurance, health assessments, and more

For your wellbeing

With gym membership, travel insurance, workplace ISA, will writing services, dental insurance, and more

For your lifestyle

With extra holiday buying, discount dining, home & tech loans, and supporting your favourite charities with give-as-you-earn donations

For your home

Get up to £400 towards any OVO Energy plan, plus great discounts on solar, smart thermostats and EV chargers

For your commute

Nab a great deal on ultra-low emission car leasing, plus our cycle to work scheme and public transport season ticket loans

Want to hear about our full range of flexible benefits and progressive people policies? Our People Team can tell you everything you need to know.

For your Belonging

To find better ways to support our people, we need to listen to each other's experiences and find ways to build a truly inclusive and diverse workplace. As part of this, we have 8 Belonging Networks at OVO. Led by our people, for our people - so when you join OVO, you can play a part - big or small - with any of the Networks. It's up to you.