Data Engineer Lazio

Data Engineer
Roma
Lazio, Lazio

Luogo di lavoro:

LisbonAt McKinsey & Company (Permanent), in Lisbon, PortugalExpires at:

2021-11-30 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.

A typical project involves the following steps:

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. As a Data Engineer, you will support the data processing, engineering, and enrichment phases.

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.

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.

Another important part of your work is the continuous development and improvement of our proprietary data extractor and ETL tools.

Here you willwork closely with our Software Development and Data Science teams to create scalable solutions that can be brought to 100s of clients per year.

Main requirementsUndergraduate degree in Computer Science, Engineering, Mathematics, Information Systems or related fieldUp to 8 years of relevant professional work experience in a data engineering function or with a reputed analytics firm Strong coding knowledge in SQL, medium in T-SQL, and Python is requiredUnderstanding 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 is requiredAbilities in the field of large data handling through one or multiple of the following:

Snaplogic, Talend, Alteryx is a plusExperience with Microsoft SQL Server is a plusBasic Java development skills, PowerShell, or other scripting experience is a plusBasic knowledge of version control systems (Git) is a plusExperience in the field of procurement and/ or business intelligence is a plusSolid problem-solving capabilities, including the ability to disaggregate issues, identify root causes, and recommend solutionsStrong interpersonal, written/verbal communications skills in EnglishWillingness to travel (~20% of time)