New York, New York

Auto req ID: 251619BR
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.

PepsiCos Data Science and Analytics group is a team of data engineers, BI developers, technology specialists, and business innovators who operate within eCommerce to build industry-leading systems and solutions. By focusing on machine learning and automation, the Data Science & Analytics group is pushing the bounds of possibility for PepsiCo and its strategic partners.
What PepsiCo Data Science & Analytics Business Intelligence team does:

  • Create data visualizations to unlock sales & share trends across e-commerce sales channels

  • Integrate data utilizing Airflow, SSIS, 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 PepsiCos 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 Senior Business Intelligence Engineer you will guide a team of developers to design and deliver solutions that could touch everything from semantic layer development to UAT and user training on the newly developed suites of data platforms. You will interact with databases and files on a regular basis and use your expertise to simplify processes where possible. You will manage timelines, mitigate blockers, and leverage staff to deliver viable business intelligence products such as data lakes, data warehouses, and pipelines - while focusing on repeatability, scalability and automation. Within the team, you will also assist the team by providing guidance on career development and growth.

    Responsibilities:
    Conduct and manage the full lifecycle of back end business intelligence work including requirements gathering, design, documentation, testing and validation to support the implementation of Business Intelligence analytics solutions.

  • Gather, understand, & document requirements from stakeholders and cross functional teams

  • Function as a subject matter expert in the BI and analytics space

  • Plan and manage project delivery including building roadmaps, identifying risks, and leveraging junior resources

  • Advanced SQL programming for ad hoc analysis and data consumption (including SQL Server, Snowflake, Tera data & Postgres)

  • Develop pipelines, data models, data lakes, data warehouses

  • Design reporting and business intelligence products, including visualizations & self-service tools

  • Maintaining data quality and overseeing database security

  • Present products to business users and seek feedback for continued improvement

  • Mentor a team of junior staff from career development perspective

  • Validate and review products for quality assurance prior to delivery

    Qualifications/Requirements

  • Bachelors Degree (Computer Science, Engineering, or other STEM related area preferred)

  • Minimum of five (5) years of experience with writing, debugging and performance tuning complex SQL queries

  • Advanced development experience (3+ years) with at least one data visualization platform (Tableau, PowerBI preferred)

  • Knowledge of dimensional data modelling

  • Experience managing the delivery of end to end BI solution builds, including timeline and plan resource

  • Experience mentoring a team of developers

  • Excellent analytic skills and strong communication skills written and verbal presentations

  • Be inquisitive for knowledge, driven for results, yet humble

    Additional Qualifications:

  • Experience managing and maintaining a database supporting live business tools

  • Experience working with Snowflake a plus

  • Experience with the full Microsoft BI Stack (SSIS, SSAS, SQL Server, etc.) a plus

  • Programming in Python, ETL tools (DBT is a plus)

    Relocation Eligible: Not Eligible for Relocation
    Job Type: Regular

    All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status.

    PepsiCo is an Equal Opportunity Employer: Female / Minority / Disability / Protected Veteran / Sexual Orientation / Gender Identity

    Our Company will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of the Fair Credit Reporting Act, and all other applicable laws, including but not limited to, San Francisco Police Code Sections 4901 - 4919, commonly referred to as the San Francisco Fair Chance Ordinance; and Chapter XVII, Article 9 of the Los Angeles Municipal Code, commonly referred to as the Fair Chance Initiative for Hiring Ordinance.

    If you'd like more information about your EEO rights as an applicant under the law, please download the available EEO is the Law & EEO is the Law Supplement documents. View PepsiCo EEO Policy

    Please view our Pay Transparency Statement
  • New York, New York

    At PepsiCo, we proudly support veterans, both within our walls, and in our communities.  Veterans make our country, and our company, stronger.  VALOR, our veteran and military employee resource group, just celebrated their 10th anniversary.  Their mission is to recognize, appreciate and support military, veterans, their families and our communities and to strengthen PepsiCo's role as a leading military and business partner.

     

    PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world.  PepsiCo generated more than $67 billion in revenue in 2019, driven by a complementary food and beverage portfolio that includes Frito-Lay, Gatorade, Pepsi-Cola, Quaker and Tropicana. PepsiCo’s product portfolio includes a wide range of enjoyable foods and beverages, including 23 brands that generate more than $1 billion each in estimated annual retail sales.

     

    Guiding PepsiCo is our vision to be the Global Leader in Convenient Foods and Beverages by Winning with Purpose.  “Winning with Purpose” reflects our ambition to win sustainably in the marketplace and embed purpose into all aspects of the business.  Learn more at www.pepsico.com.

    Similar jobs