Data Engineer - Orpheus

Company:
Location: München

*** Mention DataYoshi when applying ***

QUALIFICATIONS

  • Bachelor's degree in computer science, engineering, mathematics, information systems or related fields
  • 3 years of relevant professional experience in a data engineering function or with a reputed analytics firm; experience in the field of procurement and/or business intelligence is a plus
  • Strong coding knowledge in SQL, medium in T-SQL and Python
  • Understanding of data warehousing and data lake concepts; experience in building operational ETL data pipelines across a number of sources, and constructing relational and dimensional data models
  • Abilities in the field of large data handling through one or multiple of the following is a plus: Snaplogic, Talend, Alteryx
  • Experience with Microsoft SQL Server is a plus
  • Basic Java development skills, PowerShell or other scripting experience is a plus
  • Basic knowledge of version control systems (Git) is a plus
  • Solid problem-solving capabilities, including the ability to disaggregate issues, identify root causes and recommend solutions
  • Strong interpersonal, written and verbal communications skills in English
  • Willingness to travel (~20% of time)

WHO YOU'LL WORK WITH

You will be based in our Munich or Nuremberg office as part of Orpheus.

You’ll be working with our global Orpheus 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. You will collaborate with consulting teams, project managers and clients to understand client and project requirements and discuss how to best implement new or customized analytics. You will also work closely with our software development and data science teams to create scalable solutions that can be brought to hundreds of clients per year.

Orpheus, a McKinsey company, 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.

Orpheus 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 DO

You will deliver and implement Orpheus solutions together with our strong delivery teams and in close collaboration with our McKinsey consulting teams, as well as directly with clients.

In this role, your typical project involves project scoping, data identification and extraction, data processing, engineering and enrichment, data cleansing and categorization, spend analysis and opportunity identification, handover, insights presentation and capability building.

You will support the data processing, engineering and enrichment phase. Leveraging proprietary and third-party ETL and data-transformation tools or scripts (e.g. Snaplogic, Talend, Alteryx, SQL, Python), you will merge various internal and external data tables and sources, perform data quality checks and build up complex data models that build the basis for further data cleaning and analytics.

You will also help in the continuous development and improvement of our proprietary data extractor and ETL tools.

*** Mention DataYoshi when applying ***

Offers you may like...

  • Project A Ventures

    Data Engineer/Data Scientist (m/w/d)
    10115 Berlin
  • Auchan Retail France

    Data Engineer / Machine Learning Engineer - SQL / ...
    59491 Villeneuve-d'Ascq
  • CollabraLink Technologies

    Data Engineer - Mid Level
    Remote
  • Jobvite

    Data Engineer
    Remote
  • AdamsGabbert

    Data Engineer
    Kansas City, MO 64106