Profit-Driven Markdown Optimisation Analyst

Pepco; Poznań; On-site; PLN 80,000 - 100,000; Full time

Benefits offered by this job

Forbes-listed employer in Poland

Competitive salary

Life insurance

Extensive benefits platform

Employee discounts

LinkedIn Learning access

Language development opportunities

Counseling and financial consultations

Meal subsidies (canteen)

Job summary

Pepco in Poznań is seeking a Price and Inventory Management professional to lead markdown strategies and category plans, ensuring maximum sell-through and profitability. You will use MS Excel and Power BI to forecast demand, monitor performance against plans, and collaborate with Planning and Buying to implement optimized pricing, promotions, and stock controls.

The role requires strong analytical skills, attention to detail, and the ability to work in a fast-paced retail environment while

Qualifications

• Minimum 2 years of experience in Price and Inventory Management or Merchandise Planning; experience in a retail environment is preferred.
• Master’s degree in Economics, Product Management, Production Management, Mathematics, Commerce, or another relevant field.
• Excellent proficiency in MS Excel (essential).
• Very good knowledge of MS Word and MS PowerPoint (Power BI a plus).
• Knowledge of Microsoft Power add-ins (Power Query, Power Pivot) is a plus.
• English proficiency at B2 level or higher.
• Strong analytical skills with attention to detail and problem-solving abilities.
• Customer-focused mindset with a strong orientation towards retail performance and business results.

Responsibilities

• Set and provide guidance on optimal markdown parameters.
• Set and provide rules based on category financial plans.
• Determine optimal markdown strategy.
• Recommend and execute optimized, progressive clearance markdowns or multi-buy promotions maximizing profit and sell-through, including forecasts of changes in sales, margin, and unit demand with markdown recommendation.
• Monitor performance: review and validate actual performance against projections and expectations to identify underperforming items or categories and adjust markdown strategy to meet financial targets (partner with Planning team).
• Develop and maintain analyses for monitoring SKU, category, and department markdown financial results vs. plan.
• Identify trends and leverage analyses to formulate future plans and forecasts.
• Support development/implementation of new markdown pricing optimization tools and processes.
• Support change management through partnership with Planning and Buying.

Skills

Excel

Power BI

Power Query

Power Pivot

MS Word

MS PowerPoint

English (B2)

Analytical thinking

Attention to detail

Teamwork

Education

Master's degree in Economics or related field

Tools

Power BI

Job description

Pepco in Poznań is seeking a Price and Inventory Management professional to lead markdown strategies and category plans, ensuring maximum sell-through and profitability. You will use MS Excel and Power BI to forecast demand, monitor performance against plans, and collaborate with Planning and Buying to implement optimized pricing, promotions, and stock controls.

The role requires strong analytical skills, attention to detail, and the ability to work in a fast-paced retail environment while