McKinsey & Company jobs - Junior Data Analyst Excel Alteryx

Apply Now

Qualifications

Bachelor’s degree in engineering

2 years of professional work experience with a reputed analytics firm

Strong expertise in MS-Excel and Macros

Knowledge and understanding of VBA, Alteryx, and Tableau.

A thoughtful and comfortable communicator (verbal and written) with the ability to facilitate discussions and conduct training

Track record of strong problem-solving, requirement gathering, and leading by example Ability to thrive in a flexible and collaborative environment

Track record of completing projects successfully on time, within budget, and as per scope

What You'll Do

As a Junior Data Analyst, you will work with the Sales Solutions group (within Periscope) to configure and deploy scalable analytics, diagnostic and software-based solutions to help companies achieve above-market growth by identifying, enabling, and sustaining best-practice commercial operations.

You will perform configuration and data analytics with Sales Solutions applications based on client requirements and specifications provided by the Solutions Delivery team.

You will be responsible for data extracts, transformation, and visualization to enable insights and analysis, and maintaining unique databases to drive industry-wide insights. This entails using data analytics tools (a combination of proprietary tools, Excel, Alteryx, and scripting),validating raw data quality, and working with Tableau and other geospatial data visualization applications.

You’ll work with a variety of clients as well as internal projects. The average project duration can vary from 1 week to 8 weeks. You may be serving multiple clients and/or teams at once working with a variety of roles, including solution delivery managers and specialists, consulting teams, and clients. Most of your work will happen in a remote setting, but with virtual, international teams.

You will also be expected to take ownership of improving analytical efficiency and automation of our existing assets, databases, and technical processes. You will be directly involved in database management and technology improvements needed to further scale our client support model.

This role will give you the opportunity to enjoy the combination of McKinsey’s highly professional environment and a start-up attitude of entrepreneurship and dynamics.