Junior Data Analyst

Help us make a big green dent in the universe. We're on a mission to drive the global renewable energy revolution, and we need loads more people to help us make our vision a reality.
At Octopus, we’ve built the technology to serve millions of customers and are now delivering key insights on the thousands of smart meter installations and millions of smart reads that happen every day. 
We’re looking for a junior data analyst to support our smart meter team to help us collate, analyse and report on this data and to help maintain and build our automated data processes.
As a data team we’ve developed a modern Cloud based data platform (AWS, Databricks, dbt, Airflow, Jupyter, Tableau) to serve hundreds of data users across the whole business. We’re passionate about automating work loads and processes so we can concentrate on the interesting problems. You’ll work closely with the smart meter and ops teams to build new reports, dashboards and processes and provide analysis and insight to help them answer their questions.
This is a fantastic opportunity to work on problems that genuinely move us closer to Net Zero with a company that is passionate about building great technology and products that change the way customers use energy. 

What you'll do

• Build, maintain and assure regular reporting for smart installations and meter reads
• Help with one off analyses and reconciliations using SQL and Python  
• Build and maintain Tableau dashboards for the smart meter and ops teams
• Build new dbt SQL data models for use in dashboards
• Build and run Jupyter notebooks to automate reports
• Provide analytical support for regulatory reporting
• Work closely with a broad range of teams including smart operations, pricing, settlements and  Kraken Technology

What you'll need

• We’re looking for someone with the below qualities:
• 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
• Has great attention to detail
• A great problem solver
• Learns fast and is enthusiastic about learning new technologies

It'll be great if you have experience with some of the below technologies

• A scripting language (ideally Python) 
• Wrangling data outside of a spreadsheet environment
• Writing queries in SQL
• Building reports and dashboards in a BI tool (ideally Tableau)

Why else you'll love it here

• Wondering what the salary for this role is? Just ask us! On a call with one of our recruiters it's something we always cover as we genuinely want to match your experience with the correct salary. The reason why we don't advertise is because we honestly have a degree of flexibility and would never want salary to be a reason why someone doesn't apply to Octopus - what's more important to us is finding the right octofit!
• Octopus Energy is a unique culture. An organisation where people learn, decide, and build quicker. Where people work with autonomy, alongside a wide range of amazing co-owners, on projects that break new ground. We want your hard work to be rewarded with perks you actually care about! We won best company to work for in 2022, on Glassdoor we we're voted 50 best places to work in 2022 and our Group CEO, Greg has recorded a podcast about our culture and how we empower our people 
• Visit our perks hub - Octopus Employee Benefits

If this all sounds like you then we'd love to hear from you.
At Octopus, we're looking for genuinely decent people who are honest and empathetic. Our commitment is to provide equal opportunities, a diverse and inclusive work environment, and fairness for everyone. You are welcome to apply no matter your age, disability, gender, marriage or civil partnership status, pregnancy and maternity status, race, religion or belief, or sexual orientation.