Stefan Auerbach

Data Scientist

Frankfurt, Germany
Experience
Nov 2023 - May 2024
7 months

Data Scientist

Trendence Institute

  • Analyzing and visualizing survey data (big data).
  • Infrastructure and database performance optimization.
  • AWS, GCP, BigQuery, SQL, Tableau, Python, Tableau Server.
Sep 2020 - Apr 2021
8 months

Data Scientist

Trendence Institute

  • Analyzing and visualizing survey data (big data).
  • Infrastructure and database performance optimization.
  • AWS, GCP, BigQuery, SQL, Tableau, Python, Tableau Server.
Aug 2020 - Oct 2023
3 years 3 months

Data Engineer

ProSiebenSat1/SevenOneMedia

  • Project management.
  • Data warehouse and ETL development.
  • Data layer development.
  • KPI development and analysis.
  • Implementation of ML algorithms such as outlier detection, forecasting.
  • Ad targeting and consumer behavior environment.
  • Migration of full stack to infrastructure as code in AWS (S3, RDS, RedShift, Glue, Athena, Lambda, Kinesis, PySpark, TerraForm, CloudFormation, Travis CI, Git).
  • Visualization with Tableau and Python.
  • Tableau Server maintenance.
  • Data backup and recovery strategy.
Jun 2020 - Aug 2020
3 months

Project Manager / Data Scientist

Optiopay

  • Management of a focus KPI reporting project in banking / ecommerce environment.
  • Definition and visualization of data pipelines and KPIs.
  • Azure, SQL, PowerBI, Kafka, Python, Git.
Jun 2019 - Feb 2020
9 months

Data Engineer

ProSiebenSat1/SevenOneMedia

  • Project management.
  • Data warehouse and ETL development.
  • Data layer development.
  • KPI development and analysis.
  • Implementation of ML algorithms such as outlier detection, forecasting.
  • Ad targeting and consumer behavior environment.
  • Migration of full stack to infrastructure as code in AWS (S3, RDS, RedShift, Glue, Athena, Lambda, Kinesis, PySpark, TerraForm, CloudFormation, Travis CI, Git).
  • Visualization with Tableau and Python.
  • Tableau Server maintenance.
  • Data backup and recovery strategy.
May 2018 - Apr 2019
1 year

Project Manager / Data Analyst

MediaMarktSaturn

  • Management of migration of reporting project to Tableau environment.
  • Rebuilding DWH layers and whole reporting system including key reports.
  • Data analytics and machine learning algorithms such as RFM, outliers, customer lifecycle.
  • SPSS, SAS, Tableau, PowerBI, TeraData, SQL, PowerShell.
Nov 2017 - Mar 2018
5 months

Data Consultant

Barkawi Consulting

  • Project for Dräxlmaier Group (BMW Supplier).
  • Supply chain logistics.
  • Modelling and unification of hundreds of different data sources and formats.
  • Big data analysis, cleansing, dashboarding with Spark, SQL, Qlik, R.
May 2017 - Present
8 years 3 months

Side Projects

  • Web scraping, 3D modelling, Advent of Code, machine learning, generative AI.
  • Analysis of Twitter and Youtube data.
  • Investor consulting.
May 2017 - Present
8 years 3 months
Frankfurt, Germany

Data Scientist & BI Professional

Self-Employed

  • Data science and engineering in various projects for AI, Finance & Insurance Maths clients such as ProSiebenSat1, MediaMarktSaturn, Dräxlmaier (BMW Supplier), Trendence, Optiopay.
  • Project management.
  • Leading of small teams (up to 5).
  • Implementation of ML algorithms.
  • Optimization of cloud infrastructure.
  • Visualization of big data.
  • Budgets between 200K-2M.
May 2015 - May 2017
2 years 1 month

Sr. BI Manager, Team Lead BI

MyLorry FoodExpress / Just Eat Takeaway

  • Responsible for BI infrastructure of FoodExpress and implementation of driver/demand forecasting.
  • Identifying high potential delivery areas.
  • Machine learning & analytics.
  • Reporting, modelling, visualizing.
Dec 2010 - Aug 2013
2 years 9 months
Germany

Trainee & Business Analyst

Deutsche Bahn AG

  • Started as Trainee in ICT and later Manager for complex Software Development Projects.
  • Project management.
  • Leading of small teams (up to 5).
  • Budgets between 500K-2M.
Summary

Getting your data, transforming, analyzing, training it and finally gaining insights. I cover the whole pipeline:

  • Scraping
  • ETL (Extract, Transform, Load)
  • Machine Learning
  • Aggregation
  • Visualization

Including but not limited to:

  • Python, PySpark, R, Java, JavaScript, Scala, SQL
  • Tableau, PowerBI, Qlik, Leaflet, Shiny
  • AWS, Google Cloud, Azure
  • Docker, Git, Terraform, Travis
Languages
German
Native
English
Advanced
Spanish
Intermediate
French
Elementary
Education
Oct 2005 - Jun 2010

University of Technology, Berlin

Diploma · Business Mathematics · Berlin, Germany

Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions