eCom Business Intelligence

Key Skills

JavaScript, Java Programming, Python Programming, Database, SQL, Agile methodologies, PowerBI, SQL Server, Data science techniques, Business Intelligence, Looker, Tableau, Snowflake, Postgres, Superset, Digital Transformation

Job Description

PepsiCo operates in an environment undergoing immense and rapid change, driven by eCommerce and emergent retail technologies. To ensure continued success in the food and beverage space, PepsiCo has assembled a dedicated eCommerce team – tasked with optimizing eCommerce operations and developing innovations that will give PepsiCo a sustainable competitive advantage. While tied closely to broader PepsiCo, the eCommerce group more closely resembles a start-up environment; embracing the core values of having bias for action, being results oriented, maintaining a community-focus, and prioritizing people.

This role sits within the Business Intelligence team and is part of PepsiCo eCommerce’s Data, Technology, and Experiences (DTX) group. The DTX group is a team of Software Engineers, Product Managers, Data Scientists, Business Intelligence Engineers, Technology specialists, and Business innovators who operate within eCommerce to build industry-leading systems and solutions. With focus not just on reporting but machine learning and automation, as well, the Data, Technology, and Experiences group is pushing the bounds of possibility for PepsiCo and its strategic partners.

What PepsiCo eCommerce Business Intelligence team does:

• Create data visualizations and reports to unlock sales & share trends across e-commerce sales channels
• Integrate data utilizing Airflow, SSIS, DBT, Tableau Prep, and other tools to provide quick but unified insights
• Integrate advanced analytics into Business Intelligence solutions to deliver clear and meaningful insights to the business
• Deploy data platforms and applications to enable business users and data scientists alike to rapidly derive value from raw data
• Work with PepsiCo’s strategic partners to expand their technical capabilities, thereby creating a more robust data environment
• Develop scalable tools to drive automation and optimize business operations

As a BI Engineer (Front-End), you will be a primary contact point for business teams for business intelligence, analytics and reporting requests. You will gather requirements from business users and will need to understand the questions that need to be answered at the core of their requests. You will interact with databases and files on a regular basis and use programming to simplify processes where possible. You will create viable business intelligence products such as visual dashboards, self-service portals, & embedded widgets - while focusing on repeatability, scalability, and automation.

Responsibilities:

• Gather, understand, & document requirements from business users
• Recognize and access required data from multiple databases using SQL queries (including SQL Server, Snowflake, & Postgres)
• Design reporting and business intelligence products, including visualizations & self-service tools
• Present products to business users and seek feedback for continued improvement
• Provide business analytics guidance as needed to ensure a quality project solution
• Support analytics products in production
• COVID-19 vaccination is a condition of employment for this role. Please note that all such company vaccine requirements provide the opportunity to request an approved accommodation or exemption under applicable law.

Qualifications/Requirements

• Bachelor’s Degree (Computer Science, Engineering, or other STEM related area preferred)
• Intermediate development experience with at least 1 data visualization platform (Tableau preferred; bonus: PowerBI, SuperSet, Looker, etc.)
• Experience writing complex SQL queries to retrieve dimensional data, specifically on SQL Server, Snowflake, or Postgres
• Experience working with data transformation tools (DBT preferred)
• Programming in Python or JavaScript is a plus
• Experience with Jira and Agile project management (Nice-to-have)
• Experience in data science or advanced analytics a plus
• Strong professional communication skills with both technical & non-technical audiences
• Be inquisitive for knowledge, driven for results, yet humbl