Data Analyst-SQL,SSIS  McKinsey Solutions is looking for talented and creative 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.  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.  McKinsey Solutions is a new group within McKinsey that leverages 85 years of McKinsey industry and functional expertise with data, proprietary analytics, and software tools. The group offers a new suite of services with the goal of helping organizations gain greater clarity in decision making, and achieve significant long-term performance improvement. The solutions are complementary to McKinsey's management consulting services and offer a variety of support models to ensure clients get exactly what they need. The team works closely with client organizations to embed the tools and build their capabilities to sustain impact over time.  McKinsey Solutions is a fast-growing office. It has developed and deployed over 15 solutions to more than 400 companies over the last 7 years. The dynamic team has doubled its size every year, and now comprises more than 500 full-time professionals. McKinsey Solutions is dedicated to creating an outstanding organization with innovation and smart client service practices at the heart of all operations. To help us achieve this, we need talented and ambitious people who inspire and deliver change.  Established in 2007, Periscope is a Solution that leverages decades of McKinsey's experience in marketing and sales helping leading global companies improve pricing, promotion, assortments, and performance management. It offers a comprehensive suite of insight-driven commercial performance solutions.   Periscope enables clients to make better and faster decisions based on advanced analytics and a granular view of their commercial and financial performance and by embedding new pricing, commercial, and performance management capabilities throughout their organization. With more than ten thousand end users, - 20 terabytes of Fortune 100 company data, 100+ offices around the world, and more than 600 consultants, Periscope provides clients with a unique combination of software, tailored services, and expertise.   Periscope builds on McKinsey's codified best practices including 40 years of proprietary benchmarked data and substantial investments in developing cutting-edge knowledge, resulting in breakthroughs that consistently drive growth for clients. Visit http://periscope.mckinseysolutions.com to learn more.  Responsibilities :  - As a 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 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  - 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  Desired Skills :  - 4 to 6 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)

Delhi NCR

McKinsey Solutions - Data Analyst - SQL/SSIS 

McKinsey Solutions - Data Analyst - SQL/SSIS  ,Job Description for McKinsey Solutions - Data Analyst - SQL/SSIS  in Mckinsey in  Delhi NCR for (4-7) years of experience. Apply Now!

Job Description for McKinsey Solutions - Data Analyst - SQL/SSIS  in Mckinsey in  Delhi NCR for (4-7) years of experience. Apply Now!