Health & Safety Data Analyst

Overview We Are PepsiCo Join PepsiCo and Dare for Better We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we’re excited about the future and working together to make the world a better place. Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries. Our product portfolio, which includes 22 of the world’s most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years. A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you’re from, or who you love, you can always influence the people around you and make a positive impact in the world. Join PepsiCo, dare for better. Responsibilities Opportunity The EHS Sr. Analyst will lead strategic improvements by applying analytical methodologies, managing information, and evaluating trends. This role will support better decision‑making, ensure alignment with EHS objectives, and drive efficiency in the execution of organizational strategies. Considering quality control and data validation to ensure reliability and accuracy for reporting. Support the PBNA Environmental, Health and Safety (EHS) function with Reporting and Metrics in support of the Field organization and HQ EHS team by providing accurate and reliable information. Complete and deliver accurate reports related to EHS metrics (Accidents, collisions, investigations, audits, trainings, hours of service, timecards, etc.). The role will also include responsibility to help improve the capability, efficiency and reliability of the key reports, tools and dashboards. Support the deployment of new upcoming EHS Regulatory projects (DOT Verification BOT, Matrix DQF, Road Side Stop, PBNA EHS Dashboard) by providing technical expertise for scalable and reliable solutions. Support future digitization and modernization of ETL processes and apps for the EHS function by providing general business context and technical recommendations. Develop and maintain high‑impact EHS dashboards aligned with business needs by combining business knowledge and data mindset for delivering best in class user experience. Develop and deploy techniques to ensure a data quality control, data validation and data centralization to ensure reliability by using programming skills and tools like Power Automate and Power Apps. Support on Business transformation by considering One North America project a mid‑term goal to ensure deployment with no business disruptions. Data Mapping for workflow optimization by adding technical expertise and recommendations for scalability and sustainability. Your Impact Manage the Regulatory DOT Verification process by maintaining and enhancing the current application for data transactions and document release. Develop and manage PBNA reports and trackers for accidents, collisions, audits, trainings, investigations, hours of service, etc. Support on the deployment of new projects including the Roadside Stop, Matrix DQF and the EHS HUB by including best practices, and business/technical knowledge. Design, develop, and maintain Power BI dashboards, applying best practices in visualization (color, contrast, alignment, consistency) and working iteratively with end users to ensure usability and alignment across supply chain reporting. Build and optimize scalable data models to support adaptability and long‑term maintenance. Use SQL to integrate data from multiple sources and collaborate with data engineers to build and deploy pipelines that prepare data for reporting. Monitor and troubleshoot ETL pipelines, performing data validation to ensure accuracy and compliance with business requirements. Partner with EHS SMEs to ensure reporting and analytics align with productivity goals and the One North America initiative. Collaborate with report owners and stakeholders to migrate existing tools, develop innovative reporting solutions, and track productivity improvements. Work closely with cross‑functional teams (business analysts, data engineers, developers) to design, plan, and deliver end‑to‑end business solutions. Provide ad‑hoc analysis, user support, and troubleshooting to resolve tool‑related issues. Execute scheduled technical tasks on time, address discrepancies, escalate when needed, and maintain clear communication with business teams. Ensure data availability and accuracy, coordinating with users and technical teams when issues arise. Support the digitization and modernization of EHS reporting systems by driving strategic collaboration and continuous improvement. This includes building scalable solutions, establishing a single source of truth, and ensuring adaptability for future integration with other markets. Apply effective prioritization and leverage available resources to address issues and enhancement requests efficiently. Qualifications Who are we looking for? Fluent in English (written and spoken). Bachelor’s degree in business systems, IT, Engineering, or related field, plus 2+ years of relevant experience. 2+ years of experience with Tableau and/or Power BI, including dashboard design, visualization techniques, interactivity, data blending, and data modeling. Ability to create wireframes for different user personas and deliver complete solutions. Intermediate to advanced SQL skills, with experience working with multiple data sources (Oracle, Teradata, Data Lake, etc.) to prepare and harmonize data for dashboards. Basic to intermediate knowledge of ETL concepts, with a willingness to expand expertise. Strong ability to translate business requirements into data architecture, process design, and visual solutions. Familiarity with supply chain or logistics analytics is a plus. 1+ years of programming experience in R, Python, or similar languages. Intermediate to advanced Excel skills (pivot tables, lookups, conditional formatting). Strong analytical and problem‑solving skills, with the ability to develop proactive action plans. Attention to detail. Excellent written and verbal communication skills. If this is an opportunity that interests you, we encourage you to apply even if you do not meet 100% of the requirements. What can you expect from us? Opportunities to learn and develop every day through a wide range of programs. Internal digital platforms that promote self‑learning. Development programs according to Leadership skills. Specialized training according to the role. Learning experiences with internal and external providers. We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others. Financial wellness programs that will help you reach your goals in all stages of life. A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle. Because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others. We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a workforce and innovation for the organization. #J-18808-Ljbffr