Job Description

:OverviewGPEX is a global team that delivers services in the area of process and control transformation, simplification, and digitization. This role is part of GPEX Insights & Automation team that supports initiatives by identifying analytic opportunities, leading solution development from ideation to delivery and continuing with sustainment, managing milestones & stakeholder expectations, and ensuring insights are developed in compliance with the governance structure. The GPEX Analytics Sr. developer role will

• Design, document, develop and sustain analytics solutions which include E HANA, Power BI, Tableau, SQL, Chatbots, AI based solution, & Machine Learning products for PepsiCo\xe2\x80\x99s Controls organization
• Develop Analytics standards on various automation tools by leveraging industry best practices and partnering with both internal and external peers in same capacity across different groups and organizations.
• Act as a technical SME to provide guidance and trainings to associates within GPEX automation & controls business teams
• Contribute towards the overall GPEX goal of identifying process efficiency and optimizations by promoting integration of appropriate technology into business processes
• Deliver capability build sessions with business teams to grow awareness and champion citizen development model
• Develop network with peer groups across different organizations and collaborate on analytics best practices and standards
• Act as innovation lead by learning about new products, capabilities and driving pilots and Poc\xe2\x80\x99s to show their value
• Thrives on solving complex problems through insights & innovation impacting change at scale in a diverse environment

• Drive Analytics opportunity assessment and value realization \xe2\x80\x93 Decision, Execute
• Work with GPEX Process Transformation, Risk Internal Controls & Business teams to conduct analytics opportunity assessment sessions and identify potential value.
• Analyze and assess analytics feasibility, translating business requirements into technical designs
• Design/build/test/deploy analytics utilizing SAP HANA and build analytic/visualization output in Tableau/Power BI/Alteryx/ Tellius
• Create analytic procedures, data transformation, and analysis methods
• Identify opportunities to drive efficiencies within processes by suggesting new and innovative ways to leverage technology
• Work with business partners to identify analytic opportunities
• Leverage leading best practices to build analytics and share with cross functional teams
• Partner with Control Insights & Automation team to drive common governance standards, policies and procedures, etc.
• Train end users on how to use the analytics and understanding of data
• Manage projects related to the expansion of automation technology use in Support planning and prioritization of deliverables along with managing stakeholder expectation.
• Work independently but also function well within a team of developers to drive cross functional learning, development and sharing of leading practices \xe2\x80\x93 Execute, Consult
• Develop strong working relationships with internal partners, both business users and technical resources
• Participate in strategy development sessions with manager.
• Collaborate with technical architect & development team to solution Analytics & automations
• Participate in reporting automation, optimization, and other projects related to analytics and reporting
• Provide status and escalate issues to supervisor
• Contribute to continuous improvement \xe2\x80\x93 Execute, Consult
• Work with business partners to understand areas for improvement and document those opportunities
• Continuous assessment of analytics standards and governance processes, enahce them in compliance with PepsiCo\xe2\x80\x99s control framework
• Identify opportunities for replication and reusability of existing logics & technology to drive additional organizational efficiency
• Collaborate with other members of the Global Virtual Team to create comprehensive documentation in accordance with published standards
• Reporting \xe2\x80\x93 Execute
• Provide quality review of analytics documentation
• Develop project tracking and efficiency reporting templates
• Monthly and quarterly reporting of deliverables and achievements to leadership

• Deep understanding of SAP technical/functional design, IT, risk, controls, and segregation of duties
• Expert level data analytics knowledge required withbroader understanding of business processes, financial Analysis and Controls.
• Advanced analytics experience which includes ability to work with macros, formulas, big data and building analytic procedures in SQL, SAP HANA XSA, R programming.
• Experience of design and implementation of SAP compliance and reporting tools
• Experience with Visualization tools (Tableau, Power BI, Alteryx), presenting large dashboards and KPIs.
• Client and delivery orientated along with leadership experience to lead a team of global developers
• Ability to manage complexity and work independently with large amounts of information
• Higher education degree; Computer Science, Computer Engineering, Mathematics. Management Information Systems, Finance, Accounting, Procurement, business or related field
• Cross-functional business and application knowledge
• Ability to create proper functional/ business requirements, document process flows and detailed specifications
• Ability to learn new technologies and processes quickly
• Ability to break down business problems into logical tasks and think creatively
• Project and change management experience, preferably involving IT implementations and UAT management
• Well versed with lean Six Sigma, Agile and other project methodogies
• Strong facilitation/presentation skills
• Ability to work with a large, global, functionally diverse, and informed user base that demands high-quality applications
• Must be able to work on multiple initiatives simultaneously and prioritize assignments to deliver quality work in a timely manner
• Ability to effectively engage and work with a global team
• Must possess atleast Data Analyst certification.
• Knowledge on Power Platforms and RPAs.
• Knowledge of/experience with SAP
• Strong Communication and presentation skills with Positive attitude
• Self-motivated and willing to work in an energetic, fast-paced environment
• Potential adhoc travel \xe2\x80\x93 no more than 10%
• Experience in at least 1 AI and ML tool.
• Project Delivery Experience
• Offshore Delivery interaction and management

PepsiCo