Sourcing & Pricing Analyst

Vandebron; Amsterdam; Hybrid; EUR 70,000 - 100,000; Full time

Benefits offered by this job

Annual bonus

30 days paid leave

Hybrid work model

€1,200 learning budget per year

Strong pension scheme

€50 net allowance per month for phone

Home office setup budget

Discount on Vandebron invoice

Free daily lunches

NS Business Card

Job summary

Vandebron, Amsterdam-based, seeks a Sourcing & Pricing Analyst to optimize pricing and sourcing strategies. You will build scalable data models in dbt and Snowflake and bridge market dynamics with data-driven decisions.

Reporting to the Manager Sourcing & Pricing, you will shape pricing frameworks and dashboards, collaborating across Commerce, Finance, and Strategy teams to maximize gross margins.

Qualifications

• Proven experience building and scaling data models using dbt and Snowflake or similar tools, with advanced SQL.
• Strong margin analysis, pricing optimization, and financial metrics awareness.
• Experience with BI tools (Lightdash/PowerBI) and data warehouses; comfortable cross‑functional work.

Responsibilities

• Conduct analytical modeling to optimize pricing for energy contracts and flexibility solutions.
• Design and maintain data models and architecture in dbt and Snowflake for scalable reporting.
• Evaluate sourcing strategies and build customer value models for commercial opportunities.
• Lead modeling of regulatory frameworks (ETS2, green gas) and build robust data pipelines.
• Develop real-time dashboards and business cases to assess pricing impacts.

Skills

SQL

Data modeling

Analytical thinking

English fluency

Business acumen

Tools

dbt

Snowflake

Databricks

PowerBI

Lightdash

PostgreSQL

Job description

As Sourcing & Pricing Analyst at Vandebron, you will play a pivotal role in the company’s commercial success and green mission by analyzing and optimizing pricing and sourcing strategies.

Who we are

At Vandebron, we're transforming the energy landscape, steering away from the conventional to champion sustainability. We are dedicated to ensuring 100% green energy availability, 100% of the time through smart solutions such as flexible use of wind and solar farms, Smart EV Charging, and efficient energy storage.

Your impact

As our Sourcing & Pricing Analyst, internally called Gross Margin Analyst, you play a pivotal role in Vandebron’s commercial success and green mission by analyzing and optimizing our pricing and sourcing strategies. Positioned within our newly established Pricing & Sourcing Team, you will bridge the gap between energy market dynamics, procurement costs, data engineering, and consumer needs.

In this role, you won't just generate static reports, you will actively build and scale the data warehouse infrastructure in dbt and Snowflake that powers our commercial decisions from energy sourcing all the way to end-consumer pricing. Working closely with the Portfolio Management, Commerce, Finance, and Strategy teams, you will turn complex energy market dynamics into actionable data models, ensuring our offerings remain highly competitive while maximizing our gross margins.

In this job, you will be reporting directly to Jeroen van Rooij, Manager Sourcing & Pricing.

What you’ll do

• Conduct in-depth analytical modeling to optimize commercial pricing for energy contracts and flexibility solutions, balancing purchase costs, margin targets, risk premiums, and market competitiveness.
• Design, build, and maintain production-grade data models and architecture in dbt and Snowflake to enable scalable, automated reporting from sourcing to pricing.
• Evaluate sourcing strategies and procurement efficiencies alongside Portfolio Management. Build customer value models and analyze specific customer segments to identify commercial opportunities.
• Take the lead on modeling new regulatory frameworks such as ETS2 and green gas mandates, and build processes where none currently exist, establishing robust data pipelines and completeness controls.
• Track energy market developments, tariff structures, price volatility, and competitive offerings using custom scrapers and dashboards.
• Develop real-time tools, automated dashboards such as Lightdash and PowerBI, and commercial business cases to evaluate the financial and P&L impact of new pricing strategies.

What you bring

• Proven experience building and scaling data models using dbt and Snowflake or similar tools like Databricks and PostgreSQL, alongside advanced SQL skills.
• Strong background in gross margin analysis, commercial pricing optimization, and financial metrics such as Customer Lifetime Value, cost-to-acquire, and P&L impact. Python and BI tool proficiency such as Lightdash and PowerBI is a plus.
• Solid understanding of, or strong affinity for, energy procurement, tariff structures, risk premiums, and market dynamics.
• Curiosity for where customer value lies, combined with a tactical mindset with a 6-12 month outlook to align pricing strategy with broader business goals.
• Proactive, self-driven, and adept at translating complex pricing and data topics into clear insights for non-expert stakeholders across Commerce, Finance, and Strategy.
• Fluency in English is required. Dutch is a nice-to-have, but not essential.

Why join Vandebron?

• You will directly shape the commercial core of the business as Vandebron pushes toward 100% green energy availability 100% of the time.
• As a foundational member of the new Pricing & Sourcing team, you’ll have significant autonomy to build data structures, scrapers, and sourcing workflows from scratch.
• This position offers a hybrid focus across data engineering, sourcing strategy, financial modeling, and commercial execution, giving you more ownership than traditional analyst roles.

A career move that matters

• Deepen your expertise in energy procurement, customer value modeling, and gross margin strategy while mastering production-grade data modeling in dbt and Snowflake.
• Within your first 6-12 months, you will establish end-to-end, semi-automated sourcing workflows and controls for new regulatory changes such as ETS2 and green gas, as well as new energy products.
• Build a data-driven pricing framework and automated dashboards that make Vandebron significantly faster and smarter in responding to market changes.

What’s in it for you

• An annual bonus based on company performance.
• 30 days of paid leave per year.
• Additional paid time off for life events, Liberation Day off every year, and 2 extra days off per year: one for volunteering and one for choosing sustainable travel.
• Work abroad for up to 6 weeks per year, with a maximum of 4 consecutive weeks including up to 4 weeks outside the EU.
• A possibility to take a sabbatical after 3 years.
• €1,200 annual learning budget plus unlimited access to learning and development programs.
• Strong focus on your well-being, with unlimited access to the mental health platform OpenUp.
• A solid pension scheme.
• €50 net allowance per month for phone and WiFi.
• A one-time €200 home office setup budget.
• Discount on your Vandebron invoice.
• A flexible hybrid setup between home and the carbon-neutral Amsterdam office.
• Daily free, healthy, vegetarian lunches cooked in-house.
• An NS Business Card if you live 10km or more from the office.