1+ months

Process Automation Associate Analyst

White Plains, NY 10601
Auto req ID: 206942BR

Job Description

The Business Intelligence (BI) team is looking for an Associate Analyst who is analytical, data oriented and has intellectual curiosity to understand processes within various functions of PepsiCo Beverages North America (PBNA) Business Process Control Organization. The Process Automation Associate Analyst will manage and support existing applications/processes, provide analytics and workgroup solutions that enhance productivity and eliminate or streamline labor intense work.


  • Manage and provide end-user technical support/troubleshoot and performance-tune BI applications as necessary by resolving system issues for ongoing sustainability of business-critical finance related period-end processes as well as various PBNA functions (sales, marketing, global procurement, etc.); potential for periodic on-call duty supporting existing BI applications and services
  • Review and update documentation for all application standard operating procedures
  • Interact with Sector Headquarters and Division locations on system improvements utilizing new tools & approaches; provide enhanced analytical capabilities; perform complex calculations on large data sets
  • Interact with numerous BI tools such as MS SQL Server Services including SSIS/SSAS/SSRS, MS Visual Studio .NET framework, SAP Business Objects, Tableau, MS Excel and/or Access using advanced Visual Basic for Applications (VBA)
  • Support migration activities of internal SQL and Web/App servers to upgraded Windows environment
  • Manage work request queue in accordance with team Project Management Office (PMO) policies and internal ticket tracking BI Support Center; ensure requests are addressed in a timely manner
  • Collaborate with the team on required day to day support
  • Participate in continuing education training seminars/classes in areas of technical expertise


Education & Experience:

  • Bachelor of Science in Information Systems/Technology, Computer Science, Business Administration, Finance, Accounting or related field
  • 1-3 years of professional experience in either a technical (I/T) department or as a liaison between I/T and Finance
  • Analytical experience or equivalent business intelligence experience in support of the finance or accounting function
Skills & Capabilities:
  • Analytical mindset that can define or identify a problem, generate alternatives or potential solutions, evaluate and choose between these and implement the chosen solution
  • Intellectual curiosity and willingness to learn new tools and techniques to support a rapidly-changing landscape of customer needs
  • Knowledge of Structured Query Language (SQL) in a relational database environment including MS SQL Server, Oracle, and Sybase
  • Experience in SQL Server and capable creating and using Stored Procedures, User Defined Functions, creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers
  • Proficient in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS)
  • Experience with basic reporting solutions and tools such as SAP Business Objects. Ability to become familiar with visual analytic tool as well as data mining software like Monarch (Datawatch), and other business intelligence tools and applications
  • Trained in ASP.NET, JavaScript / jQuery / JSON
  • Familiarity with Office 365 online environment including Power Apps
  • Knowledge of QuickBase, a plus
  • Proficient in Microsoft Office Suite (Word/Excel/Access/Visio/PowerPoint)
  • Project management skills

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","city":"White Plains","state":"New York


Posted: 2020-03-26 Expires: 2020-07-16

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.

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:

Process Automation Associate Analyst

PepsiCo Inc.
White Plains, NY 10601

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast