Senior Data Analytics Engineer - Kraken Field
17 days ago
London
Help us use technology to make a big green dent in the universe! Krakenpowers some of the most innovative global developments in energy. Were a technology company focused on creating a smart sustainable energy system. From optimising renewable generation creating a more intelligent grid and enabling utilities to provide excellent customer experiences our operating system for energy is transforming the industry around the world in a way that benefits everyone. Its a really exciting time in energy. Help us make a real impact on shaping a better more sustainable future. About Kraken Field Were making converting homes to green electrons as simple as possible by building a platform to allow engineers to install smart meters solar panels heat pumps EV chargers and more. Were busy launching in new countries working with ever more engineers and tech partners building exciting new features at scale and creating the integrated solution to retrofit homes across the world - all in the name of making it as easy and cheap as possible for customers to go green. Kraken Field is a multifunctional multinational team made up of product backend design mobile web and more - all focused together on making Octopus the go-to name in green home installations. And were looking for smart individuals with an interest in the space who can help us make it happen. The correct candidate will take ownership of data analytics at Kraken Field with three key responsibilities: 1. Ingesting cleaning and curating data from the Kraken Field production databases into the Kraken analytics platform. To allow insight into how the product is behaving and stimulate data-driven product development., 2. Creation of dashboards in the analytics environments some of which will be embedded back into the live Field product. • Postgres source databases, • AWS cloud infrastructure, • Databricks Delta Lake for data lake and warehouse storage and querying, • DBT() for data modelling and transformations, • Python as main scripting language, • Airflow for task scheduling, • Kubernetes for orchestration, • Github Circle CI for version control deployment and monitoring, • Become a subject matter expert on the Kraken Field data model, • Lead on developing key reporting and metrics, • Build maintain and assure reports for senior Kraken management and external clients, • Be exposed to new technologies and tools and receive guidance on developing your skills, • Build and maintain dashboards and data apps for senior stakeholders, • Build core datasets capable of answering key business questions, • Contribute to the development of the Data Analytics within Kraken Field, • Work on strategic projects end to end, • Work closely with a broad range of teams at Kraken, • Develop your engineering skills, • Strong level of data skills/analytics experience. Comfortable with energy/utilities and other relevant subject areas., • Learns fast and is enthusiastic about learning new technologies & processes, • Be highly proficient in DBT and SQL capable of working on large complex datasets while seeing the big picture, • Experience building data pipelines and working with engineering teams, • Curious and self driven - when faced with a new problem is capable of seeking out an answer without lots of help and support, • Highly data literate and numerate - can make sense of lots of data and shape it into a coherent story, • Great communicator can explain complex technical problems to non-technical teams, • Has experience with some of the below technologies:, • A scripting language (ideally Python), • Writing accurate and performant queries in SQL, • Working in a modern cloud data warehouse environment, • Working collaboratively on codebases using git, • Front-end/Dashboarding experience 1. Ingesting cleaning and curating data from the Kraken Field production databases into the Kraken analytics platform. To allow insight into how the product is behaving and stimulate data-driven product development., 2. Creation of dashboards in the analytics environments some of which will be embedded back into the live Field product. • Postgres source databases, • AWS cloud infrastructure, • Databricks Delta Lake for data lake and warehouse storage and querying, • DBT() for data modelling and transformations, • Python as main scripting language, • Airflow for task scheduling, • Kubernetes for orchestration, • Github Circle CI for version control deployment and monitoring, • Become a subject matter expert on the Kraken Field data model, • Lead on developing key reporting and metrics, • Build maintain and assure reports for senior Kraken management and external clients, • Be exposed to new technologies and tools and receive guidance on developing your skills, • Build and maintain dashboards and data apps for senior stakeholders, • Build core datasets capable of answering key business questions, • Contribute to the development of the Data Analytics within Kraken Field, • Work on strategic projects end to end, • Work closely with a broad range of teams at Kraken, • Develop your engineering skills, • Strong level of data skills/analytics experience. Comfortable with energy/utilities and other relevant subject areas., • Learns fast and is enthusiastic about learning new technologies & processes, • Be highly proficient in DBT and SQL capable of working on large complex datasets while seeing the big picture, • Experience building data pipelines and working with engineering teams, • Curious and self driven - when faced with a new problem is capable of seeking out an answer without lots of help and support, • Highly data literate and numerate - can make sense of lots of data and shape it into a coherent story, • Great communicator can explain complex technical problems to non-technical teams, • Has experience with some of the below technologies:, • A scripting language (ideally Python), • Writing accurate and performant queries in SQL, • Working in a modern cloud data warehouse environment, • Working collaboratively on codebases using git, • Front-end/Dashboarding experience