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

• 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 utilizing 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 standard and ad-hoc analyses for use in monitoring and reviewing SKU, category, and department markdown financial results compared to plan.
• Identify trends and leverage analyses to formulate future plans and forecasts.
• Supports development/implementation of new markdown pricing optimization tools and processes.
• Support change management through partnership with key cross-functional business areas such as Planning and Buying.

Skills and experience we are looking for:

• Minimum 2 years of experience in Price and Inventory Management or Merchandise Planning; experience in a retail environment is preferred.
• Master’s degree, preferably in Economics, Product Management, Production Management, Mathematics, Commerce, or another relevant technical field.
• Excellent proficiency in MS Excel (essential).
• Very good knowledge of MS Word and MS PowerPoint (experience with Power BI is a plus).
• Knowledge of Microsoft Power add-ins (e.g., Power Query, Power Pivot) is a plus.
• English proficiency at B2 level or higher.
• Strong analytical skills with excellent attention to detail and problem-solving abilities.
• Customer-focused mindset with a strong orientation towards retail performance and business results.
• Excellent communication and interpersonal skills.
• Ability to work effectively in a team environment.
• Strong planning, organizational, and prioritization skills.
• Proactive, flexible, and adaptable approach with a strong "can-do" attitude.
• Creative thinking and a continuous improvement mindset.

You are bound to like your job at Pepco because we guarantee:

• Work in an international company featured on the Forbes list of the best employers in Poland and beloved by millions of consumers in Poland and Europe.
• A competitive salary and real opportunities for promotion - the development of our employees is the cornerstone of our strategy!
• Life insurance on preferential terms, to feel secure.
• An extensive benefits platform offering a wide range of options - including medical care, sports cards, events, trips, shopping vouchers, and more.
• Discounts on purchases at Pepco stores - get your favorite products at even better prices!
• Unlimited access to LinkedIn Learning (for IT - Udemy Business), giving you thousands of expert-led courses to support your professional development, build new skills, and learn at your own pace.
• The opportunity to improve language skills by working in an international environment.
• Free psychological, legal, and financial consultations as part of our employee support program -our employees' well-being is our top priority!
• Smart Lunch - meal subsidies for the company canteen, giving access to daily on-site dishes at discounted prices.
• Financial recognition in the form of jubilee awards, additional days off, and loyalty-based discounts for employees celebrating their work anniversaries.
• A social fund providing additional financial support to ensure security and assistance in various life situations.
• A friendly atmosphere and support from colleagues who are eager to share their expert knowledge - despite being a large organization, we’ve maintained a warm, informal atmosphere.
• A role within a unique organizational culture - Pepcoolture - where our mission, vision, and values are the foundation of our everyday work.