US Foods
Intern - Data Engineer, M&A (Hybrid: Onsite & Remote)
US Foods, New York, New York, United States
US Foods Summer Internship Program
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. Essential Duties and Responsibilities: Design and build large scale datasets for a wide range of consumer needs Build, test and implement highly efficient data pipelines using a variety of technologies Ensure consistent use of standard data structures Analyze new data sources to understand quality, availability and content Write technical design documentation Create and executes unit tests Supports QA team during testing Basic Requirements: Currently pursuing a Bachelor's Degree or Master's Degree in Computer Science, Engineering, Data Science, Information Systems/Science or related area of study Must be enrolled in school during internship Typically, students currently between their Junior and Senior years or between their 1st and 2nd years of graduate school will be considered for internships Proven ability to model data for reporting and analytics needs Proven ability to analyze and understand existing processes and code Works and communicates effectively with all levels of management Excellent written, verbal, and interpersonal skills Must work well within team-oriented environments Preferred Skills: Proficiency in one or more of the following: SQL Oracle, MySQL, other relational databases Python AWS (ERM, Lambda, IAM, S3) Linux Familiarity with: Use of CI/CD tools (Chef, Jenkins, Bamboo, Git/Bitbucket) Supporting self-service reporting and analytics Working with semi-structured data Excel Nice to have: Snowflake Airflow R or Pandas API development (Mulesoft) Machine Learning Tableau Alteryx Kinesis or Kafkta Additional Requirements: Must have regular, reliable method of transportation to commute to US Foods' location. Relationships Internal/External May Include: Internal: Core Team, Internal Business Clients External: Vendors ***EOE Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Age/Genetic Information /Protected Veteran/Disability Status***
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. Essential Duties and Responsibilities: Design and build large scale datasets for a wide range of consumer needs Build, test and implement highly efficient data pipelines using a variety of technologies Ensure consistent use of standard data structures Analyze new data sources to understand quality, availability and content Write technical design documentation Create and executes unit tests Supports QA team during testing Basic Requirements: Currently pursuing a Bachelor's Degree or Master's Degree in Computer Science, Engineering, Data Science, Information Systems/Science or related area of study Must be enrolled in school during internship Typically, students currently between their Junior and Senior years or between their 1st and 2nd years of graduate school will be considered for internships Proven ability to model data for reporting and analytics needs Proven ability to analyze and understand existing processes and code Works and communicates effectively with all levels of management Excellent written, verbal, and interpersonal skills Must work well within team-oriented environments Preferred Skills: Proficiency in one or more of the following: SQL Oracle, MySQL, other relational databases Python AWS (ERM, Lambda, IAM, S3) Linux Familiarity with: Use of CI/CD tools (Chef, Jenkins, Bamboo, Git/Bitbucket) Supporting self-service reporting and analytics Working with semi-structured data Excel Nice to have: Snowflake Airflow R or Pandas API development (Mulesoft) Machine Learning Tableau Alteryx Kinesis or Kafkta Additional Requirements: Must have regular, reliable method of transportation to commute to US Foods' location. Relationships Internal/External May Include: Internal: Core Team, Internal Business Clients External: Vendors ***EOE Race/Color/Religion/Sex/Sexual Orientation/Gender Identity/National Origin/Age/Genetic Information /Protected Veteran/Disability Status***