Analytics Engineer at OVO Energy

, , -

Full Time

Start Date

Immediate

Expiry Date

26 Jan, 26

Salary

60410.0

Posted On

28 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data Modeling, Data Governance, SQL, Data Analysis, Data Quality, Collaboration, Data Warehousing, Insight Delivery, Problem Solving, Data Integrity, Data Transformation, Performance Optimization, Documentation, Automation, Communication, Technical Delivery

Industry

Utilities

Description

Role OVO-View Team: Performance and Insight Salary banding: £45,770 - £60,410 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 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 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. You'll 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 OVO's 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 team's 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 OVO's security policies, including access control, encryption, and data masking where required. You’ll 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 you’ll 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. You'll 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. Let’s talk about what’s in it for you We’ll pay you between £45,770 and £60,410, 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've 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. 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..

Responsibilities

As an Analytics Engineer, you will transform raw data into clean, reliable resources for analysis, ensuring data accuracy and accessibility. You will collaborate with Data Engineers and Analysts to optimize data models and deliver actionable insights for the business.