Monthly Archives

Write Course Reviews!
Rate and Share Courses!!
Spread Free Education!!!

Click here to visit IIMRA Main Site

Become Social, Stay Connected!

McKinsey Solutions – Periscope – Junior Data Analyst – Asia – Gurgaon



McKinsey Solutions is looking for talented and creative Junior Data Analysts with an understanding of business analytics, SQL, and Big Data to help analyze, design and develop ETL’s for our global clients. The analysts will be joining a team of passionate experts in our office in Gurgaon, India.
 Detailed Description
McKinsey & Company (McKinsey) is a global management consulting firm that advises the world’s leading businesses, governments and institutions. McKinsey has more than 100 offices in over 60 countries and serves eight out of the ten of Fortune magazine’s Most Admired Companies.

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
Desired Skills
  • 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
     To find out more information about the role and to apply, please click here

Facebook Comments / Reviews


0 Comments / Reviews

Contact form submitted!
We will be in touch soon.