Analytics Engineer

at  Octopus Energy Group

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.

IF THIS SOUNDS LIKE YOU THEN WE’D LOVE TO HEAR FROM YOU.

Are you ready for a career with us? We want to ensure you have all the tools and environment you need to unleash your potential. Need any specific accommodations? Whether you require specific accommodations or have a unique preference, let us know, and we’ll do what we can to customise your interview process for comfort and maximum magic!
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

• 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