Jobs / data
Sourcing & Pricing Analyst
Vandebron Energie · Amsterdam
What you will do
Optimize gross margin & pricing: 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.
Build & scale data models: Design, build, and maintain production-grade data models and architecture in dbt and Snowflake to enable scalable, automated reporting from sourcing to pricing.
Sourcing & customer value analysis: Evaluate sourcing strategies and procurement efficiencies alongside Portfolio Management. Build customer value models and analyze specific customer segments to identify commercial opportunities.
Drive strategic projects: Take the lead on modeling new regulatory frameworks (e.g., ETS2, “green gas” mandates) and build processes where none currently exist, establishing robust data pipelines and completeness controls.
Monitor market & competitor dynamics: Track energy market developments, tariff structures, price volatility, and competitive offerings using custom scrapers and dashboards.
Enable smart decision-making: Develop real-time tools, automated dashboards (e.g., Lightdash/PowerBI), and commercial business cases to evaluate the financial and P&L impact of new pricing strategies.
What they look for
Technical & data modeling expertise: Proven experience building and scaling data models using dbt and Snowflake (or similar tools like Databricks, PostgreSQL) alongside advanced SQL skills.
Margin & pricing acumen: Strong background in gross margin analysis, commercial pricing optimization, and financial metrics (Customer Lifetime Value, cost-to-acquire, P&L impact). Python and BI tool proficiency (Lightdash, PowerBI) is a plus.
Energy market affinity: Solid understanding of (or strong affinity for) energy procurement, tariff structures, risk premiums, and market dynamics.
Commercial & tactical mindset: Curiosity for where customer value lies, combined with a tactical mindset (6–12 month outlook) to align pricing strategy with broader business goals.
Communication & stakeholder skills: Proactive, self-driven, and adept at translating complex pricing and data topics into clear insights for non-expert stakeholders across Commerce, Finance, and Strategy.
Language: Fluency in English is required. Dutch is a nice-to-have, but not essential.