Process Automation Associate Manager

Job Description

Auto req ID: 206995BR

Job Description

Job Summary:

The Business Process Control (BPC) Business Intelligence (BI) team is looking for an Associate Manager who would lead the automation of various processes to increase efficiency, capability, and controls by proactively evangelizing new technologies and approaches within the functions of PepsiCo Beverages North America (PBNA). The Process Automation Associate Manager is analytical, data oriented and has intellectual curiosity to understand processes across different functions, leading various automation initiatives, provide analytics and workgroup solutions that enhance productivity and eliminate or streamline labor intense work.

Responsibilities:

  • Manage portfolio of BI solutions and be responsible for delivery of all project tasks and outcomes
  • Partner with internal customers to assess needs and design solutions to improve efficiencies by automating repetitive processes; improve controls through standardization of workflows
  • Provide end-user technical support 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 a 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 as well as appropriate risk assessment and governance
  • Lead requirements and scoping sessions with business partners to understand, define and anticipate business needs; create data and quality assurance reviews and direct stakeholders/customers in quality testing to ensure requirements have been met and design is optimized for functionality and performance
  • 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 SharePoint, Office 365, Robotic Process Automation (RPA) software such as UiPath and/or WinAutomation, 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 of SharePoint 2013 on premise to SharePoint online environment including custom built Power Apps and Power Automate (Flow)
  • 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
  • Evangelize for new tools and approaches with customers; clearly articulate benefits of automation to increase efficiency of routine tasks, provide enhanced analytical capabilities and enhance the control environment
  • Participate in and lead continuing education training seminars/classes in areas of technical expertise

Qualifications/Requirements

Education & Experience:

  • Bachelor of Science in Information Systems/Technology, Computer Science, Business Administration, Finance, Accounting or related field
  • 5-8 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
  • Certification in Project Management, a plus

Skills & Capabilities:
  • Experience in project and change management with excellent written and verbal communication skills
  • Solid organizational skills including attention to detail and multi-tasking
  • Analytical mindset that can define or identify a problem, generate alternatives or potential solutions, evaluate, provide recommendation and implement the chosen solution
  • Intellectual curiosity and willingness to learn new tools and techniques to support a rapidly-changing landscape of customer needs
  • Working knowledge of Microsoft SharePoint 2013 including site creation and maintenance; customization of web parts, workflow and other process automation techniques
  • Familiarity with Microsoft SharePoint Designer and ShareGate tool used for SharePoint migration
  • Experience in Office 365 online environment including creation of new SharePoint sites, using Power Apps and Power Automate (Flow); building custom views and familiarity with available apps
  • Knowledge of Robotic Process Automation (RPA) and the use of various software such as UiPath and/or WinAutomation including RPA governance
  • Understanding of Structured Query Language (SQL) in a relational database environment including MS SQL Server, Oracle, and Sybase; ability to run queries and interpret results
  • Familiarity with Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS)
  • 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
  • Proficient in Microsoft Office Suite (Word/Excel/Access/Visio/PowerPoint)
  • Knowledge of QuickBase

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