Data Analyst – Revenue Assurance

Ovo Energy

Role OVO-View

Team: Margin Assurance, Finance

Salary banding: £35,000 to £45,000

Experience: Mid-level

Working pattern: Full-Time

Reporting to: Robin Davies, Revenue Assurance Manager

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

This role in 3 words: Identify, mitigate, optimise

Top 3 qualities for this role: Analytical, curious, collaborative

Closing Date: 30/08/2024

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. For this position you’ll be required in the Bristol office 2/3 times per week. 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:

Our team looks across OVO’s portfolio of energy products, including our innovative offerings that help customers achieve net zero. We think about what we expect different types of customers to consume across these products, what that costs us and if that’s aligning to the revenue we receive, and then work with stakeholders from across the business if this ever misaligns.

We make sure that, wherever estimation or judgement is required, our customer outcomes are as accurate as possible, demonstrating that our customers can trust us with their energy. Where we spot issues or misalignment between our revenues and our costs, we work to rectify this for our customers and to secure OVO’s financial position.

This role in a nutshell:

This Revenue Assurance Analyst role is an important role within the business and would suit somebody who is great at producing robust, insightful data analysis to drive operational outcomes. You’ll work in a team of 3 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.

Your key outcomes will be:

• Data Analysis to find themes and trends that cause undesirable customer billing journeys and proposing solutions to remedy them.
• Working with Finance colleagues and Ops billing specialists to report on the financial and operational health of our billing systems, including billing imbalance, helping link operational performance through to our monthly financials.
• Developing a deep understanding of how our billing systems work and where appropriate designing controls (input, process, output) around billing to assure our financial reporting and compliance.
• Ensure our processes have comprehensive and automated controls, testing and validation.
• Data storytelling; defining metrics and building dashboards to support performance analysis and decision making.
• Proactively mining data across the business to identify opportunities to reduce revenue leakage and enrich the quality of our reporting.
• Forging positive working relationships with teams across OVO to ensure our insight has the greatest impact.
• Promoting ethical methodologies across how all data is used and processed, always ensuring compliance and security is placed first.
• Designing and overseeing how we track metrics for revenue leakage.

Within your first 6 months you’ll:

• Carry out a variety of analytics, data visualisation and data storytelling to check that our revenue across our product portfolio is what we’re expecting and dig deep into the data to explore any areas where it isn’t aligning
• Get familiar with our different types of customer offerings and build streamlined analysis to make sure we are consistently pricing these to customers in a fair and compliant way.
• Take on monthly BAU reporting that we do for the Finance team (1-2 days per month) and be proficient to analyse as appropriate.

Systems: BigQuery, SQL, Tableau, Looker, Airflow, Dataform, GCP, GitHub, Python (nice to have)

You’ll be a successful Revenue Assurance Analyst at OVO if you

• Have a strong mathematical or analytical background.
• Are able to take a business problem and come up with the relevant data analysis to investigate it.
• Take ownership of projects to build complex new models.
• A confident managing and manipulating large amounts of data.
• Have experience in core data analysis technologies, using SQL to analyse large data sets to derive insights.
• Can act as the business partner with other areas of the business e.g. Operations, being a ‘critical friend’ i.e. providing constructive challenge but supporting, to make change happen within OVO.
• Demonstrable high attention to detail.
• Have a drive to learn and develop new skills to suit the work.
• Enjoy transparent work that makes things simple for the wider team.
• Are a creative thinker who thrives off direct responsibility and delivering value.
• Have strong presentation and communication skills. You’re able to articulate results clearly and concisely to senior stakeholders.

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

We’ll pay you between £35,000 and £45,000, 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. It’s an extra 9% of your salary on top of your core pay to use as you like. You can take it as cash, add to your pension, or choose to spend it on a huge range of flex benefits.

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, gadget, travel and cyber insurance, workplace ISA, will writing services, DNA testing, dental insurance, and more

For your lifestyle
With extra holiday buying, discount dining, culture cards, tech loans, and supporting your favourite charities with give-as-you-earn donations

For your home
Get up to £300 off any OVO Energy plan (when you pay by Direct Debit), plus personal carbon offsetting and great discounts on 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.

Oh, and one last thing

We’d be thrilled if you tick off all our boxes yet we also believe it’s just as important we tick off all of yours. And if you think you have most of what we’re looking for but not every single thing, go ahead and hit apply. We’d still love to hear from you! If you have any additional requirements, there’s a space to let us know on the application form; we want to make the process as easy and comfortable for you as possible