Mckinsey is looking well experienced and skilled Manager-Data Engineering at Gurugram location who will be responsible to 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.
In this role, you will work in close collaboration with the service management team and depend on the context of your engagement, you will work locally with the client service team and/or the client. As a Manager, your key responsibilities will include leading 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 Manager, 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.
Bachelor's degree; Master's degree in computer science or information technology is a plus.
11+ 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-SQL.
Strong knowledge and experience in scripting languages such as Python, Perl or Shell.
Strong coding/development abilities in the field of data manipulation and ETL.
Experience with integration of data from multiple data sources and automation of data processes.
Experience overseeing the data stream of multiple projects including client deployment, integration & migration.
Strong understanding of data-warehousing and data lake concepts.
Experience working in Big Data and cloud architecture including Amazon Web Services is good to have.
McKinsey & Company is a global management consulting firm. We are the trusted advisor to the world's leading businesses, governments, and institutions.
We work with leading organizations across the private, public and social sectors. Our scale, scope, and knowledge allow us to address problems that no one else can. We have deep functional and industry expertise as well as breadth of geographical reach. We are passionate about taking on immense challenges that matter to our clients and, often, to the world.
We work with our clients as we do with our colleagues. We build their capabilities and leadership skills at every level and every opportunity. We do this to help build internal support, get to real issues, and reach practical recommendations. We bring out the capabilities of clients to fully participate in the process and lead the ongoing work.