Job Description

:
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) xe2x80x93 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, wexe2x80x99re 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 xe2x80x98Business Impactxe2x80x99
• Providing xe2x80x98BI Enablersxe2x80x99

Job Summary
The person will be will be playing an active role in the xe2x80x98BI Enablersxe2x80x99 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/s
Responsibilities

• Own and be accountable for the continuous PPD transformation and development efforts: Design reporting and business intelligence products including visualizations & self-service tools. Manage project delivery, including estimating timelines and identifying risks
• Collaborate with stakholders to get clarity on development briefs
• Proceed with the platform development alongside and in collaboration with the Global BI GBS Team
• Present products to business users and seek feedback for continued improvement
• Make data meaningful using advanced visualization techniques to provide actionable insights and intuitive dashboards to a broad spectrum of stakeholders to accelerate decision making.
• Develop quick designs for data visualization and work iteratively to make them deliver the data and insights useful for data driven decisions
• Expand PPD beyond Nielsen Retail Panel source with more multi-sources reports to drive more holistic and 360xc2xb0 performances reviews and assessments
• Maintain documentation and user guides for created products
• Follow the formal processes for Incidents, Change Requests, Deployments and Service Requests
• Troubleshoot complex issues and provide root cause analysis and recommendations for permanent solutions
• Identify ways to improve data reliability, efficiency, and quality. Identify bottlenecks and bugs, and devise solutions to these problems. Ensure the processes are documented.
• Work in an agile environment with the scrum team, participating actively in daily scrum and sprint planning to service the needs of the Business teams by delivering solutions.
• Maintain strong collaboration & relationship across the board - Global BI Development team, Business teams, IT, Data Modeling and Architecture teams

Qualifications

• Tech/B.E./MCA from reputed institutes
• 5+ years of experience with Analytics and developing BI solutions xe2x80x93 Expertise in Tableau and PowerBI
• Expert on xe2x80x9cPoint of Salexe2x80x9d (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

'