Analytics Engineer - Accounting and Finance
London, UK
Octopus Energy
Octopus customers pay less: Cheaper than price-cap prices, rewards for using less when the grid is stressed, and smart tariff savings for your home, car or battery
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.
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.
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!
- 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.
It would be helpful to have experience/expertise in the following (in rough priority order):
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 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 and most recently The Sunday Times, Best Places To Work 2023 and 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
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Job stats:
2
0
0
Categories:
Analyst Jobs
Engineering Jobs
Tags: Airflow APIs AWS Databricks Data pipelines Data quality dbt Finance Jupyter Kubernetes Parquet Pipelines Python RDBMS Spark SQL Streamlit Tableau
Region:
Europe
Country:
United Kingdom
More jobs like this
Explore more career opportunities
Find even more open roles below ordered by popularity of job title or skills/products/technologies used.
Principal Data Scientist jobsBI Developer jobsStaff Data Scientist jobsPrincipal Data Engineer jobsData Scientist II jobsData Manager jobsJunior Data Analyst jobsData Science Manager jobsResearch Scientist jobsBusiness Data Analyst jobsLead Data Analyst jobsSenior AI Engineer jobsSr. Data Scientist jobsData Engineer III jobsData Science Intern jobsData Specialist jobsJunior Data Engineer jobsSenior Data Scientist, Performance Marketing jobsBI Analyst jobsSoftware Engineer, Machine Learning jobsSr Data Engineer jobsData Analyst Intern jobsData Analyst II jobsSenior Artificial Intelligence/Machine Learning Engineer - Remote, Latin America jobsJunior Data Scientist jobs
Snowflake jobsEconomics jobsLinux jobsHadoop jobsOpen Source jobsJavaScript jobsPhysics jobsComputer Vision jobsAirflow jobsKafka jobsMLOps jobsRDBMS jobsBanking jobsData Warehousing jobsNoSQL jobsScala jobsGoogle Cloud jobsData warehouse jobsKPIs jobsR&D jobsPostgreSQL jobsOracle jobsGitHub jobsSAS jobsCX jobs
Classification jobsStreaming jobsTerraform jobsScikit-learn jobsLooker jobsScrum jobsDistributed Systems jobsPandas jobsData Mining jobsBigQuery jobsPySpark jobsRobotics jobsJenkins jobsJira jobsIndustrial jobsRedshift jobsdbt jobsReact jobsUnstructured data jobsMicroservices jobsMySQL jobsData strategy jobsE-commerce jobsGPU jobsNumPy jobs