<a href="https://www.myworkday.com/usfoods/d/task/2998$47185.htmld" target="_blank">ARE YOU A CURRENT US FOODS EMPLOYEE? PLEASE APPLY DIRECTLY THROUGH OUR INTERNAL WORKDAY CAREER SITE</a>Join 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 (Mergers &amp; Acquisitions) is responsible for the development and implementation of data pipeline solutions to support the organization’s reporting, analytics, and other data needs. The Data Engineering Intern (M&amp;A) is also responsible for analyzing existing data pipelines leveraged during M&amp;A integration process and developing recommendations for improvement. 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:<ul><li>Design and build large scale datasets for a wide range of consumer needs</li><li>Build, test and implement highly efficient data pipelines using a variety of technologies</li><li>Ensure consistent use of standard data structures</li><li>Analyze new data sources to understand quality, availability and content</li><li>Write technical design documentation</li><li>Create and executes unit tests</li><li>Supports QA team during testing</li></ul>BASIC REQUIREMENTS:<ul><li>Currently pursuing a Bachelor’s Degree or Master’s Degree in Computer Science, Engineering, Data Science, Information Systems/Science or related area of study</li></ul><ul><li>Must be enrolled in school during internship</li><li>Typically, students currently between their Junior and Senior years or between their 1st and 2nd years of graduate school will be considered for internships</li><li>Proven ability to model data for reporting and analytics needs</li><li>Proven ability to analyze and understand existing processes and code</li><li>Works and communicates effectively with all levels of management</li><li>Excellent written, verbal, and interpersonal skills</li><li>Must work well within team-oriented environments</li></ul>PREFERRED SKILLS:Proficiency in one or more of the following: <ul><li>SQL</li><li>Oracle, MySQL, other relational databases</li><li>Python</li><li>AWS (ERM, Lambda, IAM, S3)</li><li>Linux</li></ul>Familiarity with: <ul><li>Use of CI/CD tools (Chef, Jenkins, Bamboo, Git/Bitbucket)</li><li>Supporting self-service reporting and analytics</li><li>Working with semi-structured data</li><li>Excel</li></ul>Nice to have:<ul><li>Snowflake</li><li>Airflow</li><li>R or Pandas</li><li>API development (Mulesoft)</li><li>Machine Learning</li><li>Tableau</li><li>Alteryx</li><li>Kinesis or Kafkta</li></ul>ADDITIONAL REQUIREMENTS:<ul><li>Must have regular, reliable method of transportation to commute to US Foods’ location.</li></ul>RELATIONSHIPS INTERNAL/EXTERNAL MAY INCLUDE:<ul><li>Internal: Core Team, Internal Business Clients</li><li>External: Vendors</li></ul>***EOE – Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Age/Genetic Information/Protected Veteran/Disability Status***