Business Analyst (Air Treatment)

Business Analyst

Location

Amsterdam (primary)

Period

September 4 – October 27, 2017

Job title

Business analyst – strategy support

Hours per week

40

Background

Group Strategy is supporting the Air treatment business (within Domestic Appliances) to define a growth and market prioritization plan. Air treatment business consists of air purification and humidity management products.

We are aiming to address a few strategic questions in this project

• Market attractiveness: Model indoor air quality levels and trends. Include parameters like disposable household Income etc. to determine market potential for the product categories at country level in next 3-5 years.

Assess qualitative ability to win based on parameters like geo-political factors, local team capabilities, brand awareness, category awareness, competition etc.

• Market and Investment prioritization: Select the markets to play and invest in – assigning roles and phasing based on the level of priority and investment required. Assess impact of investment in A&P, channel etc. and quantify P&L impact based on investment trajectory and timing

• Recommended market prioritization scenario: Optimize investment and phasing of markets within overall business constraints to recommend the market prioritization and investment roadmap for the 3-5 year horizon

An important tool for this project is a fact-based planning model (Excel based) to project evolution of markets and simulate business investment scenarios under different assumptions. The team is defining functional requirements for the model and is looking for external support to translate these strategic questions and requirements into a structured model in Excel.

Profile we would be looking for

• Self-starter: potential to drive own module

• Excellent Excel (analyses, financial modelling, create dashboards) as well as PPT (can develop own storyline) skills

• 1-3 years’ experience in strategy consultant firm

• Financial modelling experience is a requirement

• Specific experience that would be an advantage (in order of importance)

o Consumer goods/retail (ideally within consumer durables/ home appliances)
o Strategy work focused on profitability, growth, and business scenario modeling