Pepsico Harrison , NY 10528
Posted 5 days ago
Overview
PepsiCo is a playground for curious people. We invite thinkers, doers, and changemakers to champion innovation, take calculated risks, and challenge the status quo. From executives to team members on the front lines, we're excited about the future. We take chances. Together, we dare to make the world a better place.
Our associates are the magic ingredient. Each of them plays an integral role in helping create deep connections between people and our products. Think about your last group celebration: Chances are, one of our iconic brands was by your side. At PepsiCo, you're invited to be a part of a global team of innovators who make, move, and sell these products-which are enjoyed by more than 1 billion people a day.
A career at PepsiCo means working in a culture where everyone's welcome. Here, you can dare to be yourself. No matter who you are or where you're from, you can influence the people around you and the world at large. By showing up, you'll have the opportunity to learn, develop and grow your skills for the future. Our supportive teams can fuel your professional goals to make a global impact on people and the planet.
Join us. Dare for Better.
The PepsiCo North America (PBNA) Business Process Control Analytics team is looking for a Data Visualization Analyst who is data oriented, analytical, and has intellectual curiosity to understand processes within various functions of the PBNA Business Process Control Organization. The Data Visualization Analyst 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.
Write SQL queries to support data pipeline and ingestion
Design Tableau/Power BI dashboards to meet stakeholders' needs
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 data visualization/reporting solutions and tools such as Tableau, Power BI and SAP Business Objects
Experience in Extract, Transform and Load (ETL) processes using Python, Spark or other programming languages
Intellectual curiosity and willingness to learn new tools and techniques 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 troubleshoot and fix errors in existing solutions
Compensation and Benefits:
The expected compensation range for this position is between $72,900 - $122,100 based on a full-time schedule
Location, confirmed job-related skills and experience will be considered in setting actual starting salary
Bonus based on performance and eligibility; target payout is 5% of annual salary paid out annually
Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement
In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility: Medical, Dental, Vision, Disability, Health and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan
Qualifications
Bachelor's degree or Master's degree in Analytics, Information Systems, Statistics, Economics, Mathematics, Engineering, or Computer Science
3+ years of overall professional experience in either a technical (I/T) department or as a liaison between I/T and Finance
2+ years of experience in SQL query, optimization, and performance tuning
2+ years of experience in Tableau, PowerBI or other visualization tools
End-to-end technical solution design, including data design, ETL process design, and dashboard design
Preferred Qualifications:
1+ year of development experience in SSIS Packages and Python to build high-volume ETL/ELT pipelines.
Fluent with Azure cloud services. Azure Certification is a plus
Fluent in GIT
Development experience in SSIS Packages and Python to build ETL/ELT pipelines
Experience with data science, cloud platforms, and other programming languages
Familiarity with Office 365 online environment including Power Apps
This position is limited to persons with indefinite right to work in the United States
EEO Statement
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
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
Pepsico