Job Description
QUALIFICATIONSUndergraduate degree in computer science, engineering, mathematics, information systems or related field3+ years of relevant professional work experience in a data engineering function with an analytics firm Excellent written and verbal communication skillsSolid problem-solving capabilities, including the ability to disaggregate issues, identify root causes and recommend solutionsExperience with building interactive visualization and BI platforms (Power BI/Tableau/ Qlikview or similar), data modeling and measure calculation, e.g. using DAX, data transformation with DBT, version control with Git, cloud data warehouses such as SnowflakeStrong abilities in the field of large data handling through one or multiple of the following: Microsoft SQL (T-SQL), Microsoft SQL Server, Management Studio, PythonExperience in the field of procurement and/ or business intelligence is a plusStrong interpersonal, written/verbal communications skills in EnglishWHO YOU'LL WORK WITHSpendscape is McKinsey’s service line that brings technology and services to our clients to drive spend transparency, spend and cost analytics, and value-capture management. We are part of McKinsey’s global Client Capability Network (CCN), which includes more than 1,800 knowledge professionals who work alongside our consultants and clients to generate distinctive insights and proprietary knowledge.You’ll be working with our global Spendscape team of software, analytics and procurement experts. You will be joining a fast-growing team in the procurement arena and taking cutting edge technology solutions to clients. Spendscape infuses best-in-class technology and AI-based analytics with deep supply-market and category-sourcing expertise. You’ll be part of a team that is a core element of the digitally enabled procurement function of the future. This will involve all business value chain activities from product development to distribution and playing a strategic role in managing budgets and costs, anticipating and mitigating supply risk, driving compliance, and generating transparency to external spend in an organization.WHAT YOU'LL DOYou will support, deliver and implement Spendscape solutions together with our strong delivery teams and in close collaboration with our clients. As a Data Analyst you will manage the data cleaning pipeline, apply analytic methodologies and data visualization techniques, set up BI dashboards and create new analysis, generate insights and communicate them back to the team. Together with consulting teams, project managers and clients you will understand client and project requirements and discuss how to best implement new or customized analytics. Utilizing BI (e.g. Power BI) or other visualization tools, you will support the creation of analysis, KPIs and dashboards. Another important part of your work will be the continuous development and improvement of our data models and reports to analyze procurement data. Here you will work closely with our Software Development and Data Science teams to create scalable solutions that can be brought to 100s of clients per year.
