Data Engineer (Mid-Level)

What you'll do...

• Supporting different Energy Markets teams to design and build key operational and reporting pipelines across all Octopus Energy regions;
• Taking responsibility for the maintenance of these critical data pipelines supporting core trading, forecasting, risk and PPA processes;
• Developing automations and alerts to quickly debug where these pipelines are failing or showing unprecedented trends;
• Setting up and maintaining processes for capturing, preparing and loading valuable new data into the data lake;
• Designing and building dashboards that cover operational processes and reporting requirements;
• Working with international teams across the Octopus Energy Group to ensure everyone shares the best possible practises and code is standardised where possible;
• Taking ownership of data platform improvements that enhance the capabilities for all Energy Markets teams and drives trust in the stability of the setup;
• Sharing, enhancing and upskilling team members on available tools and best practices.

What you'll need...

• Strong aptitude with SQL, Python and Airflow;
• Experience in kubernetes, docker, django, Spark and related monitoring tools for devops a big plus (e.g. Grafana, Prometheus);
• Experience with dbt for pipeline modelling also beneficial;
• Skilled at shaping needs into a solid set of requirements and designing scalable solutions to meet them;
• Able to quickly understand new domain areas and visualise data effectively;
• Team player excited at the idea of ownership across lots of different projects and tools;Passion for driving towards Net Zero;
• Drives knowledge sharing and documentation for a more effective platform;
• Open to travelling to Octopus offices across Europe and the US.

Our Data Stack:

• SQL-based pipelines built with dbt on Databricks
• Analysis via Python jupyter notebooks
• Pyspark in Databricks workflows for heavy lifting
• Streamlit and Python for dashboarding
• Airflow DAGs with Python for ETL running on kubernetes and docker
• Django for custom app/database development
• Kubernetes for container management, with Grafana/Prometheus for monitoring
• Hugo/Markdown for data documentation

Why else you'll love it here:

• Wondering what the salary for this role is? Just ask us! On a call with one of our recruiters it's something we always cover as we genuinely want to match your experience with the correct salary. The reason why we don't advertise is because we honestly have a degree of flexibility and would never want salary to be a reason why someone doesn't apply to Octopus - what's more important to us is finding the right octofit!
• Octopus Energy is a unique culture. An organisation where people learn, decide, and build quicker. Where people work with autonomy, alongside a wide range of amazing co-owners, on projects that break new ground. We want your hard work to be rewarded with perks you actually care about! We won best company to work for in 2022, on Glassdoor we were voted 50 best places to work in 2022 and our Group CEO, Greg has recorded a podcast about our culture and how we empower our people. We’ve also been placed in the top 10 companies for senior leadership
• Visit our UK perks hub - Octopus Employee Benefits