Job Directory McKinsey Data Engineer - University Students
McKinsey

Data Engineer - University Students McKinsey
New York City, NY

McKinsey and Company is a management consulting firm serving commercial, government, and not-for-profit organizations.

Companies like McKinsey
are looking for tech talent like you.

On Hired, employers apply to you with up-front salaries.
Sign up to start matching for free.

About McKinsey

Job Description

Qualifications

* University student in their final year in a Computer Science, Engineering or equivalent program; expected graduation date of December 2018 or May 2019
* Or, currently completing your first year in a non-business, 2-year masters program and have less than 2 years of work experience
* 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)
* 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

Who You'll Work With

You'll work with a technology team in one of our North American offices to conduct full life cycle analysis of data sets, 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. Data Engineers are staffed on engagements or product teams and are expected to leverage expertise to solve some of the most pressing and complex issues at clients.

Please review the team options and locations below to clarify your application preferences.

McKinsey Analytics (Geospatial - Waltham; Healthcare Analytics & Delivery- New York, Waltham; Ingenuity- New York, Waltham; Pharma and Medical Products- New York; Public and Social Sector- New York, Waltham, Washington DC). You will apply an analytical, entrepreneurial mindset to foster innovation driven by analytics, design thinking, mobile and social by developing new products/services and integrating them into our client work

Digital McKinsey- (New York City) You will work across industries and functions on projects spanning from IT modernization and strategy to agile, cloud, cybersecurity, and digital transformation

What You'll Do

You will provide analysis, analytical modeling, and/or visualization of data sets using relevant data tools.

In this role you'll identify possible trends and patterns in the data, and communicate relevant findings that help support problem solving, insight generation and decision making. You'll apply your understanding of client data sets and intended use to effectively capture, validate, cleanse, transform and upload data. You'll perform quality checks to ensure consistency, integrity and robustness of data. You'll proactively identify potential issues (e.g., inconsistencies) with data quality, collection or reporting. You'll support solution delivery team, often remotely, in managing client data.

You'll 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.

McKinsey & Company is an equal opportunity employer.

About McKinsey

McKinsey and Company is a management consulting firm serving commercial, government, and not-for-profit organizations.

Size
31364 employees
McKinsey

711 3rd Ave 4th Floor

Let your dream job find you.

Sign up to start matching with top companies. It’s fast and free.