Analytics Engineer

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.,

• 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
  
  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
  
  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.