Commercial Finance Analyst

Coca-Cola HBC; Warszawa; On-site; PLN 120,000 - 180,000; Full time

Job summary

Coca-Cola HBC is seeking a Commercial Finance Analyst to join the Group Strategic Finance team in Warsaw. You will deliver reliable financial information, robust analyses, and data insights on revenues, channels, and categories to support management decisions across country, regional, and group levels.

You will lead ad hoc analyses, develop financial models, and collaborate with cross-functional partners to drive business insights and forecasting accuracy.

Qualifications

• Minimum 5 years’ experience in finance, at least 3 years in Commercial Finance Analysis.
• Strong Excel skills with complex financial models and large datasets.
• Proficient with advanced Excel formulas and PivotTables.
• Fluent in English, both verbal and written.
• Able to present to senior management using PowerPoint.

Responsibilities

• Prepare regular and ad hoc overviews for top management with insights on Category, Brand, Channel, and geography.
• Perform financial analytics leveraging data and tools for follow-ups or specific initiatives.
• Conduct interviews with countries to deep dive topics per business needs.
• Support Group BP forecasting, target setting and scenario analysis.
• Provide financial information and analysis for decision making by Group Commercial Function.
• Participate in tools/systems/reports development, deployment and adoption.
• Develop and maintain financial models and templates for NSR, pricing, discounts, customers, channels, and categories.

Skills

Excel advanced

P&L analysis

Financial modeling

PowerPoint

Data analysis

English fluency

Education

Bachelor's in Finance or related

Tools

SQL

Tableau

Power BI

Job description

We are looking for a Commercial Finance Analyst to join our Group Strategic Finance team. You will play the key role in providing Commercial Management and Senior Management with reliable and timely financial information, robust financial analysis, and data insights on Revenues, Channel and Category performance. You will have a unique opportunity to participate and lead projects in the Commercial Finance area, and act as a liaison between Finance and Commercial on the country, regional, and group level.

IN THIS EXCITING ROLE YOU WILL:

• Prepare various regular and ad hoc overviews for top management including business insights on Category, Brand, Channel, Customer by geography
• Perform different financial analytics, leveraging data & tools, for the purposes of regular follow-ups or specific initiatives/business needs
• Conduct interviews with countries to deep dive into specific topics, as per business needs
• Support the Group team regarding BP and forecasting, target settings and scenario analysis process giving valuable insights
• Support Group Commercial Function with financial information and analysis required for decision making
• Participate in Tools/Systems/Reports development, deployment and adoption
• Develop, maintain and use financial models, templates, strategic and operational measures to perform business analysis in NSR, Pricing, Discounts, Customers, Channel, Categories

YOU CAN BE SUCCESSFUL IN THIS ROLE IF YOU HAVE:

• Minimum 5 years’ experience in finance mandatory and at least 3 years in Commercial Finance Analysis.
• Strong Excel technical skills which should include:
  • High level of comfort working with complex financial models and large datasets
  • Ability to work with speed using keyboard shortcuts
  • Fluent with advanced excel formulas such as vlookup, hlookup, xlookup, if/else, choose, concatenate, transpose, sumif, sumproduct and ability to use them in dynamic way
  • Fluent with pivot handling and knowledge of calculated field and getpivotdata functionalities
• Fluent with PowerPoint and able to prepare presentations appropriate for senior management
• Great experience in reviewing P&L statement, understanding the key drivers of each P&L line
• Great experience in Commercial Finance, being able to analyze P&L and financials, understand the business performance and provide insights to senior management by Category/Channel and geography.
• Experience in calculating variance analysis to understand volume/mix and pricing effects.
• Strong analytical mindset with excellent attention to detail
• Outstanding organizational and time management skills to handle competing priorities
• Ability to understand and synthesize complex data and information to provide conclusion which will drive insights for recommendation
• Very good communication skills, able to provide financial insights to business partners in a concise and effective manner
• Fluency in English, both verbal & written

We are Coca-Cola Hellenic, a growth-focused consumer goods business and strategic bottling partner of the Coca-Cola Company. We bottle, distribute and sell an unrivalled range of products in 29 markets in Europe, Africa and Eurasia. As we do, we create value for all stakeholders, support socio-economic growth and build a more positive environmental impact.

We bring together more than 30,000 people from over 70 nationalities, coming from five continents. The diversity of our markets, from mature to emerging economies, provides a wide range of attractive opportunities for growth.

We nurture our talents. We give opportunities to people across all functions and levels, as well as different geographies, backgrounds and education. We are willing to take a risk on the people we believe in, even if they don’t have the perfect experience. We have faith in what every person can be.

And although we have so much to be proud of, we always stay humble. We believe the real magic happens - for us and for you - when we OPEN UP.

At Coca-Cola HBC, we are an inclusive employer that thrives on diversity. This means our environment provides equal opportunities for all, regardless of race, color, religion, age, disability, sexual orientation, or gender identity. Join us in nurturing a culture where everyone belongs and contributes to our collective success.