Analytics Engineer - Accounting and Finance

At Octopus, we’ve built the technology to serve millions of energy customers and handle the billions of pounds worth of customer and third-party transactions that this entails. We’re looking for someone to work between our data team and the finance and accounting team to build great data and automation tools and to make our processes even more efficient. You’ll have a passion for working with data to bring insight and efficiency to the teams around them. You’ll need to be great at listening, understanding challenges and formulating pragmatic solutions.

You’ll work as part of the wider data team whilst closely supporting the Group Financial Controller. You’ll contribute to our modern Cloud-based data platform (AWS, Databricks, dbt, Airflow, Jupyter) and will benefit from working alongside world class data scientists, analysts and engineers. You’ll work closely with the finance and accounting teams to build new integrations, pipelines, dashboards, apps and automation tools. You’ll build and automate integrations with third party systems across the whole set of Octopus businesses from retail energy to electric vehicles.

This is a fantastic opportunity to work on projects that span 30+ entities across 8 geographies and develop financial tools and integrations for our market leading Kraken energy platform.

What you'll do...

• Integrate third party data tools, APIs and databases (Aqilla, Docworks, CRMs) into automation workflows
• Build and run new data pipelines and automated processes in Airflow and Python
• Build new dbt SQL data models for final tables for dashboards and apps
• Help with one off analyses and reconciliations using SQL, Python and Jupyter notebooks
• Build prototype automation Jupyter notebooks and Streamlit apps for accounts payable team
• Provide data support for financial audits and regulatory reporting
• Build and maintain Tableau dashboards for the finance and tech ops teams
• Work closely with a broad range of teams including Finance, Strategy and Kraken Technology

What you'll need...

• First and foremost, we want our data engineers to be great software engineers with a passion for writing high quality code!

It would be helpful to have experience/expertise in the following (in rough priority order): - Python

• Relational databases (SQL)
• APIs and third party data integrations
• Experience modelling data for analytics - ideally experience using dbt as a modelling tool
• Experience in assuring data quality
• Experience working in a cloud environment (ideally AWS)
• Drive to work autonomously and proactively to scope problems and solve and deliver pragmatic solutions
• Happiness and versatility to work across the whole data lifecycle, from integration and discovery to data apps and interfaces
• Passion for building robust and usable tools that make the teams they work for more efficient and effective.

Our data platform stack...

• Python as our main programming language
• Kubernetes for data services and task orchestration
• Airflow purely for job scheduling and tracking
• Circle CI for continuous deployment
• Parquet and Delta file formats on S3 for data lake storage
• Spark for data processing
• dbt for data modelling
• Presto and SparkSQL for analytics
• Streamlit for data applications

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 Group 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 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 recordeda podcast about our culture and how we empower our people. We’ve also been placed in thetop 10 companies for senior leadership and most recently The Sunday Times, Best Places To Work 2023and again in 2024
• We want your hard work to be rewarded with perks you actually care about! Visit our UK perks hub - Octopus Employee Benefits