Lead Engineer 1

OverviewThis role will help to enable accelerated growth for PepsiCo by building pipelines, aligning data, building Visualization, and performing predictive and prescriptive analytics approaches for PepsiCo to drive actionable insights for the North American market.Key responsibilities will be to build and manage data to be used for analytics, report creation, data Visualization projects, and designing automation processesResponsibilitiesOwnership of ongoing maintenance and creation of new dashboardsRigorous Excel experience, Multiple Data Systems - For Analytics like Bobj, RSI, Retail Link, Circana, etc. Good with Data Analytics & Analysis, CPG /Retail Experience must, Experience with Visualisation/Dashboard build like PBI, Tableau, etc, Worked with Senior Leaders in the Org, Good handle on KPI/Metrics reporting,Good to have Knowledge on Predictive Analytics, Analytical Tools - R/Python/SQL.Work across multiple functions to aid in collecting insights for action-oriented cause of change analysisBuild analysis in Excel, PBI, and Python with accompanying documentationEnsure delivery of accurate and timely data by the agreed service level agreementFocus on speed of execution and quality of service delivery rather than the achievement of SLAsRecognize opportunities and take action to improve the delivery of workImplement continued improvements and simplifications of processes, standardization of reporting, and optimal use of technologyCreate an inclusive and collaborative environmentQualifications5+ years of experience in Sales Reporting & Analytics, Minimum 2 years in Data Analytics & Reporting, preferably CPG Analytics.Preferred experience from a strong top-tier consulting or prior Fast Moving Consumer Goods (FMCG) companyGood analytical skills - excellent competency in MS Excel is a must, as is experience of managing complex, incomplete & inconsistent datasets and defining strategic analytics (market sizing/growth forecasts, etc). e.g, Tools like Knime, Python, RDeep grounding in analytical logic and ability to translate complex data into powerful insightStrong experience in data transformation, data visualization, and exploratory analysis Strong Change Management Skills: Follow Up, Follow Through, Accountability, Sense of Urgency, and superior stakeholder managementAbility to provide new ways of approaching situations and developing new, efficient solutionsIndependent & motivated individual; ability to receive direction and convert into an action plan with coaching and feedbackBest-in-class time management skills, ability to multitask, set priorities, and plan