BI Engineer

BI Engineer - Digital Commerce Company: PepsiCo Location: Vitoria-Gasteiz, Basque Country, Spain 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 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 our International expansion and delight our consumers through addressing of current and future facing business 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. Responsibilities 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. Maintain the project documentation and generate reports on project status. Qualifications 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. Differentiating Competencies Required Self‑starter; bias for action and for quick iteration on ideas / concepts; strong interest in proving out ideas and technologies with rapid prototyping. Ability to interact well across various engineering teams. Team player; excellent listening skills; welcoming of ideas and new ways of looking at things; able to lead brainstorming sessions and elicit input from team members – including those who may not be the loudest voice in the room. Reformulate highly technical information into concise, understandable terms for presentations. 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. Seniority level Mid‑Senior level Employment type Full‑time Job function Business Development and Sales Industries Manufacturing and Food and Beverage Services #J-18808-Ljbffr