Data Engineer - University Students

Key Skills

Apache Hadoop, Data Modeling, Data pipelines, HBase, Java Programming, Scala Programming, SQL

Job Description

WHO YOU'LL WORK WITH

You will join one of our offices in the North America. McKinsey Digital brings together the best of McKinsey’s digital, design, engineering, and analytics capabilities to help create positive, enduring change in the world. We work with our clients -- from executive leadership to client engineers and analysts -- to use technology to solve their most challenging problems and transform their businesses. Blending strategic thinking with hands-on practicality, our teams of consultants and experts work to develop and implement everything from complex analytics strategies and enterprise IT modernization, to agility, cloud, cybersecurity, and digital transformations.

Our teams are made up of analysts, mathematicians, data scientists, designers, software engineers, product managers, and strategy consultants who each bring unique knowledge and skillsets to our cross-functional teams. You’ll typically work on projects across all industries and functions and get the opportunity to work with colleagues and leaders across McKinsey & Company to help our clients deliver breakthrough products, experiences, and businesses using technology.

This posting is for university students who are currently enrolled to matriculate from an undergraduate or advanced degree program. If you are not currently a student, please consider our experienced professional role postings instead.

WHAT YOU'LL DO

As a McKinsey technologist, you will be an integral part of our cross-functional client teams, bringing a unique perspective and technical expertise to each project.

Data Engineer: You will be a hands-on technologist who connects and models complex distributed data sets to build repositories, such as data warehouses, data lakes, using appropriate technologies. You will work with our clients and other McKinsey experts, such as data scientists and architects to design and build cutting-edge (big) data solutions. You'll be a go-to expert for tackling data-related contexts ranging across addressing small to large data sets, structured/unstructured or streaming data, extraction, transformation, curation, modeling, building data pipelines, identifying right tools, writing SQL/Java/Scala code, etc.

QUALIFICATIONS

• Undergraduate or master’s degree candidate in a STEM-related field (e.g., computer science, etc.) 
• Expected graduation date between December 2023 - August 2024
• Strong analytical and problem-solving skills paired with the ability to develop creative and efficient solutions
• Ability to work collaboratively in a team environment and effectively with people at all levels in an organization
• Strong command of the English language (both verbal and written)
• Willingness to travel
• Ability to structure and analyze data in appropriate framework (e.g., Excel, Access, VBA, SQL)
• Exposure to Big Data platforms like Hadoop, hbase, CouchDB, hive, Pig etc.
• Experienced with data modeling, design patterns, building highly scalable and secured solutions
• Passion for data tools and processes to drive business insights
• Ability to quickly understand and appreciate underlying business context, problems and objectives of analytical projects