Beschreibung
Freelance Data Engineer (Python, SQL, ETL)Location: Remote
Industry: Transport
Language: German
Projektbeschreibung
Development and implementation of a data model for a dashboard to record and map the qualitative service provision
Preparation and calculation as well as the economic effects of this in the data analysis tool Qlik Sense
Development of a data model for the billing of the transport services provided
Data preparation for the ERP system
Visualization of the calculated results incl. setup of a reporting system
#Leistungsbeschreibung
• Implementation of requirements for the required data and the resulting data preparation in the data lake
• Management of requirements in close coordination with the client
• Conceptual development of a data model
• Connection of data and implementation in an automated charging route
• Implementation of monitoring functions of automated loading processes
• Determination and processing of additional data required from internal IT applications, procedures and tools for the representation of the values defined in driver key figures.
• Identification of data quality deviations and development of cleansing processes
• Documentation of the developed architectural elements and processes
• Versioning and documentation of the developing scripts
•
#Muss requirements*:
• At least 5 years of experience with SQL and dynamic PL/SQL, preferably Oracle
• At least 3 years of experience with one of the common data visualization and/or reporting tools Qlik or Tableau with certification
• At least 3 years of experience in the construction of ETL lines
• At least 3 years of programming experience in python
• Experience of at least 2 years with code management in a Git-based application
• Very good knowledge of at least 2 years in the cloud environment, preferably AWS