Back

Senior Data Warehouse Engineer

Any of our offices
9 days ago
Full time role

Company

OVO Energy

Bristol, Bristol, City of, United Kingdom

OVO Energy is an independent energy technology company and supplier. The company was launched in 2009. OVO Energy is set ...

View Company Profile

Job Description

Location: Flexible in the UK 

 

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?

OVO is a highly data-driven organisation, with an ever growing demand for excellent quality, reliable and accurate data to power decision making in various parts of the business.

You will work as part of a team of Data Engineers focussed on building and maintaining our Data Warehouse product, which is a key source of curated and cleansed data that provides teams with the data they need to meet their objectives aimed at providing a better customer experience and driving progress towards Plan Zero.

What will I be doing?

  • Working with key stakeholders to understand their data needs and deliver solutions that provide them with excellent quality data that allows them to realise their objectives.
  • Using your domain expertise to design data models within the Data Warehouse that represent key entities within the energy domain
  • Transforming and cleansing source data using batch ETL pipelines into a curated model that facilitates ease of use by customers of the Data Warehouse.
  • Automating the ingestion of data from various sources including BigQuery, APIs, FTP, various source files and Kafka.
  • Driving software development, security and infrastructure best practises within the team that facilitate the delivery of high quality, stable solutions. 
  • Providing guidance on data modelling to Software Engineering teams in our drive towards distributed data ownership.
  • Providing day-to-day Data Warehouse support to the Data Analyst and Data Science community.

Is this the job for me?

  • A proven track record of designing, building, testing, monitoring and managing large-scale data products, pipelines, tooling and platforms.
  • Strong experience in SQL.
  • A thorough understanding of at least one programming language (Python preferred).
  • 2+ years working with cloud-based data solutions (preferably utilising GCP).
  • A detailed understanding of data engineering principles and frameworks with a proven ability to evaluate various options with respect to data modelling, data pipelines, warehousing and storage layers.  
  • You will be comfortable working in an agile software development environment with regular release cycles, and have experience of pair programming, CI/CD and deployment strategies.
  • Experience of an of the following would be beneficial:
    • Working on streaming ETL solutions utilising streaming data processing tools;
    • Exposure to infrastructure as code processes and tools;
    • Experience of data lineage tools and frameworks.

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!

OVO Energy

Bristol, Bristol, City of, United Kingdom

OVO Energy is an independent energy technology company and supplier. The company was launched in 2009. OVO Energy is set ...

View Company Profile