Logo for Ostrom

Analytics Engineer - Power Trading

Role overview

Summary

This role supports Ostrom's mission to revolutionize the electricity market by managing data for trading operations. As part of the Trading team, you will enhance data infrastructure and analytics to inform energy trading decisions, contributing to a smarter energy system.

Qualifications

  • Degree in Computer Science or similar and 4+ years of experience in analytics engineering, data engineering, or a related field.
  • Strong SQL and proven ability to write production-grade Python.
  • Hands-on experience building and operating ETL pipelines on AWS.
  • Experience with data modeling and transformation tools.
  • Excellent communication skills in English (C1).

Responsibilities

  • Build and own ETL pipelines for various data sources.
  • Own data modeling and data infrastructure, including orchestration and monitoring.
  • Analyze trading, portfolio, and energy market data to identify patterns.
  • Build and maintain Python-based dashboards for performance tracking.

Key facts

Hard skills

Other skills

  • Communication

About the company

Ostrom logo

Ostrom

  • Utilities & Power
  • Scaleup
  • 11–50
Ostrom is a Certified B Corpℱ digital energy management platform based in Berlin that makes green electricity affordable and straightforward for households in Germany. Unlike other traditional providers with lengthy contracts, Ostrom offers monthly tariffs, end-to-end English and German support, and electricity at market purchase price, which comes from 100 percent renewable energy sources. Consumers can view their energy consumption and control their tariff in real time using the Ostrom app. In 2023, Ostrom rolled out dynamic pricing and electric vehicle charging integration and its roadmap includes incorporating smart meters and more. All this will support Ostrom in becoming the leading B2C energy platform in Europe by 2030. Ostrom is an equal opportunity company that means it. We have a remote-focused culture built on trust by default.

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

🌐 We are on the mission to build Europe’s leading energy management platform to provide fair, clean energy to everyone. ⚡

We’re a diverse team of 50+ employees, with 46% being female and from 16+ nationalities, and steadily growing. Having raised of over €40 M in total, we are looking for passionate people to join us on our mission! 🚀

đŸ‡©đŸ‡Ș Wir haben eine klare Mission: Wir bauen Europas fĂŒhrende Plattform fĂŒr Energiemanagement, um faire und saubere Energie fĂŒr alle zugĂ€nglich zu machen. ⚡

Unser Team ist vielfĂ€ltig – wir sind ĂŒber 50 Personen aus mehr als 16 NationalitĂ€ten, mit einem Frauenanteil von 46 %. Und wir wachsen weiter!
Mit ĂŒber 40 Mio. € an Finanzierung suchen wir nach motivierten Menschen, die gemeinsam mit uns die Energiezukunft gestalten wollen. 🚀

Your mission

  • We are looking for a motivated Analytics Engineer (m/f/d) to support us in the green revolution of the electricity market as a digital and smart electricity provider.

  • As a key member of our Trading team, you will take ownership of the data behind our trading, from pipelines and models to the analyses and dashboards that guide our decisions. Your work helps us shape how we trade energy and build a smarter, more flexible energy system.

Your tasks

  • Build and own our ETL pipelines for all data sources, including smart meter measurements, weather data, energy market data, home energy management system (HEMS) data, and trade data

  • Own data modeling and data infrastructure, including orchestration, data quality checks, and monitoring

  • Understand our business logic and provide clean, ready-to-use data for our trading algorithms and ML models

  • Analyze trading, portfolio, and energy market data to find patterns and explain what drives our results

  • Build and own our Python-based dashboards, so the team can track performance, positions, and data quality

Your profile

  • Degree in Computer Science or similar and 4+ years of experience in analytics engineering, data engineering, or a related field

  • Strong SQL and proven ability to write production-grade Python, following best engineering practices (Git, automated testing, CI/CD, code reviews)

  • Hands-on experience building and operating ETL pipelines that bring fragmented and heterogeneous data sources into a modern data warehouse or data lake on AWS

  • Experience with data modeling and transformation tools (e.g. dbt, SQLMesh, or Dataform) to turn business logic into reliable, well-tested data models

  • Strong data analysis skills in Python: exploring data, applying statistical methods, and visualizing results

  • Experience building dashboards and reports in Python and turning business questions into clear analyses

  • Familiarity with AI coding tools and AI-assisted workflows

  • Excellent communication skills in English (C1)

Nice to have

  • Experience with Airflow or similar orchestration tools

  • Experience with Terraform

  • Experience with HEMS data, e.g. from EV chargers, heat pumps, batteries, and solar, as well as smart meter time series

  • Experience with energy data management (EDM) and understanding of European energy markets

  • German language skills

  • Previous startup experience

🌐 About Us

We’re Germany’s fastest-growing digital green energy provider and a Certified B Corpℱ , driving the energy transition by making renewable energy more accessible and inclusive.

How? Through variable tariffs, dynamic pricing, smart EV charging, heat pump and solar optimization, and Germany’s first virtual power plant: NeoGridℱ.

At Ostrom, you’ll work in a dynamic, open environment where you can be yourself, take on challenges, and grow both personally and professionally.

đŸŒ±Environmental Impact: Each customer who switches to Ostrom on average helps offset 1.5 tons of CO2 emissions per year compared to the average German energy mix.

📈 VSOP: On top of offering a competitive salary you will have access to company shares to ensure you can truly be part of the journey.

👭 Trust-based Team: A truly flat hierarchy and transparent company culture, where everyone’s voice matters.

đŸ’ȘđŸœBenefits: An annual learning budget, company-pension scheme, company events, discounted USC membership, discounted BVG public transport ticket, e-bike or e-moped, exclusive discounts via FutureBens or monthly vouchers - the choice is yours.

💬 Stay In The Loop: We believe in transparent communication — from weekly town halls and quarterly updates to regular retrospectives. Got feedback or an idea? We’re all ears.

đŸ€ Work Together, Celebrate Together: We thrive on collaboration. Wins are shared and so are the celebrations from monthly happy hours to team trips and company events.

🌍 Work Your Way: Whether you prefer the office, your home desk, or a sunny spot in Sardinia — you work where you work best.

🚀 Learn By Doing: We grow together with personal development paths, learning budgets, and regular knowledge-sharing sessions. Try things out, learn along the way, and keep moving forward.

đŸ‡©đŸ‡Ș Über Uns

Wir sind der am schnellsten wachsende digitale Ökostromanbieter mit B Corpℱ Zertifizierung in Deutschland – und treiben die Energiewende aktiv voran. Unser Ziel: Erneuerbare Energie fĂŒr alle zugĂ€nglich und inklusiv machen.

Wie? Mit variablen Tarifen, dynamischem Strompreis, Smart EV Charging, Optimierung von WĂ€rmepumpen und Solaranlagen sowie Deutschlands erstem virtuellen Kraftwerk: NeoGridℱ.

Bei Ostrom arbeitest du in einem offenen, dynamischen Umfeld, in dem du du selbst sein kannst, Herausforderungen annimmst und dich kontinuierlich weiterentwickelst.

đŸŒ± Nachhaltigkeit, die zĂ€hlt: Mit deinem Wechsel zu Ostrom unterstĂŒtzt du aktiv die Energiewende. Unsere Kund*innen helfen im Schnitt, jĂ€hrlich 1,5 Tonnen CO₂ gegenĂŒber dem deutschen Durchschnittsstrommix einzusparen.

📈 WertschĂ€tzung, die sich auszahlt: Neben einem attraktiven Gehalt erhĂ€ltst du bei uns VSOPs – Unternehmensanteile, mit denen du direkt am Erfolg von Ostrom beteiligt bist.

👭 Teamkultur auf Augenhöhe: Bei Ostrom leben wir flache Hierarchien und eine offene Feedbackkultur. Deine Meinung zĂ€hlt – vom ersten Tag an.

đŸ’ȘđŸœ Benefits: Du erhĂ€ltst ein flexibles Paket mit vielen Extras – von einem jĂ€hrlichen Weiterbildungsbudget, ĂŒber eine betriebliche Altersvorsorge, bis hin zu einer vergĂŒnstigten USC-Mitgliedschaft, einem vergĂŒnstigten BVG Jobticket oder deinem eigenen E-Bike bzw. E-Roller und sowie Rabattcodes ĂŒber FutureBens. Alternativ wĂ€hlst du monatliche Gutscheine – du entscheidest, was dir wichtig ist.

💬 Transparenz: Ob in wöchentlichen Townhalls, vierteljĂ€hrlichen Updates oder offenen Retrospektiven – wir glauben an klare Kommunikation und kontinuierlichen Austausch.

đŸ€ Erfolge feiern wir gemeinsam: Teamarbeit steht bei uns im Mittelpunkt – und genauso feiern wir auch unsere Erfolge: mit regelmĂ€ĂŸigen Happy Hours, Team-AusflĂŒgen und unvergesslichen Company Events.

🌍 Work you way: Ob im Berliner BĂŒro, im Homeoffice oder remote unter der Sonne – bei uns arbeitest du dort, wo du am produktivsten bist.

🚀 Wachse mit uns: Persönliche Entwicklung ist bei Ostrom keine Floskel. Wir unterstĂŒtzen dich mit Lernbudgets und Raum zum Ausprobieren – damit du dich fachlich und persönlich kontinuierlich weiterentwickeln kannst.

Related jobs

See all Analytics Engineer jobs

Other jobs at Ostrom