Analytics Engineer

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 the role
Kraken Analytics are the team who lead on data and analytics products, workflows and analyses in the Kraken world. We are 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. We are responsible for building and maintaining core datasets for every Kraken instance that can be used to quickly and efficiently answer a wide range of demands, measure performance, and ensure consistency across clients and markets.
Industry is at the beating heart of the business for Kraken's clients, with hundreds of thousands of messages and processes occurring every day. Your focus will be on understanding how well we're enabling our clients to interact with their respective markets, defining metrics and benchmarks for success, and working with stakeholders across the business and tech teams to improve their products.

Our data 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 data model across your regions as well as the application as a whole
• Lead on developing key reporting and metrics focused around industry communications and processes
• 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 Kraken Analytics team
• Work on strategic projects end to end
• Respond to client queries about Kraken's data model
• Work closely with a broad range of teams at Kraken
• Develop your engineering skills
• Fluency in English and Japanese

What you'll have

• We’re looking for someone who combines market industry knowledge and experience with a passion for working with data 
• 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 teamsHas 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

If this sounds like you then we'd love to hear from you.
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.