Junior Data Analyst- Cyber Solutions


  • Bachelor's degree; Master's Degree is a plus
  • 1 - 2 years experience in the field of cybersecurity
  • Basic knowledge of analytic (Excel, Alteryx) and presentation (PowerPoint) tools
  • Excellent time management skills and sound problem-solving skills
  • Good communication skills in English; Skills in other languages is advantageous
  • Strong interpersonal skills
  • Ability to cope with pressure and demonstrate a reasonable level of flexibility/adaptability
  • Ability to act autonomously, bringing structure and organization to work
  • Understanding of basic financial and business terminology
  • Creative and action-oriented mindset
  • Ability to travel abroad for working sessions

Who You'll Work With

You'll work with our Cyber Solutions team and will be based in either Waltham, Massachusetts or Wroclaw, Poland. Members of this team also sit in New York, Washington, D.C., Chicago, Silicon Valley and Dallas. Cyber Solutions is part of McKinsey Solutions and McKinsey's New Ventures.

Cyber Solutions helps leading companies improve digital resilience, identification and prioritization of key information assets, prepare for cyber breaches, and make informed build vs. buy' decisions when it comes to building cyber capabilities. Cyber Solutions' combination of software, tailored services, and expertise provides our clients with a granular view of their cyber and information risk and breach preparedness. Clients leverage our solutions to work with business leaders to have a material impact on their institutions' cybersecurity.

McKinsey New Ventures fosters innovation driven by analytics, design thinking, mobile and social by developing new products/services and integrating them into our client work. It is helping to shift our model toward asset-based consulting and is a foundation for –and expands our investment in –our entrepreneurial culture. Through innovative software as a service solutions, strategic acquisitions, and a vibrant ecosystem of alliances, we are redefining what it means to work with McKinsey.

As one of the fastest-growing parts of our firm, New Ventures has more than 1,500 dedicated professionals (including more than 800 analysts and data scientists) and we're hiring more mathematicians, data scientists, designers, software engineers, product managers, client development managers and general managers.

What You'll Do

You will perform data transformation, modeling and validation activities for our core solutions including Digital Risk Assessment, Cyber Risk Insights, Executive Cyber Solutions, and the Cyber Market Map.

You will also work with delivery, client and internal McKinsey teams to get our solutions approved for use within the client environment. You'll validate raw data quality and transform the data using Excel and/or Alteryx. You'll then load the transformed data to Excel using manual uploads, perform quality checks on the data and suggest improvements to improve overall data quality. You'll develop algorithms in Excel based on discussions with Delivery and Product Development teams to analyze data and generate actionable results. In addition, you'll drive completion of client-required security approval questionnaires for Digital Risk Assessment, Cyber Risk Insights, Executive Cyber Solutions, and the Cyber Market Map.

Meet Some of McKinsey's Employees

Danielle B.


Danielle is one of the leaders of McKinsey’s business with retail and consumer clients. She oversees client projects and helps her teams and her clients utilize McKinsey’s resources.

Fope F.

Senior Associate

Fope helps lead a small team that works for McKinsey clients, helping them address business challenges and strategic questions. Though based in the NYC office, she travels frequently so she can be in-person with her clients.

Back to top