Senior Data Warehouse Engineer at OVO Energy

  • Anywhere (100% Remote) Only
  • OVO Energy
Job Description:

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.

Company Benefits

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 apply. We’d still love to hear from you!

Interview Process

One interview (virtual), possible one more after this.

Other Jobs in Data Scientist