Sr. Python Developer

Key Skills

Java Programming, SAP, Oracle, Python Programming, SQL, DevOps, Git, Azure, PowerBI, ETL/ELT technologies, Tableau, ETL frameworks

Job Description

Are you looking for a challenging opportunity in an organization with a dynamic, innovative, and diverse environment? If so, your future is at PepsiCo. As a world class company, we seek excellence in everything we do. Therefore, we need talented, innovative people who are passionate about what they do.

At PepsiCo Beverages North America, we are a beverages business focused on creating smiles for our consumers and employees. As part of the Finance, Control organization we interact with and support many different business areas. This is an opportunity to join a diverse team that works to deliver automation and analytics solutions to increase productivity and efficiency.

Summary:

The PepsiCo North America (PBNA) Business Process Control Analytics team is looking for a Senior Data Engineer who is data oriented, analytical, and has intellectual curiosity to understand processes within various functions of the PBNA Business Process Control Organization. The Senior Data Engineer will primarily focus on providing impactful analytics and workgroup solutions that enhance decision making, increase productivity, and eliminate or streamline labor intense work. The ideal candidate will have experience in developing and sustaining data analytic solutions in a dynamic environment.

Responsibilities:

• Support PBNA Finance and Control teams at the Division and Sector level through the development, implementation, and sustainment of data analytic solutions
• Interact with stakeholders to identify analytic opportunities and improvements utilizing new tools & approaches
• Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality and performance.
• Create ETL/ELT solutions and audit reusable packages or libraries.
• Revamp SSIS packages with Python
• Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape
• Demonstrate innovative and creative thought leadership on analytic logic, tools, and designs
• Lead/manage ad hoc related projects and report to management

Skills & Capabilities:

• Extensive experience in the creation, governance, maintenance, and sustainment of analytic solutions, databases, and data warehouses. Specific experience working with data structures in SQL Server, Teradata, Oracle and SAP.
• Proficient in SQL Server and capable of creating and using Stored Procedures, User Defined Functions, creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers
• Proficient in Extract, Transform and Load (ETL) processes using Python, Spark or other programming languages
• Experience in data visualization/reporting solutions and tools such as Tableau, Power BI and SAP Business Objects
• Intellectual curiosity and willingness to learn new tools and techniques in order to support a rapidly changing landscape of stakeholder needs
• Analytical mindset that can define or identify a problem, generate alternatives or potential solutions, evaluate, and implement the chosen solution
• Strong communication skills and ability partner with both technical and non-technical team members
• Able to code from scratch and proficient in text-based programming languages
• Able to troubleshoot and fix errors in existing solutions
• Qualifications/Requirements
• Bachelor’s degree or Master’s degree in Analytics, Information Systems, Statistics, Economics, Mathematics, Engineering, or Computer Science
• 4+ years of professional experience in either a technical (I/T) department or as a liaison between I/T and Finance
• 3+ years of experience in SQL query, optimization and performance tuning
• 3+ years of development experience in Python to build high-volume ETL/ELT pipelines.
• 2+ years of cloud data engineering experience in Azure DevOps.
• Familiar with Tableau, PowerBI or other visualization tools

Preferred Qualifications:

• 1+ year Visualization experience using Tableau, PowerBI or equivalent technology
• 1+ year with SAP S/4 Hana
• Experience with data science, cloud platforms, and other programming languages
• Familiarity with Office 365 online environment including Power Apps
• Fluent with Azure cloud services. Azure Certification is a plus.
• Fluent in GIT
• Experience with integration of multi cloud services with on-premises technologies
• End-to-end technical solution design, including data design, ETL process design, and dashboard design
• COVID-19 vaccination is a condition of employment for this role. Please note that all such company vaccine requirements provide the opportunity to request an approved accommodation or exemption under applicable law