16 days old

eCom Business Intelligence Senior Specialist

New York, NY 10007
Apply Now
Apply on the Company Site
Auto req ID: 208640BR

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 a 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 Business Intelligence Specialist, you will be a primary contact point for business teams for business intelligence 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 lead 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 suite of dashboards. 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 visual dashboards, self-service portals, & embedded widgets - while focusing on repeatability, scalability and automation. Within the team, you will also lead a team of direct reports, providing guidance on career development and growth.

  • Gather, understand, & document requirements from business users
  • Manage project delivery, including estimating timelines, identifying risks, and leveraging junior resources
  • Recognize and access required data from multiple databases (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
  • Manage and mentor a team of junior staff from a career development perspective


  • Bachelors Degree (Computer Science, Engineering, or other STEM-related area preferred)
  • 5+ years of experience developing BI solutions, including leading BI projects
  • Extensive development experience with at least 1 data visualization platform (Tableau, PowerBI, SuperSet, etc.)
  • Experience writing complex SQL queries to retrieve dimensional data, specifically on SQL Server, Snowflake, or Postgresdimensional data modelling experience a plus
  • Experience managing the delivery of end to end BI solution builds, including timeline and staff management
  • Experience mentoring a team of developers, management experience preferred
  • Programming in Python or JavaScript is a plus
  • Intermediate to expert level experience in Excel or Google Sheets (bonus points for VBA scripting)
  • Strong professional communication skills with both technical & non-technical audiences
  • Be inquisitive for knowledge, drive for results, yet humble

Relocation Eligible: Not Applicable
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","city":"New York City","state":"New York
Posted: 2020-05-15 Expires: 2020-06-15

Performance with Purpose

Out performing ourselves is a rush. That's why we perform with purpose. Together, we blaze new trails, succeed, celebrate and then do something even bigger. We never settle for second best. At PepsiCo we're not just committed to performing well as individuals, but as a team, to strengthen the company as a whole.

Around the world, we're working hard to give people the tastes they crave and the nutrition they need. We dream globally and act locally, constantly innovating to sustain our planet, our people, our communities and our business practices. New markets mean new ways of doing business, and new ways of addressing health concerns, cultural differences and environmental challenges. Every day is an adventure, and an opportunity for personal and professional growth.

Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

eCom Business Intelligence Senior Specialist

PepsiCo Inc.
New York, NY 10007

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast