Senior Data Analyst

Doghouse Recruitment; Randstad; On-site; EUR 55,000 - 75,000; Full time

Benefits offered by this job

Travel allowance (blocked travel)

Sports subscription

Udemy account

Learning budget

Monthly social activities

Pension contribution

Job summary

Doghouse Recruitment is seeking a Data Analyst for an Amsterdam-based energy trading and optimization company. You'll join a small data team (4th member) and work in a fully AWS-based environment using Python and PostgreSQL to turn market and forecast data into actionable insight that supports trading decisions.

The role blends analysis and engineering (roughly 75/25). You'll validate data from providers, benchmark time series, build dashboards, and shape data pipelines feeding forecasting and

Qualifications

• 3+ years of experience as a Data Analyst.
• Hands-on SQL experience, particularly PostgreSQL.
• Experience working in a cloud environment, specifically AWS.
• Affinity for data engineering with a ~75% analysis / 25% engineering split.
• Proactive self-starter who can work independently.
• Knowledge of the energy market is a plus.

Responsibilities

• Validate and benchmark incoming data from external providers.
• Extract insights from time series data and build dashboards.
• Shape data pipelines feeding forecasting and trading strategies.
• Collaborate with data engineers and the data team to improve data quality.
• Support trading decisions with data-driven analysis.

Skills

SQL

Python

Data analysis

PostgreSQL

AWS

Energy market knowledge

Tools

Docker

Kubernetes

AWS

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.

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.
• 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

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.

Interview Process

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