AI Data Engineer Intern: Build Scalable AI Pipelines

McKinsey & Company; New York (NY); On-site; USD 108,000 - 132,000; Full time

Job summary

McKinsey & Company offers a 10-week Data Engineering internship for summer 2027 in Atlanta, Boston, Chicago, or New York City. You will build foundational data infrastructure for AI applications, collaborating with Data Scientists, ML Engineers, and cross-functional teams to deliver AI solutions.

You will learn to design scalable data pipelines, contribute to secure data environments, and prepare data for AI-driven systems while gaining exposure to agentic and generative AI.

Qualifications

• Upcoming graduation between Dec 2027 and Aug 2028 in engineering.
• Experience in a data-focused role, including internships or academic projects.
• Ability to write clean, well-documented code with a strong preference for Python and SQL, with a growing understanding of software engineering best practices such as modular code and version control.
• Interest in or exposure to data engineering in the context of Agentic AI, Generative AI, or Machine Learning across different data formats and processing methods.
• Familiarity with commonly used data platforms such as Databricks, Snowflake, BigQuery, or similar; cloud platforms (AWS, Azure, or GCP); and foundational engineering tools such as Pandas, dbt, or LangChain.
• Exposure to basic data governance, security practices, and version control using Git.
• Developing familiarity with generative AI tools and simple agentic AI frameworks, with an eagerness to learn how LLMs can be applied to automate defined tasks.
• Exceptional time management in a complex and largely autonomous work environment.
• Strong communication skills, both verbal and written, in English and local office language(s)

Responsibilities

• Build and maintain scalable data pipelines.
• Contribute to secure data environments and prepare data for AI-driven systems.
• Collaborate with cross-functional teams and clients to deliver AI solutions.
• Help develop next-generation AI capabilities and scalable enterprise data foundations.
• Map data landscapes and apply data quality fundamentals for AI solutions.

Skills

Python

SQL

Time management

Communication skills

Problem solving

Education

Upcoming graduation between Dec 2027 and Aug 2028 in engineering

Tools

Databricks

Snowflake

BigQuery

AWS

Azure

GCP

Pandas

dbt

LangChain

Git

Job description

McKinsey & Company offers a 10-week Data Engineering internship for summer 2027 in Atlanta, Boston, Chicago, or New York City. You will build foundational data infrastructure for AI applications, collaborating with Data Scientists, ML Engineers, and cross-functional teams to deliver AI solutions.

You will learn to design scalable data pipelines, contribute to secure data environments, and prepare data for AI-driven systems while gaining exposure to agentic and generative AI.