Data Consultant & Engineer | Python / Cloud / AWS / CGP / Data Warehousing / DBT / Data Vault / ETL&ELT / Dashboard / Data driven CRM
Aktualisiert am 11.03.2024
Profil
Freiberufler / Selbstständiger
Remote-Arbeit
Verfügbar ab: 01.04.2024
Verfügbar zu: 75%
davon vor Ort: 0%
Datenarchitektur
Big Data
Datawarehouse
Datenanalyse
Business Intelligence
Cloud
Python
SQL
AWS
Git
Container
Deutsch
Muttersprache
English
Verhandlungssicher

Einsatzorte

Einsatzorte

Hamburg (+10km)
Deutschland
möglich

Projekte

Projekte

7 Monate
2023-08 - 2024-02

Contributed to a system architecture concept

Data Engineer
Data Engineer
  • Contributed to a system architecture concept optimizing last mile logistics operations
  • Spearheaded the design and execution of a cutting-edge MVP Cloud Data Platform, leveraging GCP, empowering data-driven analytics and operational efficiency
  • Pioneered the implementation of an MVP Data Vault Model for last mile logistics utilizing DBT and datavault4dbt by ScalefreeCOM, modernizing data management strategies
  • Revamped outdated file-based reports into an impactful MVP Dashboard using Tableau, providing intuitive and actionable insights for improved decision-making
  • Played a pivotal role in providing expert guidance and consultation on data and system strategies in an internal company-wide digitization and modernization initiative, driving technological advancements and efficiency enhancements
FUNKE Logistik
Hamburg, Germany
10 Monate
2022-10 - 2023-07

Developed and maintained new and existing data pipelines

Data & Analytics Senior 
Data & Analytics Senior 
  • Developed and maintained new and existing data pipelines using Python and Transact SQL
  • Designed and implemented an automated OCR pipeline using AWS products (S3, SQS, Textract, and Lambda)
  • Collaborated and engineered multiple self-service dashboards for daily reporting and ad hoc business analytics using Databricks, Transact SQL, Python, and Tableau
  • Evaluated and coordinated various ad hoc analytics requests by clients with an existing nationwide data warehouse using Databricks, Redshift, and Python
  • Independently analyzed existing infrastructure and designed a new cloud-based data architecture concept to improve flexibility and uptime for clients
  • Collaborated on a real-time customer data platform via consulting and validation of data streams into Braze using Kafka and mParticle
  • Onboarded new co-workers and evaluated, planned, and oversaw large team projects


Highlighted Projects

  • Modernization and cloud migration of the inhouse data platform
    • Refactored an existing on-premise data platform and migrated it to the cloud
    • Streamlined data pipelines and reduced coding overhead by using standard formats and low-code tools
    • Improved data availability for in-house staff and clients and scaling options
  • CRM Communication Reporting for the German market of a global food chain
    • Analyzed and remodeled existing communication reporting based on business needs
    • Refactored the existing ETL process based on old and new requirements for up to 15 million events a day
    • Collaborated and coordinated the creation process of new self-service dashboards using Tableau
  • Business Insights Reporting for the German market of a global food chain
    • Automated ELT and business logic with over 50 KPIs
    • Engineered MSSQL procedures to store and monitor weekly data loads
    • Designed and assembled a compact Tableau dashboard to visualize target performance and progress
TRACK GmbH
Hamburg, Germany 
1 Jahr 1 Monat
2021-09 - 2022-09

Developed and maintained new and existing data pipelines

Data & Analytics Specialist
Data & Analytics Specialist
  • Developed and maintained new and existing data pipelines in our existing on-remise data warehouse and Tableau using Python and SQL
  • Maintained Tableau dashboards and executed ad hoc analytics and processing requests
TRACK GmbH
Hamburg, Germany
1 Jahr 1 Monat
2020-09 - 2021-09

Executed various ad hoc analytics and processing requests

Data & Analytics Junior
Data & Analytics Junior
  • Executed various ad hoc analytics and processing requests and developed new ETL pipelines for clients
TRACK GmbH
Hamburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

1 Monat
2020-03 - 2020-03

Game Art Animation, Upper Second

B.Sc. (Hons), SAE Institute Hamburg, Germany
B.Sc. (Hons)
SAE Institute Hamburg, Germany
 
1 Monat
2018-03 - 2018-03

Diplom 3D Art & Animation

1,95, SAE Institute Hamburg, Germany
1,95
SAE Institute Hamburg, Germany

Position

Position

  • Data Engineer | FUNKE Logistik | Hamburg, Germany| Aug 2023 - Feb 2024
  • Data & Analytics Senior | TRACK GmbH | Hamburg, Germany | Oct 2022 - July 2023
  • Data & Analytics Specialist | TRACK GmbH | Hamburg, Germany | Sept 2021 - Sept 2022
  • Data & Analytics Junior | TRACK GmbH | Hamburg, Germany | Sept 2020 - Sept 2021

Kompetenzen

Kompetenzen

Top-Skills

Datenarchitektur Big Data Datawarehouse Datenanalyse Business Intelligence Cloud Python SQL AWS Git Container

Produkte / Standards / Erfahrungen / Methoden

Profile:

Based in Hamburg, Germany, I am a Data Engineer with extensive experience in Data Platform Architecture, DevOps, and Data Modeling for CRM Marketing and Logistics. I excel in driving business insights through data analytics and visualization, leveraging a robust foundation in crafting comprehensive data solutions. My expertise lies in optimizing data structures to enhance operational efficiency and derive targeted insights, making a significant impact in the domains of CRM Marketing and Logistics.


Skills:

Analytics 
  • Python / SQL
  • Tableau
  • Databricks
  • Pandas / Matplotlib


Engineering

  • Airflow
  • Airbyte
  • DBT
  • Docker & Compose


Database Management

  • Data Architecture
  • Data Modelling
  • Data Normalization & Warehousing
  • AWS, Azure & GC

Programmiersprachen

Python
Experte
SQL
Bash

Datenbanken

Python
Experte
SQL
Experte
AWS (Amazon Web Services)
Fortgeschritten
GCP (Google Cloud Platform)
DBT (Data build tool)
Experte
Data Vault 2.0
Fortgeschritten
Data Modellierung
Fortgeschritten

Einsatzorte

Einsatzorte

Hamburg (+10km)
Deutschland
möglich

Projekte

Projekte

7 Monate
2023-08 - 2024-02

Contributed to a system architecture concept

Data Engineer
Data Engineer
  • Contributed to a system architecture concept optimizing last mile logistics operations
  • Spearheaded the design and execution of a cutting-edge MVP Cloud Data Platform, leveraging GCP, empowering data-driven analytics and operational efficiency
  • Pioneered the implementation of an MVP Data Vault Model for last mile logistics utilizing DBT and datavault4dbt by ScalefreeCOM, modernizing data management strategies
  • Revamped outdated file-based reports into an impactful MVP Dashboard using Tableau, providing intuitive and actionable insights for improved decision-making
  • Played a pivotal role in providing expert guidance and consultation on data and system strategies in an internal company-wide digitization and modernization initiative, driving technological advancements and efficiency enhancements
FUNKE Logistik
Hamburg, Germany
10 Monate
2022-10 - 2023-07

Developed and maintained new and existing data pipelines

Data & Analytics Senior 
Data & Analytics Senior 
  • Developed and maintained new and existing data pipelines using Python and Transact SQL
  • Designed and implemented an automated OCR pipeline using AWS products (S3, SQS, Textract, and Lambda)
  • Collaborated and engineered multiple self-service dashboards for daily reporting and ad hoc business analytics using Databricks, Transact SQL, Python, and Tableau
  • Evaluated and coordinated various ad hoc analytics requests by clients with an existing nationwide data warehouse using Databricks, Redshift, and Python
  • Independently analyzed existing infrastructure and designed a new cloud-based data architecture concept to improve flexibility and uptime for clients
  • Collaborated on a real-time customer data platform via consulting and validation of data streams into Braze using Kafka and mParticle
  • Onboarded new co-workers and evaluated, planned, and oversaw large team projects


Highlighted Projects

  • Modernization and cloud migration of the inhouse data platform
    • Refactored an existing on-premise data platform and migrated it to the cloud
    • Streamlined data pipelines and reduced coding overhead by using standard formats and low-code tools
    • Improved data availability for in-house staff and clients and scaling options
  • CRM Communication Reporting for the German market of a global food chain
    • Analyzed and remodeled existing communication reporting based on business needs
    • Refactored the existing ETL process based on old and new requirements for up to 15 million events a day
    • Collaborated and coordinated the creation process of new self-service dashboards using Tableau
  • Business Insights Reporting for the German market of a global food chain
    • Automated ELT and business logic with over 50 KPIs
    • Engineered MSSQL procedures to store and monitor weekly data loads
    • Designed and assembled a compact Tableau dashboard to visualize target performance and progress
TRACK GmbH
Hamburg, Germany 
1 Jahr 1 Monat
2021-09 - 2022-09

Developed and maintained new and existing data pipelines

Data & Analytics Specialist
Data & Analytics Specialist
  • Developed and maintained new and existing data pipelines in our existing on-remise data warehouse and Tableau using Python and SQL
  • Maintained Tableau dashboards and executed ad hoc analytics and processing requests
TRACK GmbH
Hamburg, Germany
1 Jahr 1 Monat
2020-09 - 2021-09

Executed various ad hoc analytics and processing requests

Data & Analytics Junior
Data & Analytics Junior
  • Executed various ad hoc analytics and processing requests and developed new ETL pipelines for clients
TRACK GmbH
Hamburg, Germany

Aus- und Weiterbildung

Aus- und Weiterbildung

1 Monat
2020-03 - 2020-03

Game Art Animation, Upper Second

B.Sc. (Hons), SAE Institute Hamburg, Germany
B.Sc. (Hons)
SAE Institute Hamburg, Germany
 
1 Monat
2018-03 - 2018-03

Diplom 3D Art & Animation

1,95, SAE Institute Hamburg, Germany
1,95
SAE Institute Hamburg, Germany

Position

Position

  • Data Engineer | FUNKE Logistik | Hamburg, Germany| Aug 2023 - Feb 2024
  • Data & Analytics Senior | TRACK GmbH | Hamburg, Germany | Oct 2022 - July 2023
  • Data & Analytics Specialist | TRACK GmbH | Hamburg, Germany | Sept 2021 - Sept 2022
  • Data & Analytics Junior | TRACK GmbH | Hamburg, Germany | Sept 2020 - Sept 2021

Kompetenzen

Kompetenzen

Top-Skills

Datenarchitektur Big Data Datawarehouse Datenanalyse Business Intelligence Cloud Python SQL AWS Git Container

Produkte / Standards / Erfahrungen / Methoden

Profile:

Based in Hamburg, Germany, I am a Data Engineer with extensive experience in Data Platform Architecture, DevOps, and Data Modeling for CRM Marketing and Logistics. I excel in driving business insights through data analytics and visualization, leveraging a robust foundation in crafting comprehensive data solutions. My expertise lies in optimizing data structures to enhance operational efficiency and derive targeted insights, making a significant impact in the domains of CRM Marketing and Logistics.


Skills:

Analytics 
  • Python / SQL
  • Tableau
  • Databricks
  • Pandas / Matplotlib


Engineering

  • Airflow
  • Airbyte
  • DBT
  • Docker & Compose


Database Management

  • Data Architecture
  • Data Modelling
  • Data Normalization & Warehousing
  • AWS, Azure & GC

Programmiersprachen

Python
Experte
SQL
Bash

Datenbanken

Python
Experte
SQL
Experte
AWS (Amazon Web Services)
Fortgeschritten
GCP (Google Cloud Platform)
DBT (Data build tool)
Experte
Data Vault 2.0
Fortgeschritten
Data Modellierung
Fortgeschritten

Vertrauen Sie auf Randstad

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.