Data Analyst - Kraken Field

Kraken; London; On-site; GBP 45,000 - 75,000; Full time

Job summary

Join a forward-thinking technology company dedicated to transforming the energy sector through innovative solutions. As part of a dynamic team, you will take ownership of data analytics, driving insights that shape product development and enhance customer experiences. With opportunities to work on cutting-edge technologies and collaborate across teams, this role offers a unique chance to contribute to a sustainable future. If you are passionate about data and eager to make a real impact, this is the perfect opportunity for you.

Qualifications

• Strong data analytics experience with energy/utilities focus.
• Proficient in SQL and DBT, capable of handling complex datasets.
• Excellent communicator for technical and non-technical teams.

Responsibilities

• Ingest and curate data for analytics insights and product development.
• Create dashboards and reports for senior management and clients.
• Collaborate with various teams to enhance data analytics capabilities.

Skills

Data Analytics

SQL

Python

DBT

Data Visualization

Problem Solving

Communication

Tools

Postgres

AWS

Databricks

Airflow

Kubernetes

GitHub

Circle CI

Job description

Help us use technology to make a big green dent in the universe!

Kraken powers some of the most innovative global developments in energy.

We’re 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.

It’s a really exciting time in energy. Help us make a real impact on shaping a better, more sustainable future.

About Kraken Field

We’re 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.

We’re 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 we’re 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:

• 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.
• Creation of dashboards in the analytics environments, some of which will be embedded back into the live Field product.
• Sharing data with clients for them to perform their own analysis.

The role is embedded in the wider data, machine learning and optimisation team at Kraken Field so there is opportunity to work on those other areas. It also has a strong dotted line into the Kraken wide Analytics team, who lead on data and analytics products, workflows and analyses in the Kraken world. The data support network for both clients and internal teams who need help getting the most out of their data, and need focused guidance around how to achieve their reporting goals.

Our Stack

• 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

You'll

• 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

What You'll Have

• 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
• Experience in the mathematical fields of optimization and machine learning

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.