In this role, you will handle data by cleaning, validating, and summarizing it, primarily in Excel, using tools such as VLOOKUP, merging multiple data sources, and validating outputs with pivot tables and charts. You will upload data into our proprietary tools and convert marketing data into high-value analysis to drive insights and recommendations for our clients.
You will transfer numbers from proprietary tools to standardized presentations, perform sanity checks on the numbers, and ensure quality and accuracy. Additionally, you will automate analyses and recurring, standardized tasks using Excel formulas or Tableau workflows.
You will collaborate with solution leadership, product, and engineering teams to suggest solution improvements, conduct user acceptance testing, and provide feedback on new features. You will also train and support clients and client service teams (CSTs) on the effective use of the solution.
Lastly, you will work with the client delivery team on projects, discussing key insights, addressing questions about analytical recommendations, and supporting ongoing business processes by delivering high-quality end products on time.
This role offers a unique opportunity to combine McKinsey’s highly professional environment with the entrepreneurial spirit and dynamism of a start-up.