Analytics Engineer at octoenergy

About Octopus Electroverse We’re making electric vehicle ownership as smart and as simple as possible by building the giant, virtual charging platform of the future. In just four years, Octopus Electroverse has grown to become one of the largest eMobility players globally, with over 1 million connected electric vehicle chargers and a customer ecosystem spanning web, iOS, Android, CarPlay, Android Auto & Automotive OS, and more.  But it’s just the start: we’re busy expanding internationally, working with more automotive and tech partners, building exciting new features at scale, and creating the integrated charging experiences of the future - all in the name of making public EV charging super simple for customers. Electroverse is a multifunctional team made up of product, development, commercial, operations, marketing, partnerships and more - all focused together on making Octopus the go-to name in EV charging. This Role We are seeking a passionate data professional to drive the electrification of transport by transforming complex information into strategic assets. You will work with a rich variety of datasets, including charge point telemetry, user behaviour, marketing campaigns, sales figures, and operational metrics. Your mission will be to present data with the aim of uncovering actionable insights that enhance efficiency and guide decision-making across the entire business. This role offers end-to-end ownership of the data pipeline. As a key member of a small, high-growth team, you will do more than just manage data; you will be instrumental in building our data function. This includes establishing best practices, creating automated pipelines, and shaping the foundational framework for how we leverage data to succeed. What you’ll do… • You'll create SQL data models with dbt to power dashboards and applications • You'll develop and maintain data pipelines and automated processes in Airflow and Python • You'll integrate third-party APIs and databases into our data flows • You'll perform in-depth analysis and data transformations with SQL, Python, and Jupyter Notebooks • You'll prototype internal data applications and tools (Streamlit, Lightdash, Jupyter) • You'll ensure data quality and reliability throughout the lifecycle • You'll collaborate with product, technology, commercial and strategy teams to deliver high-impact insights and tools What you'll have... • Data Modelling Experience: Proficiency in using dbt (ideally) for data modelling • Dashboard and Data Product Development: Experience in creating data dashboards and developing data products. • Collaborative Projects: Experience working on collaborative projects with business teams and familiarity with agile or similar methodologies. • Autonomous Problem-Solving: Ability to work independently, scope problems, and deliver pragmatic solutions. • Data Lifecycle Expertise: Versatility in handling the entire data lifecycle, from ingestion to visualisation and presentation. • Tool Building: Passion for creating robust and usable tools to enhance team efficiency. • Data Analysis Skills: Proficiency in SQL, python, pandas/numpy, Databricks/Jupyter Notebooks, and experience with large datasets in production environments. • GenAI: Experience implementing agentic workflows (nice to have) • Curiosity and Drive: Self-motivated with a strong desire to learn and improve without lots of help and support. • Growth mindset: Learns fast and is enthusiastic about learning new technologies • Time Management: Ability to manage multiple projects simultaneously in a fast-paced environment. Passion for Net Zero: You don’t need to be deeply familiar with the EV market and products (we can teach that), but a passion for the transition to net zero is an excellent start What we work with... • dbt for data modelling • Lightdash and Databricks AI/BI Dashboards as business intelligence tools • Databricks Delta Lake for data lake and warehouse storage and querying • python as our main programming language • Jupyter and Jupyter Hub for notebook analytics and collaboration • Circle CI for continuous deployment • AWS cloud infrastructure • Kubernetes for data services and task orchestration • Airflow for job scheduling and tracking • Parquet and Delta file formats on S3 for data lake storage • Streamlit for data applications The projects will be varied and we’re looking for someone who can work autonomously and proactively to scope problems and solve and deliver pragmatic solutions Closing from [OEGL] - ALL UK JOB TEMPLATE (perks, application questions) 🇬🇧 💚 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 Group 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 were recently named the UK's top company to work for, and we ranked in the top ten in the Sunday Times Best Places to Work 2024. Our Group CEO, Greg has recorded a podcast about our culture and how we empower our people. We’ve also been placed in the top 10 companies for senior leadership • 🎁 Visit our UK perks hub - Octopus Employee Benefits   If this sounds like you then we'd love to hear from you. 🚀   P.S. Our process usually takes up to 4 weeks, but we’ll always do our best to flex around what works for you. Along the way, you’ll chat with our recruitment team and your Recruiter will help you throughout different stages. Got any burning questions before then? Drop us a message at [Upgrade to PRO to see contact] and we’d love to help!   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.