Architect - BI Engineer - Digital Commerce

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 Business Intelligent Engineer and Visualization Developer to join our team as we continue to grow our capability footprint across regions.The BI engineer will be in charge of developing, deploying, and maintaining BI & Analytics interfaces.

• Together with the Product Manager gather, understand, & document requirements from business users
• Own business layer mapping, references and hierarchies
• Recognize and access required data from multiple databases using appropriate languages
• End-to-end delivery of reporting and business intelligence products, including visualizations & self-service tools
• Continuous improvement and maintenance of business intelligence solutions
• Present products to business users and seek feedback for continued improvement
• Provide business analytics guidance as needed to ensure a quality project solution
• Integrate advanced analytics into Business Intelligence solutions to deliver clear and meaningful insights to the business
• Support analytics products in production
• Maintaining the Project documentation and generating the reports on Project status

• 5+ years of experience in Reporting and Dashboarding development, Analytics, Data Processing, SQL & Access database
• Strong interpersonal skills to effectively interact with client/onshore personnel to understand specific Enterprise Information Management requirement and develop solutions based on those requirement
• Required skills: Proficient in SQL, Python, Statistical analyses, Data visualization ( Power BI), Trend Analysis
• Master's or Bachelor's degree in math, statistics, economics, computer engineering or related analytics field from a premier/Tier1 institute of India
• Good understanding about tableau server connection and workbook import and download.
• Good understanding about DBT (Data Build Tool), model creation and .sql and .yml files.
• Very strong analytical skills with the demonstrated ability to research and make decisions based on the day-to-day and complex customer problems required
• Ability to handle big data sets, data mining from different databases
• Data warehousing, Centralizing or aggregating data from multiple sources
• Outstanding written and verbal communication skills