Analytics Engineer

OVO Energy; Bristol; Hybrid; GBP 45,000 - 61,000; Full time

Job summary

A leading energy company in the UK is seeking an experienced Analytics Engineer. You will be the vital link between raw data and business insights, responsible for building and optimizing data models, ensuring data accuracy, and providing actionable insights. The ideal candidate will have a strong background in SQL and data analytics, experience with data warehousing, and a passion for data quality. This role provides a flexible work environment, competitive salary, and numerous benefits including 34 days of holiday.

Benefits

34 days of holiday

Healthcare cash plan

Gym membership

Flexible benefits

Cycle to work scheme

Qualifications

• Expert at data modeling and can design logical scalable data structures.
• Experience with data warehousing concepts and tools.
• Natural problem-solver who enjoys making complex data easy to work with for others.

Responsibilities

• Manage the cleaning and restructuring of raw data creating a single unified source of truth.
• Build and maintain core datasets ensuring data accuracy and reliability.
• Optimize data models for performance and usability.

Skills

Adobe Analytics

Data Analytics

SQL

Attribution Modeling

Power BI

R

Regression Analysis

Data Visualization

Tableau

Data Mining

SAS

Analytics

Job description

Overview

Role OVO-View

Team : Performance and Insight

Salary banding : 45770 - 60410

Experience : Experience in a similar role with a proven track record of technical delivery and mentoring others in a cross-functional environment.

Working pattern : Full-Time

Reporting to : Analytics Manager

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

This role in 3 words : Domain expert Insightful Expert

Top 3 qualities for this role : Innovator Communicator Designer

Where youll work : At OVO we understand that a one size fits all approach doesnt work for everyone. Thats 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. Youll also have the flexibility to work from home.

Everyone belongs at OVO

At OVO we are on a mission to solve one of humanitys biggest challenges the climate crisis. And we know it takes all of us to change the world. Thats 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 youll be joining plays a gigantic role in making that happen. Heres how :

• The Performance and Insight team exists to provide greater understanding of our operational performance improve the accuracy and accessibility of data and adapt quickly to our changing operational and technical environment. We handle complex and challenging issues and projects embed a culture of continuous improvement and enable the business strategic transformation.
• Through great Data Governance - we make it easier to find and understand our performance data by implementing great data governance ensuring that data is managed systematically so it can be used efficiently securely and is accessible to those who need it.
• Easier to understand performance data - we create simple to understand MI against a set of visual standards we work with each part of our business to educate our teams on how to spend the least amount of time finding the data vs investing their time in making the right decisions based on what the data tell us
• Understanding the work - we have a complex business and we architect MI to bring to light how we perform end-to-end showing what are the key drivers of work and where bottlenecks exist in the system.
• Innovation and collaboration - as well as making sure we create the best MI today we are looking forward to tomorrow to look at new ways to automate our reporting and embed AI as a way to help our stakeholders identify where their focus should be

This role in a nutshell :

As an Analytics Engineer you are the crucial link between raw data and business insight. You will take data pipelines built by Data Engineers and transform them into a clean reliable and usable resource for yourself and other analysts. This role is a blend of technical data expertise and a deep understanding of business needs. Youll be responsible for building optimising and analysing the core data models and curated datasets that power our reporting and analysis ensuring our data is accurate efficient and easily accessible.

Your key outcomes will be :

Modeling and Structuring Data

• Take raw data from Data Engineers and manage the cleaning and restructuring of it creating a single unified source of truth.
• Build and maintain the core datasets that data analysts will use for their work making use of OVO tooling and engineering practices.
• Design and implement data models that are both robust and flexible ensuring data integrity and consistency.
• Collaborate with Data Engineers to ensure a seamless flow of data from source to consumption layer.
• Document data models schemas and pipelines to ensure maintainability and understanding across the team.

Optimising for Performance

• Take cleaned data models and optimize them for performance and usability by building curated views and aggregations.
• Create specific tables and views for different business functions such as Billing or Customer Care ensuring the data is easily accessible and correctly joined.
• Continuously monitor data pipeline performance and proactively identify and address bottlenecks.
• Ensure data freshness and reliability through automated testing and monitoring.
• Work to reduce data processing times and query costs.
• Applying software engineering rigor to data code ensuring all transformations and data-serving logic are reliable maintainable and version-controlled following OVOs established Tech team standards.

Insight Design

• Maintains closeness to the context and performance of key business areas to lead on the delivery of insight for the operation
• Seeking to connect business performance to understand impacts across our operational teams to deliver insight that moves the needle
• Building out highly consumable data that tells the story of performance at a deep level
• Project manage longer term delivery of more complex insight and analysis in single or multiple functional teams
• Partner with Product to ensure data is ready when new functionality is created across our platforms
• We automate the monitoring of connections and fix when they break and know who to go to when things go wrong

Driving Data Maturity

• Act as a subject matter expert on our data models providing guidance and support to data analysts.
• Identify opportunities to improve data quality and consistency across all our datasets.
• Champion best practices for data modeling and transformation within the team.
• Partner with Data Analysts to understand their specific needs and build data solutions that directly address them.
• Contribute to the teams overall data governance and standards ensuring data is managed effectively.
• Working with Data Governance and Tech teams to ensure all published data products adhere to OVOs security policies including access control encryption and data masking where required.

Youll be a successful Analytics Engineer here at OVO if you

• Are an expert at data modeling and can design logical scalable data structures.
• Are a collaborator who enjoys working between technical Data Engineering teams and business-focused Data Analyst teams.
• Are passionate about data quality and integrity with an eye for detail and a commitment to creating reliable datasets.
• Have experience with data warehousing concepts and tools.
• Are able to deliver deep meaningful insight
• Are a natural problem-solver who enjoys making complex data easy to work with for others.
• Are keen to develop your own skills and ways of working - We want to help enhance your skills whilst working here and youll have time to do this. We also run community engagement events mentoring / coaching and there are ample opportunities for peer to peer and self led learning based around our career framework.
• Are an SME of advanced SQL with the ability to write complex performant and maintainable queries. This includes deep familiarity with analytic functions CTEs subqueries and a strong understanding of query optimisation. You can design and build robust data models ensuring data integrity and consistency across multiple sources. Youll be skilled in creating and maintaining the core datasets that will be used by our analysts focusing on clean architecture and ease of use. You can also build pipelines that ensure data is ready for the final consumer such as specific tables for different business functions.

Lets talk about whats in it for you

Well pay you between 45770 and 60410 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.

Youll 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 OVOand theres flex pay. Well 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 weve put at the heart of our offering add to your pension or even take it as cash.

Heres a taster of whats on offer :

For starters youll 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 others 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. Its up to you.

Oh and one last thing...

Wed be thrilled if you tick off all our boxes yet we also believe its just as important we tick off all of yours. And if you think you have most of what were looking for but not every single thing go ahead and hit apply . Wed still love to hear from you!

If you have any additional requirements theres a space to let us know on the application form; we want to make the process as easy and comfortable for you as possible..

Key Skills

Adobe Analytics,Data Analytics,SQL,Attribution Modeling,Power BI,R,Regression Analysis,Data Visualization,Tableau,Data Mining,SAS,Analytics

Employment Type : Full Time

Experience : years

Vacancy : 1

Monthly Salary Salary : 45770 - 60410

Note

This refined version preserves the core information while complying with formatting rules. It removes stray non-allowed tags (like ), converts inline lists to proper

/
• structures, and uses

  headings for sections where appropriate. It also ensures the description contains responsibilities and qualifications, and does not introduce new facts.