at PepsiCo Corp in Chicago, Illinois, United States
Job Description
eComm Data Analyst
Overview
The PepsiCo eCommerce Division is a strategic business unit within PepsiCo, one of the world's leading food and beverage companies. The division focuses on developing and executing digital commerce strategies to drive growth and enhance consumer experiences in the online retail space. With the rapid expansion of e-commerce and the changing consumer landscape, PepsiCo recognizes the importance of leveraging digital channels to reach consumers directly and provide convenient, personalized shopping experiences.
Responsibilities
* Data Management: Oversee data integrity, quality, and accuracy by monitoring, analyzing, and resolving data issues across various systems and databases.
* Data Validation and Cleansing: Perform regular audits and validation checks to identify and rectify inconsistencies, duplications, and errors within datasets.
* Process Optimization: Continuously evaluate and improve data processes, workflows, and procedures to enhance efficiency, reduce redundancy, and increase overall productivity. Identify opportunities for automation.
* Data Governance: Develop and enforce data governance policies, standards, and best practices to ensure compliance and maintain data security and privacy.
* Documentation and Reporting: Create and maintain comprehensive documentation of data operations, including data dictionaries, standard operating procedures, and reports on data quality metrics and trends.
Compensation & Benefits:
* The expected Compensation range for this position is between $65,000 - $132,500 based on full-time schedule
* Location confirmed job-related skills and experience will be considered in setting actual starting salary
* A business development incentive equity may be awarded based on eligibility and performance
* 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
* Data Management: Oversee data integrity, quality, and accuracy by monitoring, analyzing, and resolving data issues across various systems and databases.
* Data Validation and Cleansing: Perform regular audits and validation checks to identify and rectify inconsistencies, duplications, and errors within datasets.
* Process Optimization: Continuously evaluate and improve data processes, workflows, and procedures to enhance efficiency, reduce redundancy, and increase overall productivity. Identify opportunities for automation.
* Data Governance: Develop and enforce data governance policies, standards, and best practices to ensure compliance and maintain data security and privacy.
* Documentation and Reporting: Create and maintain comprehensive documentation of data operations, including data dictionaries, standard operating procedures, and reports on data quality metrics and trends.
* Data Analysis: Utilize statistical methods and data analysis techniques to identify patterns, trends, and anomalies in datasets, providing insights to support business decisions and initiatives.
* Collaborative Teamwork: Collaborate with cross-functional teams, including data engineers, data scientists, and business stakeholders, to understand data requirements, address data-related issues, and support data-driven initiatives.
* Training and Support: Provide training and support for data management tools, systems, and best practices to ensure accurate data entry and utilization across the organization.
* Quality Assurance: Conduct regular quality assurance checks to validate data accuracy and consistency and implement appropriate measures to resolve any identified discrepancies.
* Continuous Learning: Stay up-to-date with industry trends, emerging technologies, and advancements in data management and analysis techniques, and apply them to improve data operations.
* Team Commitment: Help fill any gaps not specifically defined by this role to ensure overall team success.
Required Qualifications:
* Bachelor's or Master's Degree in Computer Science, Information Technology or related field.
* Proven experience (5+ years) in data management, data analytics, or a similar product operations role.
* Strong understanding of master data management principles, data governance, and data quality management.
* High proficiency in SQL and RDBMS databases (e.g. PostgreSQL), with experience in working with large datasets.
* Analytical mindset with the ability to interpret complex data and provide actionable insights.
* Excellent problem-solving skills and meticulous attention to detail.
* Obsessive commitment to quality and continual improvement.
* Strong communication skills, both written and verbal, with the ability to effectively collaborate with cross-functional teams.
* Ability to interact with all levels of the organization, and across various functions such as engineering and commercial teams.
* Self starter; bias for action and not easily deterred – willing to search out answers to difficult or complex questions.
* Experience defining requirements and developing applications, reports, analytics tools, and back-end data processing jobs.
Preferred Qualifications:
* Experience with cloud data warehousing technologies (e.g. Snowflake).
* Knowledge of data modeling technologies such as DataVault.
* Knowledge of programming languages (e.g., Python, DBT, Elixir) is a plus.
* Familiarity with data visualization tools (e.g., Tableau, Power BI) and data management platforms.
* CPG background preferred; in particular solid understanding of how product supply chain and brand management work.
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
