Overview
Europe Sector is the biggest region beyond North-Amercia business with UK and Russia being the biggest countries. Europe sector is composed of 2 key businesses (Beverages and Snacks) from which the business is divided into Clusters (6 for Snacks, 5 for Beverages) - each clusters being a composition of different markets (40+ markets in Europe sector). At Europe Sector Business Intelligence CoE, we enable confident decision making and want to be the Undisputed source for holistic data performance by building cutting edge capabilities embedded into all critical business forums.
To achieve this, we're using and developing contiunuously our BI platform (PPD - PepsiCo Performances Drivers) leading the IT development alongside of managing the reporting for European C-Suite and building stronger capabilities around Shoppers, Connected Stories and Forward activities. PepsiCo business performances are tracked across 30 countries and 4 macro-categories (Snacks, Beverages, Grains & Dairy).
The Europe Business Intelligence is structured around 2 teams, working in close collaboration with joint objectives :
Making 'Business Impact'
Providing 'BI Enablers'
Responsibilities
The person will be will be playing an active role in the 'BI Enablers' Team as part of the Global - Europe Business Intelligence Center of Excellence.The person should have very strong Business Intelligence skills and will play a critical role in executing key transformations of Global PPD. Driving simplification, standardization and self service capabilities agenda along with enhancing the platform by driving key initiatives that will further drive the adoption of the platform.The person should be able to translate the business requirements into accurate IT/platform development plans and will manage platform development accordingly.Provide leadership and review work done by team member/sAlongside of this, the person will be the owner of the Multi-Sources reporting expansion (Household panel, Product preference, Brand preference...)Expect some strong data manipulation on excel, Tableau &/or PowerBI and heavy usage of Nielsen Retail Panel and Kantar/GFK/Ipsos Household Panel
Qualifications
• B. Tech/B.E./MCA from reputed institutes
• 5+ years of experience with Analytics and developing BI solutions - Expertise in Tableau and PowerBI
• Expert on "Point of Sale" (Nielsen, IRI, SPINs, One Click Retail etc.) databases/metrics a must
• Experience in performance tuning (pushdown logic, calculated columns and measures, data loading strategies, filtering data, variables.
• 5+ years of experience with Analytics and developing BI solutions - Expertise in Tableau and PowerBI
• Expert on "Point of Sale" (Nielsen, IRI, SPINs, One Click Retail etc.) databases/metrics a must
• Experience in performance tuning (pushdown logic, calculated columns and measures, data loading strategies, filtering data, variables)
• Experience in User-centered design, wireframing, knowledge of the data visualization concepts, Development of visualizations and interactivity depending on the context and overall focus on aesthetics
• Structured thinker / problem solver who works independently with attention to detail
• Good knowledge of handling databases and proficiency in SQL and Python
• Excellent communication & presentation skills (verbal & written) is mandatory. Confident communicator, able to express ideas and convey complicated concepts simply
• Experience working in an Agile team
• Must be detail oriented with excellent organizational/time management skills