Analytics EngineerOctopus Energy

London, U 17-12-2023
ClimateTech
CleanTech
Help us make a big green dent in the universe. We're on a mission to drive the global renewable energy revolution, and we need loads more people to help us make our vision a reality.

The Energy Markets team at Octopus Energy is responsible for making sure that we always have the electricity and gas we need to support our customer demand whilst also supporting the grid to enable the Net Zero transition.

To achieve this mission across all Octopus international regions, we have sub-teams focused on forecasting energy demand and generation, hedging and shaping our trade position, tracking and reporting the ongoing risk to Octopus, pushing into intra-day trading based on real-time market analysis, and driving the proportion of our supply directly from generators via PPA agreements.

The Engineering sub-team owns our global technical platform that supports these different processes and drives forward long-term solutions to enhance Group capabilities.

We are looking for an Analytics Engineer to help achieve this goal - ideally someone who is comfortable diving into different tasks to support each team using a variety of coding languages across our platform setup, who enjoys developing relationships across the company while explaining technical processes in the most appropriate way, and who keeps an eye on scalable solutions to support data growth. 

This is therefore an exciting opportunity to take on a role that combines complex data engineering, visual analytics and business critical need. 

What you'll do

    • Supporting different Energy Markets teams to design and build key operational and reporting pipelines across all Octopus Energy regions
    • 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 up-skilling team members on available tools and best practices

What you'll need

    • Strong aptitude with SQL and Python
    • 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
    • Experience with dbt, Airflow and Spark would be a plus

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
    • Secoda 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
If this sounds like you then we'd love to hear from you.

Studies have shown that some groups of people, like women, are less likely to apply to a role unless they meet 100% of the job requirements. Whoever you are, if you like one of our jobs, we encourage you to apply as you might just be the candidate we hire. Across Octopus, we're looking for genuinely decent people who are honest and empathetic. Our people are our strongest asset and the unique skills and perspectives people bring to the team are the driving force of our success. As an equal opportunity employer, we do not discriminate on the basis of any protected attribute. Our commitment is to provide equal opportunities, an inclusive work environment, and fairness for everyone.


c

Applications are now closed