Senior Data Engineer

Overview The next great shift in consumer behavior driven by technological disruption is underway, and it’s happening in the food & beverage industry. As other sectors have shifted to Digital Commerce-first business models in recent years, food & beverage has continued to rely predominantly on traditional brick & mortar models, but this is changing rapidly. New technologies are transforming every aspect of reaching consumers, from the rise of digital marketing and online grocery platforms to the creation of supply chain tools that enable speedy at-home delivery. Although PepsiCo is a large multinational, the PepsiCo Global Digital Commerce Team prides itself on having the entrepreneurial, action-oriented culture of an exciting startup business. Our group includes startup founders, Silicon Valley veterans, food & beverage experts, and seasoned executives from digital transformation leaders such as Amazon and Walmart. Our goal is to build the technological products and capabilities that will reinvent our industry and make us the #1 food & beverage business in Digital Commerce for decades to come. To deepen our efforts to seize this opportunity and lead the food & beverage industry into its remarkable next chapter, PepsiCo – a global company with powerhouse brands including Frito-Lay, Gatorade, Pepsi-Cola, Quaker, and Tropicana – is expanding its Global Digital Commerce Team to power International Growth. We’re looking for the greatest minds in data & analytics, data engineering, software development, machine learning optimization and more. All with the aim to empower out International expansion and delight our consumers through addressing of current and future facing butsiness challenges that are complex and require insightful and impactful solutions. We are looking for seasoned data engineers to join our team as we continue to grow our capability footprint across regions.The DE engineer will apply Data Warehouse and Cloud techniques to build truly Global Data Product which lays a foundation to all of our current and future Capabilities. Responsibilities Own data pipeline development end-to-end, spanning data modeling, testing, scalability, operability and ongoing metrics. Contribute to best practices for engineering, and coding as part of a world class engineering team in PepsiCo. Work with the product team leveraging our core technology platforms Collaborate in architecture discussions and architectural decision making that is part of continually improving and expanding these platforms. Focus on delivering high quality data pipelines and tools through careful analysis of system capabilities and feature requests, peer reviews, test automation, and collaboration with QA engineers Introduce new tools / practices to improve data and code quality; this includes researching / sourcing 3rd party tools and libraries, as well as developing tools in-house to improve workflow and quality for all data engineers Support data pipelines developed by your team through good exception handling, monitoring, and when needed by debugging production issues Extremely comfortable working with data, including managing large number of data sources, analysing data quality, and pro-actively working with client’s data/ IT teams to resolve issues Qualifications 5+ years of experience in designing and building systems for collecting, storing, and analysing data at scale Required skills: Python, PySpark, SQL,Airflow , DBT, Big Data – Hadoop (Hive/Impala), AWS, Azure Strong interpersonal skills to effectively interact with client/onshore personnel to understand specific Enterprise Information Management requirement and develop solutions based on those requirement Experience in Retail, E-commerce or Financial Services domain is preferred. Master’s or Bachelor's degree in computer engineering or related analytics field from a premier/Tier1 institute of India Very strong analytical skills with the demonstrated ability to research and make decisions based on the day-to-day and complex customer problems required Hands on experience of handling large data sets and use of python/PySpark/SQL/Hive/Impala for data analysis Strong record of achievement, solid analytical ability, and an entrepreneurial hands-on approach to work. Outstanding written and verbal communication skills Deep understanding of database design and engineering What makes us different? • Hybrid work model: combination of remote and collaborative office experience to enable innovation • Entrepreneurial environment in leading international company • Professional growth possibilities & learning opportunities • Variety of benefits to support your physical, emotional and financial wellbeing • Volunteering opportunities to help external communities About PepsiCo We believe that culture should be at the cornerstone of everything we do at PepsiCo. We are agile, innovative and not afraid of failure. We want our team to come to work every day excited to explore new ways to bring enjoyment, refreshment and fun to the world. PepsiCo Positive (pep+) is the future of our organization – a strategic end-to-end transformation, with sustainability at the center of how we will create growth and value by operating within planetary boundaries and inspiring positive change for the planet and people. So, if you’re ready to be a part of a playground for those who think big, we’d love to chat. *We encourage the diversity of applicants across gender, age, ethnicity, nationality, sexual orientation, social background, religion or belief and disability #LI-Hybrid