Junior Data Analyst - Periscope, McKinsey Solutions

  • Budapest
  • Wroclaw


  • 1-2 years of strong experience in the field of business intelligence and ETL (Alteryx, SSIS, Talend, Pentaho, etc…)
  • Bachelor’s degree/Master's Degree/Diploma in IT with high rankings and from top/reputed colleges
  • Strong Coding/development abilities (SQL, etc.)
  • Excellent time management skills
  • Good communication skills in English (communication skills in other languages is advantageous)
  • Strong interpersonal skills
  • Be able to cope with pressure and demonstrate a reasonable level of flexibility/adaptability
  • Ability to act autonomously, bringing structure and organization to work
  • Sound problem-solving skills
  • Understanding of basic financial and business terminology
  • Creative and action-oriented mindset
  • Ability to travel abroad for working sessions and meetings with Service Management team

Who You'll Work With

You’ll work with our Periscope team in Budapest, Hungary or Wroclaw, Poland.  Periscope is part of McKinsey Solutions and McKinsey’s New Ventures.  

Periscope leverages decades of McKinsey’s marketing and sales experience helping leading companies improve pricing, promotion, assortments, and performance management.  Periscope’s combination of software, tailored services, and expertise provides our clients with a granular view of their commercial and financial performance by gathering and integrating their landscape of data and information into a central data warehouse.  Clients can use our intuitive interface to make decisions based on advanced analytics and can embed new pricing, commercial, and performance management capabilities throughout their organization.

New Ventures is a recently formed part of McKinsey focused on fostering innovations driven by analytics, design thinking, mobile, social and other technologies and integrating them into our client work. It is a foundation for—and expands our investment in—our entrepreneurial culture.

As one of the fastest-growing parts of our firm, New Ventures has more than 1,000 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. 

McKinsey Solutions is a core part of New Ventures and offers practical tools that help people at all levels of an organization generate insights they need to address both strategic and day-to-day decisions. These solutions complement McKinsey's traditional client service and are delivered in many ways, including subscriptions, workshops, training programs and project-based engagements. We work closely with clients to embed our tools, analytics and expertise, and provide on-going support to help them build the capabilities they need to revolutionize how decisions are made.


What You'll Do

As a Junior Data Analyst, you will work within the Data Services team to perform data transformation, modeling and validation activities, as well as to configure applications to client context. Analysts work remotely, but in close collaboration, with the Service Management team. Depending on their seniority and the engagement context, Analysts might have to work locally with the Client Service Team and/or the client. Analysts also participate in the continuous development and improvement of configuration tools, processes and talents.


The key activities of the Junior Data Analyst include:

Validating raw data quality and transforming the data using SQL and/or MS Excel

Loading the transformed data to SQL server using manual uploads and/or SSIS

Performing quality checks on the data, and suggesting improvements to improve data quality

Developing complex algorithms in SQL based on discussions with clients and the service delivery team

Coding and scripting (SQL) for automating data transformation and loading specified by Service Management team

Apply Now

Similar Jobs

Job Skill Group - CSSS - Early CSS track
Job Skill Code - Junior Data Analyst
Function - Marketing & Sales;Technology
Industry - Consumer Packaged Goods;Financial Services;Retail
Post to LinkedIn - Yes
Posted to LinkedIn Date - Wed Jul 27 20:00:00 GMT 2016
LinkedIn Posting City - Budapest
LinkedIn Posting State/Province -
LinkedIn Posting Country - Hungary
LinkedIn Job Title - Junior Data Analyst - Periscope, McKinsey Solutions
LinkedIn Function - Analyst;Information Technology;Project Management
LinkedIn Industry - Computer Software;Information Services;Management Consulting