McKinsey & Company
New York, NY
Remote
2022-01-09
Intern - Data Engineering - University Students
4.3
Who You'll Work With
You will be based in our New York office for ~ 10 weeks over the summer as part of our technology team. You will conduct full life cycle analysis of data sets in consultation with senior colleagues including implementing data acquisition, cleansing, transformation and upload activities. You will work closely with data science, product management, product design and scrum master team members.
You will work across industries and functions on projects spanning from IT modernization and strategy to agile, cloud, cybersecurity and digital transformation to help our clients use digital technology to transform their businesses.
Our internship program gives a group of undergraduate and graduate students first-hand experience with product development at McKinsey. You will participate in an introductory training program as well as a range of social activities to get to know your office and the firm. You will fully immerse yourself with a team of developers, designers and agile coaches to transform our client’s technical processes, infrastructure and end-user applications. During your ~10 weeks, experienced consultants and engineers will provide guidance and coaching and give you a sense of McKinsey's people, values and spirit. At the end of the summer, you may receive an offer to join us full-time after completion of your degree.
What You'll Do
You will provide analysis, analytical modeling and/or visualization of data sets using relevant data tools.
In this role, you will identify possible trends and patterns in the data and communicate relevant findings that help support problem solving, insight generation and decision making. You will apply your understanding of client data sets and intended use to effectively capture, validate, cleanse, transform and upload data. You will perform quality checks to ensure consistency, integrity and robustness of data. You will proactively identify potential issues (e.g., inconsistencies) with data quality, collection or reporting. You will support the solution delivery team, often remotely, in managing client data.
You will leverage standard reporting to clearly articulate findings to solution delivery team or client team. You will be responsible for coding and scripting (SQL) for automating data transformation and loading specified by delivery team. You will perform impactful data enrichment based on understanding of the sector/industry and types of data that are available in the space.
Qualifications
- University student in their penultimate year in a computer science, engineering or equivalent program with expected graduation date of December 2022 or Spring 2023
- Experience on Big Data platforms and tools like AWS, Azure, GCP and tools like Spark, Kafka, Snowflake, GCS Data Proc, Azure Data Factory, AWS Glue, Apache Beam/Flink, Python/PySpark, etc.
- Ability to structure and analyze data in appropriate framework (e.g., Excel, Access, VBA, SQL)
- Passion for data tools and processes to drive business insights
- Strong analytical thinking, process management and quality control
- Ability to quickly understand and appreciate underlying business context, problems and objectives of analytical projects
- Clear communication skills to run well defined analyses and produce reports
- Excellent time management skills
- Good experience in multiple database technologies such as distributed processing (Spark, Hadoop, EMR), traditional RDBMS (MS SQL Server, Oracle, MySQL, PostgreSQL), MPP (AWS Redshift, Teradata), NoSQL (MongoDB, DynamoDB, Cassandra, Neo4J, Titan)
- Willing to travel up to 80%
COVID-19 vaccination mandate:
Employment with McKinsey & Company, Inc. in the United States and Canada is conditioned on proof of full vaccination against the COVID-19 virus (with a WHO-approved or Health Canada-approved COVID-19 vaccine, as applicable) or approval of an exemption due to a qualifying medical condition or sincerely held religious belief prior to start date.