What You'll Do
You will transform how our stakeholders go about their daily work by automating much of their less sophisticated tasks and allowing them to focus on more value added activities.
In this role, through development of templates and best data engineering practices, you will help build reusable assets that can be leveraged by our team and other teams supporting the development and performance of the most senior leaders of McKinsey, its partnership.
You will expand and optimize the Partner Reporting Schema and data architecture in the firm's Data Warehouse in order to support Committee analysts and data scientists on data initiatives and automation. You will lead and contribute to efforts that modernize the collection and storage of Personnel Committee data. You will build data pipelines in coordination with other firm systems (data sources) to ensure Personnel Committee data can be integrated seamlessly with cross functional data. You will wrangle data to ensure that models used by the team are optimized and the products based on these data models can be automated - including cases where they need to be built from ground up. You will build and automate custom reports and business intelligence platforms that will enable Personnel Committee stakeholders to understand business context and help them derive meaningful insights.
Additionally, you will help the experts with migration of Partner Reporting Schema data from on-premise to the cloud in a thoughtful and strategic manner. You will also participate as a team member on People Function Initiatives to develop scalable, best in class technology solutions that will enrich our People data and analytical offerings at the firm.
Who You'll Work With
You will be based in one of our People Analytics offices as part of the global Partner Analytics team. This group provides vital insights across the Partner talent journey and related transitions including election and evaluation, retention, changes in professional tracks, departures, performance, and advancement. We support firm-wide Personnel Committees (responsible for election and evaluation of McKinsey partners) and high priority strategic projects that directly support our firm's people mission: to build a great firm that attracts, develops, excites, and retains exceptional people.
The team is a highly collaborative group of bright, generous, and driven colleagues with varied technical backgrounds who is focused on driving insight and action around key strategic people topics at McKinsey. We partner with many other teams within the firm, including People Analytics and Measurement (PAM), Finance, People Digital, Partner Personnel Committees, and Partner HR.
Qualifications

• University degree required
• 2+ years of experience in building and optimizing data pipelines, architectures and data sets and reporting
• Experience in performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Successful history of manipulating, processing and extracting value from large disconnected datasets
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL)
• Hands-on experience in Tableau is preferred; experience with Alteryx, R and Python encouraged
• Working knowledge of Snowflake is a plus
• Technologically curious and open to new ways of working; ability to describe data and analytic processes from start to finish in your area of expertise
• Ability to communicate effectively and work independently as a trusted member of project teams with diverse backgrounds and varying technical abilities