col-wideJob Description:
You will be part of the People Analytics and Measurement team (P.A.M).
This group designs and executes projects supporting McKinsey's people mission: to build a great firm that attracts, develops, excites, and retains exceptional people. The team is a collection of over twenty analysts and data scientists - bright, driven colleagues with varied backgrounds focused on driving insight and action around key strategic people issues at McKinsey. We work in a highly collaborative environment, and partners with other teams within the firm to deliver meaningful innovation when it comes to McKinsey's firm member journey's - and the analytics behind them.
The Business Intelligence group is specifically responsible for all reporting, performance metrics, and descriptive analytics enabling the firm to understand and optimize our people operations and measure the impact of our strategic initiatives.
You will work closely with data analysts, data scientists, and data engineers to extract, clean, and analyze our firm's people data, with a focus on a wide range of people data for a range of projects.
You will develop fluency in our people systems and combine this with your analytical knowledge to help translate rigorous analysis into business solutions. You will be heavily involved in the transition from Excel based and other database delivery of BI Analytics to self-serve platforms. You will communicate the results of the analysis to the team's internal clients, helping them understand the results and suggesting potential actions supported by the results.
You will serve a variety of internal firm clients across the people space, serving up tools that offer solutions to a wide range of colleagues both in scope and seniority.
1+ years of relevant professional experience in analytics performing exploratory data analysis to understand the characteristics of a data set and identify patterns
Bachelor's or advanced professional degree with a focus in data analytics, mathematics, computer science, statistics, econometrics, or social science-organizational-operations research
Ability to intuit, understand and communicate the meaning of data analyses with individuals in a wide range of strategic and operational roles, in both written and oral form
Familiarity with software development methodologies like Agile, including issue/workflow tracking tools like Jira and Trello and version control tools like git and GitHub
Proficiency in SQL, including experience retrieving data from relational databases
Depth of experience with advanced analytical tools such as R (preferred, in combination with Shiny), Python (in combination with Streamlit), in addition to other advanced analytics packages
