PepsiCo Canada: IT Analytics & Automation Winter 2027 Co-op

Overview

Overview Position: IT Analytics & Automation Co-op Location: Mississauga, ON Duration: 4 months Compensation: $25.00-37.50 At PepsiCo, you'll find the opportunity to grow your career, make an impact, and help shape what's next. As one of the world's leading food and beverage companies, our beloved brands—including Gatorade, Lay's, and Quaker—help create smiles with every sip and bite. Behind our products is a connected system that starts with how we source and grow ingredients alongside farmers and extends to how we make, move, and deliver products while driving positive impact for our business and communities. At PepsiCo, we leverage an amazing range of technologies throughout our business; from mobile apps to advanced analytics, from cloud connected sensors to complex data integrations and everything in between. Reasons to Consider PepsiCo for your Co-op Placement: Ongoing professional development to expand your business knowledge Opportunities to work with a wide range of functional departments and leaders Make an impactful change with your projects Ability to flex work arrangements To work with, and learn from business partners to gain key decision-making skills Opportunities for various plant tours and visits Responsibilities As an IT Analytics & Automation Internship Intern, you will work with various business functions across PepsiCo Foods Canada, and will be responsible for gathering requirements, building applications, modernizing business processes, and driving innovation. Key responsibilities will include: Use tools like PowerApps, Power BI, Power Automate, and Databricks to build applications, automate processes, and deliver scalable data solutions Design and develop automation workflows using Power Automate to streamline repetitive business processes and reduce manual effort Build and maintain ETL pipelines to extract, transform, and load data from multiple sources into centralized reporting environments Perform data transformation and preparation in Databricks, leveraging notebooks and SQL to clean, model, and structure data for analytics and reporting Collaborate with business and technology teams to address real-world business challenges Gather and define project requirements, scope, and objectives with clients Communicate project status and updates to stakeholders Present data-driven insights through business intelligence tools to broader teams and business stakeholders Qualifications Motivated learner enrolled in a Business, Finance, Mathematics, Engineering, or IT related program Previous work experience as a Business Analyst, Data Analyst, or similar role preferred Exposure to Agile methodologies Solid communication, organizational/time-management skills required Strong skills in developing presentations and reports Strong working knowledge of Microsoft Suite (Outlook, Word, Excel, PowerPoint) and SQL preferred Experience or familiarity with ETL concepts and data transformation techniques is an asset Hands-on experience with Databricks or similar cloud-based data platforms is an asset Working experience with Microsoft Power Apps, Power BI, and Power Automate are assets. Self-motivated, enthusiastic, and able to build collaborative relationships! At the heart of PepsiCo are our people: professionals who bring curiosity, drive, and fresh thinking, working together to turn ideas into action. Across functions, teams, and markets, we collaborate to solve challenges, unlock new opportunities, and create meaningful impact for our consumers, customers, and communities. No matter your role, you'll be part of a connected community where your contributions matter, your voice is heard, and your development is supported. With opportunities to grow, belong, and smile, PepsiCo offers more than a place to build your career—it offers the chance to help create what's next. PepsiCo may use Artificial Intelligence as part of its hiring process. Specifically, we may use AI-based tools to screen, assess, or select applicants. This posting is for an existing vacancy.

Responsibilities

As an IT Analytics & Automation Internship Intern, you will work with various business functions across PepsiCo Foods Canada, and will be responsible for gathering requirements, building applications, modernizing business processes, and driving innovation. Key responsibilities will include: Use tools like PowerApps, Power BI, Power Automate, and Databricks to build applications, automate processes, and deliver scalable data solutions Design and develop automation workflows using Power Automate to streamline repetitive business processes and reduce manual effort Build and maintain ETL pipelines to extract, transform, and load data from multiple sources into centralized reporting environments Perform data transformation and preparation in Databricks, leveraging notebooks and SQL to clean, model, and structure data for analytics and reporting Collaborate with business and technology teams to address real-world business challenges Gather and define project requirements, scope, and objectives with clients Communicate project status and updates to stakeholders Present data-driven insights through business intelligence tools to broader teams and business stakeholders

Qualifications

Motivated learner enrolled in a Business, Finance, Mathematics, Engineering, or IT related program Previous work experience as a Business Analyst, Data Analyst, or similar role preferred Exposure to Agile methodologies Solid communication, organizational/time-management skills required Strong skills in developing presentations and reports Strong working knowledge of Microsoft Suite (Outlook, Word, Excel, PowerPoint) and SQL preferred Experience or familiarity with ETL concepts and data transformation techniques is an asset Hands-on experience with Databricks or similar cloud-based data platforms is an asset Working experience with Microsoft Power Apps, Power BI, and Power Automate are assets. Self-motivated, enthusiastic, and able to build collaborative relationships! At the heart of PepsiCo are our people: professionals who bring curiosity, drive, and fresh thinking, working together to turn ideas into action. Across functions, teams, and markets, we collaborate to solve challenges, unlock new opportunities, and create meaningful impact for our consumers, customers, and communities. No matter your role, you'll be part of a connected community where your contributions matter, your voice is heard, and your development is supported. With opportunities to grow, belong, and smile, PepsiCo offers more than a place to build your career—it offers the chance to help create what's next. PepsiCo may use Artificial Intelligence as part of its hiring process. Specifically, we may use AI-based tools to screen, assess, or select applicants. This posting is for an existing vacancy.