Data Analyst – Spendscape

McKinsey & Company logo

McKinsey & Company

View Salaries, Reviews, and more  

Job Summary


Job Type
-

Seniority

Years of Experience
Information not provided

Tech Stacks
Python SQL Git Microsoft T SQL DAX Microsoft SQL Server Analytics QlikView Snowflake

Job Description

Who You'll Work With

Spendscape is McKinsey’s service line that brings technology and services to our clients to drive spend transparency, spend and cost analytics, and value-capture management. We are part of McKinsey’s global Client Capability Network (CCN), which includes more than 1,800 knowledge professionals who work alongside our consultants and clients to generate distinctive insights and proprietary knowledge.

You’ll be working with our global Spendscape team of software, analytics and procurement experts. You will be joining a fast-growing team in the procurement arena and taking cutting edge technology solutions to clients.

Spendscape infuses best-in-class technology and AI-based analytics with deep supply-market and category-sourcing expertise. You’ll be part of a team that is a core element of the digitally enabled procurement function of the future. This will involve all business value chain activities from product development to distribution and playing a strategic role in managing budgets and costs, anticipating and mitigating supply risk, driving compliance, and generating transparency to external spend in an organization.

What You'll Do

You will support, deliver and implement Spendscape solutions together with our strong delivery teams and in close collaboration with our clients.

As a Data Analyst you will manage the data cleaning pipeline, apply analytic methodologies and data visualization techniques, set up BI dashboards and create new analysis, generate insights and communicate them back to the team. Together with consulting teams, project managers and clients you will understand client and project requirements and discuss how to best implement new or customized analytics. Utilizing BI (e.g. Power BI) or other visualization tools, you will support the creation of analysis, KPIs and dashboards.

Another important part of your work will be the continuous development and improvement of our data models and reports to analyze procurement data. Here you will work closely with our Software Development and Data Science teams to create scalable solutions that can be brought to 100s of clients per year.

Qualifications

  • Undergraduate degree in computer science, engineering, mathematics, information systems or related field
  • 3+ years of relevant professional work experience in a data engineering function with an analytics firm
  • Excellent written and verbal communication skills
  • Solid problem-solving capabilities, including the ability to disaggregate issues, identify root causes and recommend solutions
  • Experience with building interactive visualization and BI platforms (Power BI/Tableau/ Qlikview or similar), data modeling and measure calculation, e.g. using DAX, data transformation with DBT, version control with Git, cloud data warehouses such as Snowflake
  • Strong abilities in the field of large data handling through one or multiple of the following Microsoft SQL (T-SQL), Microsoft SQL Server, Management Studio, Python
  • Experience in the field of procurement and/ or business intelligence is a plus
  • Strong interpersonal, written/verbal communications skills in English

Interview Questions of Data Analyst – Spendscape at McKinsey & Company

Interview questions from McKinsey & Company that are similar to Data Analyst – Spendscape
View more interview questions from McKinsey & Company →
banner icon
Prepare For Your Interview in 1 Week?
Equip yourself with possible questions that interviewers might ask you, based on your work experience and job description.
Get Started!

Salary Insights of Data Analyst – Spendscape at McKinsey & Company

Currently, there aren't any salaries for this role at McKinsey & Company shared by other job seekers.

View more salaries from McKinsey & Company →

Achieve your dream job with our top-notch tools!

Resume Checker Illustration

Resume Checker

Our free resume checker analyzes the job description and identifies important keywords and skills missing from your resume in just a minute!

Check Now
Interview Preparation Illustration

AI InterviewPrep

Utilizing advanced AI, our tool generates tailored interview questions based on your industry, role, and experience. Practice and receive feedback on your answers in real time!

Check Now
Resume Builder Illustration

Resume Builder

Let us show you the differences between a bad, good, and great resume, and guide you in building a resume that helps you stand out to employers, ensuring you land your next position faster!

Check Now