SodaStream: FP&A Analyst

PepsiCo; Breda; On-site; EUR 55,000 - 85,000; Full time

Job summary

SodaStream is seeking an FP&A analyst to focus on sales, product costs and margins. You will contribute to the IBP process and support forecast, budgeting and LRP in partnership with sales and the control function.

You will develop management reports, perform sales campaign analysis, become a key TM1 BI user, and participate in Month End Closing and delivering insights to the head office.

Qualifications

• University degree or professional accountancy qualification.
• 3+ years in a financial position, FMCG or international sales controlling preferred.
• Advanced Excel skills and solid IT system knowledge.
• Power BI experience a plus.
• Fluent in English.

Responsibilities

• Analyse sales, product costs and margins.
• Be a key member in the IBP process with forecasted volumes and prices.
• Contribute to Forecast, Budget & LRP processes across sales, margins, G&A, S&D and A&M with control.
• Prepare management reports and overviews for management and sales teams.
• Conduct sales campaign analysis and evaluations.
• Become a key user of TM1 BI tooling for sales analysis.
• Participate in Month End Closing with the finance team.
• Deliver reports, analyses and insights to the head office.

Skills

Excel advanced

Power BI

Forecasting & budgeting

English fluency

Project management

Education

University degree/professional accountancy qualification

Tools

TM1

MS Office

Job description

Overview

About the Company

SodaStream is the world's leading manufacturer and distributor of Sparkling Water Makers, which enable consumers to easily transform ordinary tap water into sparkling water and flavored sparkling water in seconds. SodaStream’s products promote health and wellness, are environmentally friendly, cost effective and fun to use. Every year SodaStream provides 1, 5 billion liters of carbonated beverages to millions of households, making it one of the largest beverage companies in the world. We employ more than 2,000 people worldwide, with over 30 nationalities represented.

Responsibilities

As the FP&A analyst, you will primarily work with analysis of the sales, product costs and margins.

• You are a key member in our IBP(Integrate Business Review) process. In which you will support and challenge sales members with their forecasted volumes and prices.
• You are a key member in our Forecast, Budget & LRP process within sales and margins as well G&A, S&D and A&M working closely with the control function to have this processes.
• You prepare a variety of management reports and overviews to keep the management- and sales teams up to date.
• You will prepare sales campaign analysis and evaluations.
• You will become a key user to our BI tooling (TM1), to analyze sales and support colleagues.
• You are part of the Month End Closing process, together with the other finance team members.
• You manage the process and deliver reports, analysis and insights to our head office

This is a role with a lot of variety, and you will be collaborating and communicating with several internal contact points.

Qualifications

You have at least three years of working experience in a financial position. If you have prior experience from FMCG or experience in sales controlling in an international environment it will be considered as a merit.

• University degree/professional accountancy qualification
• You are an experienced user in Microsoft Office and various IT systems as well as having advanced skills in Excel
• Power BI experience would be advantageous
• You have a great ability to prioritize, manage projects and deliver within deadlines.
• You work in a structured manner, yet you can manage last-minute changes and requests.
• Fluent in English.