Analytics Engineer - Cost Modelling (m/w/d)

As a global EnerTech company, we combine energy supply, technology, and services. Our goal is to give more people access to modern energy solutions. To achieve this, we offer electricity tariffs from 100% renewable sources, install heat pumps, and develop intelligent tariffs.

At the same time, our "green" electricity tariffs are just the beginning. Since 2022, we have been installing integrated heat pump solutions with our own specialists. Furthermore, we are actively working on the widespread implementation of smart meters, solutions for electric mobility, and our own electricity generation from wind and solar energy.

However, we can't do it alone, we need you! Become part of our team and challenge the status quo. With energy that's good for the planet and good for your karma. 💚 Find your dream job and become part of the Octopus Energy Germany energy revolution.

For our Costing department, we are looking for a proactive Analytics Engineer who will take our data architecture in the area of direct costs (grid fees, taxes, levies) to the next level. In this key position, you will be the linchpin between complex regulatory requirements, forecasts in the energy industry, and our pricing strategy. You love building scalable data pipelines, keeping an eye on changing regulatory requirements, and strive to make our systems future-proof with a modern new architecture.

Your tasks: Data and Pipeline Architecture You will be responsible for the new architecture of our data landscape to reflect direct costs in the energy industry. You will design and implement robust ETL/ELT pipelines using dbt and Airflow for efficient processing of data from regulatory sources, market data, and internal systems. You will ensure the quality and consistency of data, which forms the direct basis for pricing decisions.

Functional Design and Monitoring Regulatory Monitoring and Implementation: You will actively monitor regulatory changes in the energy market (such as changes in grid fees, taxes, and levies) and independently translate them into necessary adjustments to our data models and pipelines. You will develop and maintain forecast models for our cost components and ensure that regulatory changes are reflected in forecasts in a timely and accurate manner. You will translate complex conditions of the energy sector into performant, logical data structures.

Strategic Collaboration You will be the central point of contact for our Pricing, Energy Markets (Procurement/Forecasting), and Gross Profit Control departments. You will advise stakeholders on the methodological development of cost calculation and ensure that analytical results directly influence business strategy. You will drive the technical development of the team by establishing best practices in data modeling.

Your Experience: You have successfully completed studies in (business) informatics, mathematics, statistics, economics, or a related quantitative discipline. You have significant experience (mid-level to senior level) as an Analytics Engineer, Data Engineer, or in a similar data-oriented role. You are a professional in SQL and Python. Ideally, you already have experience with dbt and Apache Airflow in a production environment. You have a deep understanding of data architectures and the ability to translate dynamic professional/regulatory requirements into clean, maintainable code. You think analytically, conceptually, and find pragmatic solutions to technical challenges. You communicate clearly – in German and English – and can explain professional complexity understandably to stakeholders. You have a strong sense of responsibility: you don't just build systems, you are responsible for their operation and continuous adaptation to the market.

Your Benefits with Us:

✅ Discounts & Benefits:

• Stock options of Octopus Energy Group Ltd.
• Favorable conditions for our electricity and gas tariffs
• Monthly subsidy for public transport tickets
• Monthly subsidy for meals
• Discounted bike leasing
• Company pension scheme
• Eco-friendly travel with our electric vehicle leasing

✅ Family

• Counseling and childcare support through HeyNanny
• Monthly subsidy for childcare services
• Parental allowance bonus: We top up your parental allowance for 3 months so you can enjoy your parental leave more relaxed

✅ Sports & Health

• Subsidies for fitness services through Wellpass
• Support for your mental well-being with our partner Open Up

✅ Training & Development

• Attractive training and career development opportunities
• Free language courses through Busuu

✅ Additional Perks

• A gift voucher for your birthday

---

Ready to revolutionize the energy market with us? Tell us why you should support us in this. Send us your CV and everything we need to know via our online form. We are looking forward to hearing from you!

You really liked the vacancy but are not sure if you meet 100% of the required skills? Please don't hesitate to apply!

P.S.: Octopuses come in all colors, shapes, and sizes. We welcome employees of any gender, age, sexual orientation, origin, religion, worldview, with or without disabilities. Only one thing matters to us: that you fit in with us and strive to make a difference.