Analytics Engineer (m/w/d)

As a globally operating EnerTech company, we combine energy supply, technology and services. Our goal is to give more people access to modern energy solutions. To do this, we offer electricity tariffs made from 100% renewable energy, install heat pumps and develop smart tariffs. Our green electricity tariffs are only the basis. Since 2022, we have been installing complete heat pump solutions with our own skilled technicians. We are also actively working on the nationwide rollout of smart meters, e-mobility solutions and our own electricity generation from wind and solar energy. However, we cannot do this alone, which is why we need you! Become part of our team and challenge the status quo. With energy that is good for the planet and good for your karma. 💚 Find your dream job now and become part of the energy revolution of Octopus Energy Germany.

For our Costing department, we are looking for an engaged Analytics Engineer to start at the earliest possible date, who will take our data architecture in the area of direct costs (grid fees, levies, taxes) to the next level. In this key position, you are the link between complex regulatory requirements, energy industry forecasts and our pricing strategy. You love building scalable data pipelines, keep track of changing regulatory requirements and aim to make our systems future-proof through a modern new architecture.

Your tasks:

You are responsible for the new architecture of our data landscape to map direct costs in energy sales.

You design and implement robust ETL/ELT pipelines using dbt and Airflow to efficiently process data from regulatory sources, market data and internal systems.

You ensure the data quality and consistency that serves as the direct basis for decision-making for our pricing.

Regulatory monitoring & implementation: You actively keep an eye on regulatory developments in the energy market (such as changes in grid fees, taxes and levies) and independently translate them into the necessary adjustments to our data models and pipelines.

You develop and maintain forecast models for our cost components and ensure that regulatory changes are reflected in the forecasts promptly and precisely.

You translate complex energy industry framework conditions into high-performance, logical data structures.

You act as the central point of contact for our interfaces with Pricing, Energy Markets (Procurement/Forecasting) and Gross Margin Controlling.

You advise stakeholders on the methodological further development of cost calculation and ensure that the analytical outputs feed directly into business strategy.

You drive the technical development of the team forward by establishing best practices in data modeling.

Your background:

You have successfully completed a degree in (business) informatics, mathematics, statistics, economics or a similar quantitative field.

You bring solid professional experience (mid-level to senior) as an Analytics Engineer, Data Engineer or in a comparable data-driven role.

You are a professional in handling SQL and Python. Ideally, you already have experience with dbt and Apache Airflow in production environments.

You have a strong understanding of data architectures and the ability to translate dynamic business/regulatory requirements into clean, maintainable code.

You work analytically and conceptually and find pragmatic solutions to technical challenges.

You communicate clearly – in German and English – and can present complex business matters in an understandable way to stakeholders.

You have a strong ownership mentality: you don't just build systems, you are responsible for their operation and their continuous adaptation to the market.

Find more English Speaking Jobs in Germany on Arbeitnow