Customer Onboarding Senior Analyst

We’re making zero carbon happen

We’re OVO Group, a big family of companies united by a single vision: to get to zero carbon, fast.

We call this Plan Zero – and it shows how we’ll be fighting the climate crisis and transforming the way people use energy over the next decade. To do this, we need the sharpest minds. Are you up for the challenge?

Do great green things with OVO Energy

So much has changed since we launched in 2009. Our goal remains the same though: make energy cheaper, greener, and simpler. Just as it was on day one

Everyone belongs at OVO

Our aim is to build a diverse and inclusive movement: teams of brilliant people, with unique talents, skills, passions, and experiences.

We encourage everyone to join us, whatever your gender identity, race, ethnicity, sexual orientation, age, life experience, or background. So please come as you are – we can’t wait to meet you.

Where in the world of OVO will I be working?

This role is within our Energy Operations department in Customer Onboarding, reporting to the Head of Customer Transfers. The Customer Onboarding Department incorporates Customer Transfers and Housing Partnerships and is responsible for ensuring that our members experience a smooth journey when joining SSE/OVO; we aim to achieve this by utilising a data driven strategy, using cutting edge techniques to generate solutions which are high in impact whilst low in cost.

You will be tasked with interrogating our data to generate insight into where we can make tactical decisions to improve the processes and reporting across the department. In the short term the focus will be on helping to develop the Housing Partnerships data and analytics - this is an opportunity to make a lasting change to the onboarding experience of our group members and providing an excellent service to our external commercial partners, helping them provide a vital service to their tenants, while growing our member base.

You will lead a small team of Analysts and ensure the team delivers BI developments and data engineering solutions

What will I be doing?

Key responsibilities include:

• Performing high-quality data analysis including the production of KPI/OKR dashboards, alert metrics and regulatory reports.
• Transforming large amounts of data into digestible and actionable insight.
• Owning and improving onboarding data exception reporting. Providing insight into root causes using the manipulation of data from multiple systems and sources.
• Working collaboratively with the Technical Operations specialists across Energy Operations to deliver on our departmental objectives.
• Engaging with upstream and downstream stakeholders to ensure data flows are efficient, accurate and timely.

Is this the job for me?

Ideally you will have:

• 2 years experience in a senior analytical role, with experience providing key recommendations to stakeholders and leading analysts.
• Strong data manipulation skills, able to identify discrepancies and validate data to ensure accuracy.
• Experienced in ETL/ELT development.
• Expert SQL developer (T-SQL) - experienced in Stored Procedures and complex SQL techniques in a data warehouse environment
• Knowledge of SQL Server Integration Services (SSIS).
• Experience of data modelling techniques.
• Experience of monitoring and optimisation of scheduled tasks.
• Experience in developing or maintaining a robust process to consistently apply business rules to available data
• Ability to scrutinise outcomes and develop workarounds to ensure rules continue to be applied correctly
• Good communication and requirements gathering skills - what they ask for and what they want are not always the same thing.
• Experience of BI Reporting tools (preferably Power BI & DAX)
• Strong Excel/Google Sheets skills (ideally including power query / power pivot)
• Advanced, practical knowledge of SQL (complex queries across multiple tables/projects).
• The ability to contextualise and simplify complex data for a variety of audiences.
• Programming experience (Python, R or similar)
• Highly analytical, meticulous and superb attention to detail.
• Experience in an energy operations environment.
• Delivered reporting in a regulated environment.

Brilliant benefits for a world-changing team

Our people are at the heart of Plan Zero. That’s why we offer plenty of green benefits and progressive policies to make you feel at home.

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

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

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!