- 1-2 years of strong experience in the field of business intelligence and ETL
- Bachelor's degree/Master's Degree/Diploma in IT with high rankings and from top/reputed colleges
- Strong coding/development abilities (SQL, etc.)
- 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
- Ability to travel abroad for working sessions and meetings with Service Delivery team
Who You'll Work With
You'll work with our Periscope team in Budapest, Hungary or Wroclaw, Poland. Periscope is part of McKinsey Solutions and McKinsey's New Ventures.
Periscope leverages decades of McKinsey's marketing and sales experience helping leading companies improve pricing, promotion, assortments, and performance management. Periscope's combination of software, tailored services, and expertise provides our clients with a granular view of their commercial and financial performance by gathering and integrating their landscape of data and information into a central data warehouse. Clients can use our intuitive interface to make decisions based on advanced analytics and can embed new pricing, commercial, and performance management capabilities throughout their organization.
New Ventures is a recently formed part of McKinsey focused on fostering innovations driven by analytics, design thinking, mobile, social and other technologies and integrating them into our client work. It is a foundation for—and expands our investment in—our entrepreneurial culture.
As one of the fastest-growing parts of our firm, New Ventures has more than 1,000 dedicated professionals (including more than 800 analysts and data scientists) and we're hiring more mathematicians, data scientists, designers, software engineers, product managers, client development managers and general managers.
What You'll Do
You will work within the Service Delivery team to perform data transformation, modeling and validation activities, as well as to configure applications to client context.
You'll work in close collaboration with the Service Management team, and depending on your seniority and the engagement context, you might work remotely or locally with the McKinsey Consulting Team and/or the client. You'll also participate in the continuous development and improvement of configuration tools, processes and talents.
You will validate raw data quality and transform the data, load the transformed data to an application using manual or automated data uploads, perform quality checks, and suggest improvements to improve data quality. Additionally, you'll be responsible for developing complex algorithms and visualizations based on discussions with clients and the service delivery team and coding and scripting for automating data transformation and loading.
Data Analysts work on various projects, such as pricing, promotion, assortment advisory, etc. Our aim is to always use the right tool for the right task, therefore there is also large variety in the tools you might be using, like Excel, Visual Basic, Alteryx, SQL, R, Tableau.
There is flexibility to hire at either the Junior Data Analyst or Data Analyst level depending on the qualifications of the candidate.
Meet Some of McKinsey's Employees
Danielle is one of the leaders of McKinsey’s business with retail and consumer clients. She oversees client projects and helps her teams and her clients utilize McKinsey’s resources.
Back to top