• Top 3 qualities for this role: Organisation, Focus, Leadership
• Have 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
• Strong attention to detail and a relentless focus on software quality, including rigorous testing and good observability to ensure your software does what it says on the tin
• 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

Desirable

• Team: Energy Tech
• Reporting to: Mark Shearman (Software Engineering Manager)
• This role in 3 words: Cloud, Pipelines, Warehousing
• In order to get energy into our customers’ homes, OVO has to buy the energy first on the wholesale market
• This is a mammoth but precise effort, with more than £1bn-worth of commodity on our books at any one time
• Our energy traders make knife-edge decisions every day which affect the viability of our business, so they need the right data at their fingertips to make the right decisions
• You will lead a team of Data Engineers in the Energy Trading Team with responsibility for building, maintaining, migrating or decommissioning a variety of ETL pipelines and establishing a Data Warehouse that give our traders the insight they need to keep OVO moving
• 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 day-to-day support to data users by responding to urgent requests and fixing bugs
• Within your first 9 months month you’ll:
• Have made a huge contribution to migrating data from in-house SQL Server to GCP
• Have established a strong data engineering team within Energy Tech
• Have our important, ongoing data pipelines moved to a standard pattern
• Be trusted with modelling and providing data for a variety of analysts, scientists and traders