Designation – Periscope Data Analyst
Location – Gurgaon
About employer– McKinsey Solutions
Job description:
Responsibilities
- 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
- Working on multiple projects, and delegating work to Junior Analysts to deliver projects on time
- Training and mentoring Junior Analysts and building their proficiency in the ETL process
- Coding and scripting (SQL) for automating data transformation and loading specified by Service Management team
Qualification and Skills Required
- 3-5 years of experience in the field of business intelligence, IT development, ETL (Alteryx, Talend, Pentaho, etc.), and/or Advance analytics (Tableau, R, SaS)
- Bachelor’s degree/Master’s Degree/Diploma in IT
- Coding/development abilities (SQL, Microsoft, etc.)
- Basic knowledge about data mining, machine learning and statistics is an additional asset
- Background in sectors such as consumer products or banking is advantageous
- Excellent time management skills
- Good communication skills in English; communication skills in other languages is advantageous
- Strong interpersonal skills
- 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 (typically on the same continent as their home office)
Interested people can apply for this job can mail their CV to [email protected] with subject as Periscope Data Analyst – McKinsey Solutions – Gurgaon
