D

Data Analyst, Python & SQL - Energy Trading & Optimization

Doghouse Recruitment • Netherlands
Visa Sponsorship
Apply
AI Summary

Join a 3-person data team in Amsterdam to validate and benchmark market and forecasting data, build dashboards, and shape data pipelines that directly support trading decisions. Work in a fully AWS-based environment using Python and PostgreSQL to turn incoming data into actionable insights. This long-term role requires 3+ years of data analysis experience with strong Python and SQL skills, plus cloud environment familiarity.

Key Highlights
First dedicated Data Analyst joining a 3-person team
75% analysis, 25% engineering role with end-to-end ownership
AWS-based environment using Python and PostgreSQL
Key Responsibilities
Validating and benchmarking incoming data from external providers including meteorological and energy market data
Extracting insights from time series data
Building dashboards
Shaping data pipelines that feed the business's forecasting and trading strategies
Technical Skills Required
Python SQL PostgreSQL
Benefits & Perks
Fully covered travel allowance (NS Traject Vrij)
Sports subscription (up to €200/year)
Monthly social activities
Nice to Have
AWS Timestream and DynamoDB experience
Docker and Kubernetes experience
Knowledge of the energy market

Job Description


Data Analyst, Python & SQL - Energy Trading & Optimization, Amsterdam (Hybrid)

Our client is an Amsterdam based energy trading and optimization company on a mission to accelerate the energy transition. The company has grown to over 40 people, with a 12 person tech organization split across software, infrastructure, and data teams.


You'll join a 3 person data team (a Team Lead and two Data Engineers) as the team's 4th member and its first dedicated Data Analyst. You'll work in a fully AWS-based environment, primarily using Python and PostgreSQL, turning incoming market and forecasting data into insight that directly supports trading decisions. This is a long-term, end-to-end project: you'll take ownership of making the underlying data accurate, validated, and usable for the business, with room to grow into more responsibility as a medior analyst.


The role is a mix of analysis and engineering, roughly 75/25: validating and benchmarking incoming data from external providers (including meteorological and energy market data), extracting insights from time series data, building dashboards, and shaping the data pipelines that feed the business's forecasting and trading strategies.


Team

3 people including the lead: 1 Team Lead, 2 Data Engineers. This hire becomes the 4th.


Tech stack

Python, PostgreSQL, AWS (Timestream and DynamoDB experience a plus), Docker and a bit of

Kubernetes a nice to have.


What we're looking for

  • 3+ years of experience as a Data Analyst.
  • Strong Python skills for data analysis.
  • Hands-on SQL experience, particularly PostgreSQL.
  • Experience working in a cloud environment, specifically AWS.
  • An affinity for data engineering, and comfort with a role that's roughly 75% analysis and 25% engineering.
  • A proactive self-starter who takes initiative and can work independently.
  • Knowledge of the energy market is a plus.


Hours and hybrid

Full time, 40 hours per week. 3 days per week in the Amsterdam office, Monday and Friday compulsory, third day flexible.


Salary & contract

55 – 60 K range depending on experience.


Package

  • Fully covered travel allowance (NS Traject Vrij).
  • Sports subscription (up to €200/year).
  • Udemy account plus additional learning budget on request.
  • Monthly social activities.
  • Pension contribution.
  • Visa sponsorship and 30% ruling support available for candidates under 30.


Interview Process

Phone screening, take home assessment (one week to complete), final interview with the Data Team.


Interested? Please contact me at [email protected]


Similar Jobs

Explore other opportunities that match your interests

Senior Data Migration Engineer

Data Science
•
3d ago
Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

A2G Consulting BV (A2G Technol...

Netherlands
Visa Sponsorship Relocation Remote
Job Type Contract
Experience Level Mid-Senior level

A2G Consulting BV (A2G Technol...

Netherlands
Visa Sponsorship Relocation Remote
Job Type Full-time
Experience Level Entry level

kaizo

Netherlands

Subscribe our newsletter

New Things Will Always Update Regularly