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 massive amounts of data being passed around, and complex 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.

• We run a modern cloud data platform using key technologies such as:
• 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 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
• Work closely with a broad range of teams at Kraken
• Develop your engineering skills

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

• Great medical, dental, and vision insurance options including FSAs.
• Paid time off — we know working hard means also being able to recharge as needed, we trust our employees to get the work done and take the time they need.
• 401(k) plan with employer match.
• Parental leave. Biological, adoptive and foster parents are all eligible. 
• Pre-tax commuter benefits.
• Flexible working environment: you need to shift around your schedule? You do you, we genuinely believe in work/life balance. 
• Equity Options: every Octopus employee owns part of the business. We’re a team, working together towards huge goals. Every person is crucial to our success, you should be rewarded as such. 
• Modern office or co-working spaces depending on location.
• The salary range for this role in NYC ranges on average from $110,000-$150,000 (with some flexibility) depending on relevant experience. While the broad salary range is listed, not all candidates will be placed at the top of the range—this will be determined by the overall fit for the position. If you have questions about this, just ask! Our recruiters are happy to provide more context. 

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