Junior Finance Analyst (with VBA)

Location overview
Working with inspiring and experienced colleagues, you'll find that the atmosphere in our city-centre office in Kraków is informal and engaging. With drive and ingenuity, our teams deliver vital services to PepsiCo employees around the world. With an active, get things-done culture, this is a place where your dynamism and agility will make a difference.

Job overview
Global Procurement Finance team plays a critical role in forecasting, reporting, and controlling direct materials cost, which represents ~40% of PepsiCo Europe P&L. FP&A.

Responsibilities

• Support data management automation and GP reporting (within Directs and Indirects Finance) by developing/maintaining current complex technical models while contributing to systems improvement projects
• Provide strong technical (VBA macros, databases) and business support through different available analytical models to GP Finance Business Partners, including preparation of presentations.
• Support Direct Material business forecasting process during all financial cycles (Monthly Forecasting, Annual and Strategic Plans)
• Support Monthly Productivity Council and Productivity/Commodity Inflation reporting to Corporate as well as Monthly Periodic Business Reviews Support Finance BPs to prepare Financial Planning reviews (presentations) to BU CFOs and GPE Leadership team.
• Support GP Finance CFO and FP&A manager with ad-hoc analysis requests

Requirements

• Advanced skills in MS Office - advanced Excel user is a must including knowledge of macro commands (Visual Basic for MS Excel).
• Skills in database management
• Finance background with FP&A in a multinational company will be an asset
• Good strategic/analytical skills
• A natural interest in IT / improvement tools as well as the economy and macro trends.
• Ability to manage and execute multiple concurrent tasks to meet deadlines.
• Be a self-starter and able to work autonomously as well as being flexible.
• Fluent in written and spoken English.