Analyst, Commercial Reporting

We are Coca-Cola Europacific Partners (CCEP) – a dedicated team of 42,000 people, serving customers in 31 markets, who work together to make, move and sell some of the world’s most loved drinks. We are a global business and one of the leading consumer goods companies in the world.

Job Purpose

The role provides insightful, accurate and timely performance reporting and analysis to stakeholders within the Northern European Business Unit. The role sits alongside reporting teams for CCEP’s other Business Units and offers an opportunity to work within a high-performing team focused on delivering timely and quality standard management and operations reporting, ad-hoc analysis and design of new reports.

The activities of the Commercial Reporting Team are aimed to support the decision making process of the commercial business units, to ultimately accelerate business performance for CCEP. The successful candidate will combine strong analytical skills and commercial curiosity with the ability to collaborate effectively and drive efficiency/continuous improvement. We are now looking for a Commercial Reporting Analyst to join our Commercial Reporting Team. The role sits alongside reporting teams for CCEP’s other Business Units and offers an opportunity to work within a high-performing team focused on delivering timely and quality standard management and operations reporting, ad-hoc analysis and design of new reports.

The activities of the Commercial Reporting Team are aimed to support the decision making process of the commercial business units, to ultimately accelerate business performance for CCEP. The successful candidate will combine strong analytical skills and commercial curiosity with the ability to collaborate effectively and drive efficiency/continuous improvement.

Key Responsibilities

• Prepare and distribute reports using primarily BI tools (e.g. Power BI, Tableau) and occasionally MS Excel based on request from the stakeholders in an accurate and timely manner.

• Amend existing reports and build new reports through manipulation of data using BI tools, Analysis for Office, MS Excel, or other systems (egg. direct SQL connection to the data lake).

• Support the commercial processes for the respective BU of responsibility – month-end closing, forecast, budget, weekly and daily reporting (where applicable).

• Prepare ad hoc reports and report initial analysis in response to requests from end-users.

• Identify reliable data source for reporting or ad hoc analysis requests.

• Extract, cleanse and validate the necessary data from the relevant systems required for the production of reports.

• Support projects, reporting applications changes and upgrades.

• Provide insights and proposals on process and reporting improvement, standardization and simplification within his/her area of expertise.

• Provide regular feedback on the performance and reliability of BPT systems as a basis for ensuring the quality and accuracy of data.

• Build strong relationships with key internal and external stakeholders to support the execution of reporting activities and help on resolving any reporting and data issues.

Key Stakeholders

• Commercial teams in the NEBU (Strategy and Insights, Commercial Development, Field Sales, Key Accounts Management, RGM, Vending)

• Other – Finance, IT, Master Data

Experience required

• 1-3 years’ relevant experience in a dynamic environment like a multinational organization or a Shared Services Centre

• CRM experience, preferably Salesforce (ideal, not essential)

Language Capability & expert level

• Essential: English + other CCEP language

Education & Qualifications required

• Degree level education in Business Studies, Finance or Information Systems

Functional technical skills required

• MS Office Suite Skills, especially Excel (including pivot tables, charts etc.), PowerPoint - Advanced

• Salesforce (or other CRM tool) – Basic/Intermediate

• Margin Minder - Basic

• ERP experience, preferably SAP – Basic/Intermediate

• BI Tools – Power BI, Tableau, Business Objects – Basic/Intermediate

• Database query experience in SQL and/or Alteryx – Basic/Intermediate

• Dimensional modelling concepts (Star schema, Snowflake schema, Datawarehouse) - Basic

• Other – SAP Analysis for office add-in (optional)

• Understanding the sales processes and the route to market/FMCG specifics - Intermediate

• Understanding the commercial environment and needs of the business and relevant stakeholders - Intermediate

• Understanding of financial systems & processes - Basic

Behavioural Capabilities

• Analytical skills - Advanced

• Customer-oriented mindset - Advanced

• Communication skills - Intermediate

• Structured and organized - Advanced

• Can-do attitude

• Adaptability and flexibility

• Attention to details - Advanced

• Other – responsible, self-motivated individual

Our employee value proposition:

Being Rewarded

• Market Competitive Salary

• Annual Compensation & Bonus Cycle

• CCEP Shares Purchase plan & Matching Share

• Food Vouchers

• Flexible Working Allowance

Being Connected

• Everyone’s Welcome – Inclusion, Diversity & Equity Culture

• Keep In Touch program – in support of parental care

• Inspiring Office layout with Great beverages and Sofia subsidized canteen

• Referral Program

Being Developed & Valued

• Professional Qualifications Support & Sponsorship

• Ninja Community and Lean Six Sigma Certification

• CCEP learning platforms & Leadership training curricula

• Career Growth and Talent Progression

• Recognition program

Being Well

• Flexible & Hybrid Ways of Working

• Additional days paid leave at start and on top – Birthday, Qualification & Volunteering;

• Wellbeing & Sports program, including corporate discounts & subscription fees

• Wellbeing Community & Initiatives

• Employee Assistance Program

• Additional Health Plan & Dental Insurance

Being Inspired

• Social Projects & Community Charity programs

• Participation in Corporate Challenges - marathon, sports, fun

• External life coach speakers and Work-Life balance lectures

• Team Building & Fun Events

​We are Coca-Cola Europacific Partners (CCEP) – a dedicated team of 42,000 people, serving customers in 31 countries, who work together to make, move and sell some of the world’s most loved drinks.

We are a global business and one of the leading consumer goods companies in the world. We help our 2.1 million customers grow, and we are constantly investing in exciting new products, innovative technologies and fresh ideas. This helps us to delight the 600 million people who enjoy our drinks every day.