octoenergy - Octopus Energy Group

• 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