Intern – Data Engineer (Hybrid: Onsite & Remote)

US Foods; Rosemont (IL); Hybrid; USD 30,000 - 39,000; Full time

Benefits offered by this job

Mentorship program

Paid internship

Job summary

US Foods offers a Summer Data Engineering Internship where students work on real-world data pipeline projects, building large datasets and enabling reporting and analytics. The internship runs 40 hours per week from June through August, with a hybrid on-site/remote arrangement.

A mentor and manager provide guidance, and interns may be considered for full-time roles based on performance and business needs. Applicants must be pursuing a Bachelor’s or Master’s degree in CS/Engineering/IS, with

Qualifications

• Pursuing Bachelor’s or Master’s in CS/Engineering/IS.
• Enrolled in school during internship (junior/senior or first/second year grad).
• Able to model data for reporting and analytics needs.
• Strong communication and teamwork skills.
• Experience with SQL and Python is preferred.

Responsibilities

• Design and build large-scale datasets for a wide range of consumer needs.
• Build, test and implement highly efficient data pipelines using various technologies.
• Write technical design documentation and unit tests.
• Collaborate with QA to support testing and validation.
• Work with stakeholders across functions to deliver reliable data.

Skills

SQL

Python

AWS

Linux

ETL

Data modeling

Pandas

Spark

Tableau

API development

LLM concepts

Git

Education

Bachelor's or Master’s in CS/Engineering/IS

Tools

Snowflake

Airflow

Mulesoft

Tableau

Kafka

Copilot/Claude

Job description

ARE YOU A CURRENT US FOODS EMPLOYEE? PLEASE APPLY DIRECTLY THROUGH OUR INTERNAL WORKDAY CAREER SITEJoin Our Community of Food People!The US Foods Summer Internship Program provides a forum for students to apply classroom skills and academic training in a real-world business environment. In addition to being assigned business-impacting projects throughout the summer, students will be matched with a manager who will meet with them on a regular basis to provide direction on assignments as well as deliver performance feedback and a mentor who will be available to offer day-to-day guidance and support.Interns will also get exposure to US Foods executive leadership; have an opportunity to participate in learning and social events with other interns across business functions and have an opportunity to deliver an end of summer presentation to showcase their accomplishments with key business leaders.US Foods internships are full-time paid positions (40 hours per week from June - August) with the possibility of transitioning to a full-time position post-graduation dependent on availability and overall performance.This position has been segmented as Hybrid meaning the work is a combination of onsite and remote.Please note: We are unable to provide internships to students that require sponsorship for employment visa status (e.g., OPT, F-1, H-1B or any other visa status) now or in the future.Local candidates are encouraged to apply. For qualified students whose permanent home of record is located outside 50 miles from US Foods Corporate HQ, a sign-on bonus will be offered to partially offset housing costs for the summer.BASIC PURPOSE:With direct supervision and oversight, this intern position provides exposure and opportunity to investigate a career, gain business knowledge and practical application of data engineering within the food distribution industry.The Data Engineering intern is responsible for the development and implementation of data pipeline solutions to support the organization’s reporting, analytics, and other data needs. The developer will work closely with stakeholders across functional areas to deliver well-structured data in a reliable, efficient, and timely way.ESSENTIAL DUTIES AND RESPONSIBILITIES:Design and build large scale datasets for a wide range of consumer needsBuild, test and implement highly efficient data pipelines using a variety of technologiesEnsure consistent use of standard data structuresAnalyze new data sources to understand quality, availability and contentWrite technical design documentationCreate and executes unit testsSupports QA team during testingBASIC REQUIREMENTS:Currently pursuing a Bachelor’s Degree or Master’s Degree in Computer Science, Engineering, Information Systems/Science or related area of studyMust be enrolled in school during internshipTypically, students currently between their Junior and Senior years or between their 1st and 2nd years of graduate school will be considered for internshipsProven ability to model data for reporting and analytics needsProven ability to analyze and understand existing processes and codeWorks and communicates effectively with all levels of managementExcellent written, verbal, and interpersonal skillsMust work well within team-oriented environmentsPREFERRED SKILLS:Proficiency in one or more of the following:SQLOracle, MySQL, other relational databasesPythonAWS (ERM, Lambda, IAM, S3)LinuxETL experienceExposure to Cloud EnvironmentsFamiliarity with:Use of CI/CD tools (Chef, Jenkins, Bamboo, Git/Bitbucket)Supporting self-service reporting and analyticsWorking with semi-structured dataLLM Concepts, along with Agentic DevelopmentNice to have:SnowflakeAirflowSpark Data Frames or PandasAPI development (Mulesoft)Machine LearningTableauKafkaExperience with Copilot or Claude or CursorADDITIONAL REQUIREMENTS:Must have regular, reliable method of transportation to commute to US Foods’ location.RELATIONSHIPS INTERNAL/EXTERNAL MAY INCLUDE:Internal: Core Team, Internal Business ClientsExternal: Vendors***EOE – Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Age/Genetic Information/Protected Veteran/Disability Status***