Business Intelligence Developer

Location: MIGUEL HIDALGO, Distrito Federal, Mexico

Overview CAREERS TO SMILE ABOUT At PepsiCo, you’ll discover a place where our mission is to create smiles around the world. With a portfolio of more than 500 beloved brands including, Gatorade, Lay’s and Quaker, our work touches millions of people every day. At the heart of the company is a team of thinkers, creators, and problem-solvers who collaborate to innovate and turn ideas into action. Driven by innovation and a focus on creating joyful moments through food and drinks, our decisions are guided by consumer centricity, creating opportunities for our associates to do meaningful work and make a lasting impact in the communities we serve. Whatever your role, you’ll be part of a global community that values your ideas and empowers you to make an impact, on your career and on the world around you. Responsibilities The Opportunity • The Business Analytics and Sustainment Developer contributes to PepsiCo Beverages North America’s success by developing relationships with our end users and helping them get to the answers they need to run the business through reporting. • This position requires a person with a strong understanding of Food and Beverage Supply Chain as well as good interpersonal skills. The candidate should also be able to convert business requirements into technical and visa versa Your Impact As SC Engineer your responsibilities would consist of: Be the primary business contact for their respective SC Functional Area (Logistics, Planning, Manufacturing, Integration) working to ensure their end users can leverage reporting effectively o Own existing dashboards for their subject matter area. This includes: Enhancing existing dashboards Maintaining and updating front end logic o Lead End User Training o Assist in our Dashboard consolidation efforts to ensure the team supports the right work and metrics. Begin conversion of existing Tableau Dashboards into PowerBI Reading legacy SQL code understand the logic used o Converting Tableau LODs into DAX calculations Work with the Data Engineering team in building out PowerBI Data Models which all dashboards will be sourcing data from. Work with Strategic Initiatives to scale out projects and make them sustainable for the long term Qualifications Who Are We Looking For? • Fluent in English • Bachelor's degree required; concentration in Supply Chain, Statistics, Engineering, Economics or Business preferred • 2-4+ years experience in Supply Chain Management/Operations • Experience in day-to-day business processes related to DSD and Warehouse Delivered Operations • Advanced understanding of Tableau and Power BI visualization tools • High proficiency with MS Office products particularly Excel, PowerPoint and Outlook • Experience with troubleshooting VBA Macros • Beginner Level SQL skills, comfortable reading SQL code and writing basic queries • Working knowledge of Alteryx preferred but not required • Superior analytical and problem-solving skills • Strong organizational and time management skills • Strong written and oral communication skills • Strong interpersonal skills, ability to influence others • Demonstrated ability to leveraging system and tools 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. And 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 work force and innovation for the organization.

Responsibilities

The Opportunity • The Business Analytics and Sustainment Developer contributes to PepsiCo Beverages North America’s success by developing relationships with our end users and helping them get to the answers they need to run the business through reporting. • This position requires a person with a strong understanding of Food and Beverage Supply Chain as well as good interpersonal skills. The candidate should also be able to convert business requirements into technical and visa versa Your Impact As SC Engineer your responsibilities would consist of: Be the primary business contact for their respective SC Functional Area (Logistics, Planning, Manufacturing, Integration) working to ensure their end users can leverage reporting effectively o Own existing dashboards for their subject matter area. This includes: Enhancing existing dashboards Maintaining and updating front end logic o Lead End User Training o Assist in our Dashboard consolidation efforts to ensure the team supports the right work and metrics. Begin conversion of existing Tableau Dashboards into PowerBI Reading legacy SQL code understand the logic used o Converting Tableau LODs into DAX calculations Work with the Data Engineering team in building out PowerBI Data Models which all dashboards will be sourcing data from. Work with Strategic Initiatives to scale out projects and make them sustainable for the long term

Qualifications

Who Are We Looking For? • Fluent in English • Bachelor's degree required; concentration in Supply Chain, Statistics, Engineering, Economics or Business preferred • 2-4+ years experience in Supply Chain Management/Operations • Experience in day-to-day business processes related to DSD and Warehouse Delivered Operations • Advanced understanding of Tableau and Power BI visualization tools • High proficiency with MS Office products particularly Excel, PowerPoint and Outlook • Experience with troubleshooting VBA Macros • Beginner Level SQL skills, comfortable reading SQL code and writing basic queries • Working knowledge of Alteryx preferred but not required • Superior analytical and problem-solving skills • Strong organizational and time management skills • Strong written and oral communication skills • Strong interpersonal skills, ability to influence others • Demonstrated ability to leveraging system and tools 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. And 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 work force and innovation for the organization.