Data Specialist - Periscope | McKinsey Global Services

Job Title:
Data Specialist - Periscope

Company Name:
McKinsey Global Services

Job Location:
Bangalore

Qualifications:
Bachelor’s degree; Master's degree in computer science or information technology is a plus8+ years of relevant and professional work experience with a reputed analytics firm
Expertise in handling large amounts of data through SQL, T-SQL or PL-SQLStrong knowledge and experience in scripting languages such as Python, Perl or ShellStrong coding/development abilities in the field of data manipulation and ETLExperience with integration of data from multiple data sources and automation of data processesExperience overseeing the data stream of multiple projects including client deployment, integration & migrationStrong understanding of data-warehousing and data lake conceptsExperience working in cloud architecture including Amazon Web Services (AWS) is good to have


WHO YOU'LL WORK WITH
You’ll work in our Gurgaon office and will be a part of our Periscope team. In this role, you'll work with the Data Services team, primarily supporting the Insights & Analytics (IA) group of Periscope.

WHAT YOU'LL DO
You will work with the data services team to perform data transformations, modeling and validation activities, as well configure applications to client context.

In this role you will lead a team of data engineers to determine database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients and evaluating current systems. 

As a Specialist, you will develop complex algorithms in SQL, based on discussions with client and Service Delivery team, develop scripts to validate, transform and load raw data using programming languages such as Python, Perl or Shell. You will conduct data assessment, perform data quality checks and transform data using SQL and ETL tools.

You will also design and drive the work plan for the optimization/automation and standardization of the processes incorporating best practices to achieve efficiency gains. 

Given the pace of this role, you will develop cross-site relationships to enhance idea generation, manage stakeholders/ partner expectations, coach and mentor new hires by sharing expertise and collaborating with the team to support ongoing business processes by delivering high-quality end products on time and performing quality checks wherever required.

For More Jobs Visit: https://www.mckinsey.com/careers/search-jobs