Job Purpose

The Planning and Performance Management (PPM) Centre of Expertise (CoE) was set up in Sofia, Bulgaria in the summer of 2015.

The aim of the CoE is to support the business and be known internally as a value creator through outstanding service and financial expertise. There is a strong service oriented culture to build and maintain the reputation of the CoE.

The Centre comprises of a team of analysts who perform controlling, reporting and analytical activities to support all business units, supervised by managers leading each of the business units and key reporting areas with main focus on enabling effective decision support. The team is responsible for delivering timely and quality management reporting to support business decisions.

The CoE team comprises several areas of expertise. These are: Sales & Margin, FP&A, Group Reporting, Supply Chain, and Operational Excellence.

This role will be part of a team of report developers.  Their purpose is to help transform some of our excel-based reports into more dynamic, automated, visual reports to improve the efficiency and quality of our management information.

The BI developer will provide support to the BI manager across the following activities:

• Development of new and enhancements to existing BI reports and analysis
• New reports development

Leveraging business transformation concepts, the BI developer will support the transformation of the wider team into a “best in class” organization. This approach will ensure that finance activities are streamlined and efficient and that high quality, cost effective services and solutions are delivered.

Key Responsibilities

• Generate new ideas for creative and effective methods of presenting management information and implement these into proof of concept dashboards
• Working within an Agile development team to demonstrate value quickly
• Optimize existing processes by delivering front end reports in Power BI, Tableau and designing Alteryx workflows.
• Partnering with technology teams to communicate requirements for potential new reports
• Provide support to subject matter experts in the CoE as and when required
• Communicate with subject matter experts and report customers from the business to ensure the outputs meet their needs
• Support data quality efforts through the use and maintenance of standardized data and calculation definitions
• Complete projects as assigned by manager
• Document processes and set up / support the facilitation of process workshops for review and approval of improved reports and processes
• Analyzing source systems (particularly SAP BW and MS Access) to identify and connect to potential datasets

Experience required

• Experience with Power BI is expected. Additional training can be provided.  Alternatively experience with other dashboarding tools, such as Tableau and QlikView would be advantageous
• Ability to quickly understand reporting requirements and translate them into actionable visualizations
• Experience of working with databases; i.e. identifying and extracting data.  Specifically, understanding and experience of SAP BW, BPC and SAP is preferable
• Basic understanding of financial systems & processes
• MS Office Suite Skills, especially SharePoint, PowerPoint & Excel (including pivot tables, charts etc.)

Language Capability & expert level

English : Essential + other CCEP language

Education & Qualifications required

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

Capability required & Expert level

• Analytical Thinking – Intermediate
• Relationship Management – Foundational
• Business Performance Management - Intermediate
• Process Excellence – Foundational
• IT System Landscape – Intermediate
• Digital Skills and Automation – Intermediate