McKinsey is seeking Data Analyst who can develop complex algorithms in SQL, based on discussions with client and Service Delivery team.
As a Data Analyst, 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. 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 and collaborating with the team to support ongoing business processes by delivering high-quality end products on time and performing quality checks wherever required.
Required Skills And Qualification:
Bachelor's degree; Master's degree is a plus
3+ years of professional work experience with a reputed analytics firm
Depicts strong knowledge and experience in handling a large amount of data through SQL, T-SQL or P-SQL in addition to experience in scripting languages such as Python, Perl or Shell
Understanding of data warehousing & data lake concepts with coding abilities in the field of data manipulation and ETL; alongside expertise in tools and technologies such as SQL, Alteryx and SSIS
Understanding and related experience in the integration of data from multiple data sources and automation of data processes.
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.